Answer the question
In order to leave comments, you need to log in
Why is postgres deleting data so slow?
There is a table with such a structure (I post the generated html) rghost.ru/6WG8l7PMN (please don't kick me, I didn't design it).
It is necessary to delete all data from there before 2014 and after 2015. Here is the request itself:
DELETE FROM
request.request
WHERE request.agreed <= '2014-01-01'
OR request.agreed >= '2015-01-01'
Answer the question
In order to leave comments, you need to log in
Didn't find what you were looking for?
Ask your questionAsk a Question
731 491 924 answers to any question