Request a Demo
Home   >   mailing lists

Re: trying to delete most of the table by range of date col - Mailing list pgsql-performance

From Justin Pryzby
Subject Re: trying to delete most of the table by range of date col
Date
Msg-id 20180903092300.GC11702@telsasoft.com
Whole thread Raw
In response to Re: trying to delete most of the table by range of date col  (Mariel Cherkassky <mariel.cherkassky@gmail.com>)
Responses Re: trying to delete most of the table by range of date col
List pgsql-performance
Tree view 
On Mon, Sep 03, 2018 at 11:17:58AM +0300, Mariel Cherkassky wrote:
> Hi,
> I already checked and on all the tables that uses the id col of the main
> table as a foreign key have index on that column.
> 
> So, it seems that the second solution is the fastest one. It there a reason
> why the delete chunks (solution 4) wasnt faster?

I suggest running:

SET track_io_timing=on; -- requires superuser
explain(ANALYZE,BUFFERS) DELETE [...]

https://wiki.postgresql.org/wiki/Slow_Query_Questions

Maybe you just need larger shared_buffers ?

Justin

pgsql-performance by date:

Previous
From: Mariel Cherkassky
Date:
Subject: Re: trying to delete most of the table by range of date col
Next
From: Mariel Cherkassky
Date:
Subject: Re: trying to delete most of the table by range of date col