| From: | Andreas Kretschmer <andreas(at)a-kretschmer(dot)de> |
|---|---|
| To: | "David G(dot) Johnston" <david(dot)g(dot)johnston(at)gmail(dot)com> |
| Cc: | ivo liondov <ivo(dot)liondov(at)gmail(dot)com>, "pgsql-sql(at)postgresql(dot)org" <pgsql-sql(at)postgresql(dot)org> |
| Subject: | Re: delete taking long time |
| Date: | 2016-03-16 01:34:52 |
| Message-ID: | 62238924.9201.1458092092795.JavaMail.open-xchange@oxweb01.ims-firmen.de |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-sql |
>
> Given the lack of indexes on the one table that is shown I suspect this is
> the most likely cause (FK + indexes)
>
right, there should be an index on ts. If it is a 9.5 AND the rows are ordered
on ts a BRIN-index would be fine.
If not - a normal index. How many rows contains the table?
--
Andreas Kretschmer
http://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Mike Sofen | 2016-03-16 01:49:25 | Re: delete taking long time |
| Previous Message | David G. Johnston | 2016-03-16 01:25:59 | Re: delete taking long time |