| From: | Justin Pryzby <pryzby(at)telsasoft(dot)com> |
|---|---|
| To: | Mariel Cherkassky <mariel(dot)cherkassky(at)gmail(dot)com> |
| Cc: | Andreas Kretschmer <andreas(at)a-kretschmer(dot)de>, pgsql-performance(at)lists(dot)postgresql(dot)org |
| Subject: | Re: trying to delete most of the table by range of date col |
| Date: | 2018-09-03 09:23:01 |
| Message-ID: | 20180903092300.GC11702@telsasoft.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-admin pgsql-performance |
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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Mariel Cherkassky | 2018-09-03 10:25:04 | Re: trying to delete most of the table by range of date col |
| Previous Message | Achilleas Mantzios | 2018-09-03 09:05:57 | Re: Heavy Logging in Subscriber side when configured Logical Replication in 10.4 |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Mariel Cherkassky | 2018-09-03 10:25:04 | Re: trying to delete most of the table by range of date col |
| Previous Message | Mariel Cherkassky | 2018-09-03 08:50:55 | Re: trying to delete most of the table by range of date col |