Re: Plan time Improvement - 64bit bitmapset

Поиск
Список
Период
Сортировка
Искать
От
Kevin Grittner
Тема
Re: Plan time Improvement - 64bit bitmapset
Дата
Msg-id
4A266712020000250002740F@gw.wicourts.gov
Ответ на
Список
Дерево обсуждения
Plan time Improvement - 64bit bitmapset Andres Freund <andres@anarazel.de>
Re: Plan time Improvement - 64bit bitmapset "Kevin Grittner" <Kevin.Grittner@wicourts.gov>
Re: Plan time Improvement - 64bit bitmapset Andres Freund <andres@anarazel.de>
Re: Plan time Improvement - 64bit bitmapset Gregory Stark <stark@enterprisedb.com>
Re: Plan time Improvement - 64bit bitmapset Tom Lane <tgl@sss.pgh.pa.us>
Re: Plan time Improvement - 64bit bitmapset Andres Freund <andres@anarazel.de>
Re: Plan time Improvement - 64bit bitmapset Tom Lane <tgl@sss.pgh.pa.us>
Re: Plan time Improvement - 64bit bitmapset Andres Freund <andres@anarazel.de>
Re: Plan time Improvement - 64bit bitmapset Tom Lane <tgl@sss.pgh.pa.us>
Re: Plan time Improvement - 64bit bitmapset Andres Freund <andres@anarazel.de>
Re: Plan time Improvement - 64bit bitmapset Andres Freund <andres@anarazel.de>
Re: Plan time Improvement - 64bit bitmapset "Kevin Grittner" <Kevin.Grittner@wicourts.gov>
Re: Plan time Improvement - 64bit bitmapset Andres Freund <andres@anarazel.de>
Re: Plan time Improvement - 64bit bitmapset Gregory Stark <stark@enterprisedb.com>
Re: Plan time Improvement - 64bit bitmapset Andres Freund <andres@anarazel.de>
Andres Freund  wrote: 
> long plan times (minutes and up)
Wow.  I thought I had some pretty complex queries, including some
which join using several views, each of which has several joins; but
I've never gone to multiple seconds on plan time (much less multiple
minutes!) without very high statistics targets and many indexes on the
tables.  Any rough estimates on those?
If you think your patch could have a significant impact on a query
with a 260 ms plan time, I could give it a try.
-Kevin

В списке pgsql-hackers по дате отправления
От: Alvaro Herrera
Дата:
Сообщение: Re: pg_migrator status for 8.4
От: Tom Lane
Дата:
FAQ