Herouth Maoz writes:
> On 29/11/2011, at 09:13, Tom Lane wrote:
>> Yup, that's a clue all right. I'll bet a nickel that you don't
>> have an index on the foreign key's referencing column (ie,
>> sent_messages.subscription_id). That means each delete in
>> the referenced table has to seqscan the
On 29/11/2011, at 09:13, Tom Lane wrote:
> "Herouth Maoz" writes:
>> I was instructed to delete old records from one of the tables in our
>> production system. The deletion took hours and I had to stop it in
>> mid-operation and reschedule it as a night job. But then I had to do the
>> same w
"Herouth Maoz" writes:
> I was instructed to delete old records from one of the tables in our
> production system. The deletion took hours and I had to stop it in
> mid-operation and reschedule it as a night job. But then I had to do the same
> when I got up in the morning and it was still runn
