| From: | Alvaro Herrera <alvherre(at)2ndquadrant(dot)com> |
|---|---|
| To: | Michael Malis <michaelmalis2(at)gmail(dot)com> |
| Cc: | Pg Hackers <pgsql-hackers(at)postgresql(dot)org> |
| Subject: | Re: Highly Variable Planning Times |
| Date: | 2017-04-19 20:49:45 |
| Message-ID: | 20170419204945.ixqv5cjwh3hkpgu6@alvherre.pgsql |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
Michael Malis wrote:
> Hi,
>
> I've been encountering highly variable planning time on PG 9.5.4.
> Running `EXPLAIN SELECT * FROM events_1171738` will take anywhere from
> 200ms to 4s. This likely has to do with the table having 1300 partial
> indexes on it (for reasons elaborated on in
> https://blog.heapanalytics.com/running-10-million-postgresql-indexes-in-production/)
> I'm trying to figure out if there is something I can do to eliminate
> the slow planning from happening.
I wonder if some BRIN index could help this use case, reducing the
number of indexes.
--
Álvaro Herrera https://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tom Lane | 2017-04-19 20:58:38 | Re: Highly Variable Planning Times |
| Previous Message | Andres Freund | 2017-04-19 20:47:14 | Re: Highly Variable Planning Times |