Re: Slow "Select count(*) ..." query on table with 60 Mio. rows

Поиск
Список
Период
Сортировка
От Greg Smith
Тема Re: Slow "Select count(*) ..." query on table with 60 Mio. rows
Дата
Msg-id 4B4F5C0E.6050506@2ndquadrant.com
обсуждение исходный текст
Ответ на Re: Slow "Select count(*) ..." query on table with 60 Mio. rows  ("Kevin Grittner" <Kevin.Grittner@wicourts.gov>)
Ответы Re: Slow "Select count(*) ..." query on table with 60 Mio. rows
Список pgsql-performance
Дерево обсуждения
Kevin Grittner wrote: 
Matthew Wakeling <matthew@flymine.org> wrote: 
This is an FAQ.   
 
I just added it to the wiki FAQ page:
http://wiki.postgresql.org/wiki/FAQ#Why_is_.22SELECT_count.28.2A.29_FROM_bigtable.3B.22_slow.3F
The content was already there, just not linked into the main FAQ yet:  http://wiki.postgresql.org/wiki/Slow_Counting

-- 
Greg Smith    2ndQuadrant   Baltimore, MD
PostgreSQL Training, Services and Support
greg@2ndQuadrant.com  www.2ndQuadrant.com

В списке pgsql-performance по дате отправления:

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: bad execution plan for subselects containing windowing-function
Следующее
От: Andreas Kretschmer
Дата:
Сообщение: Re: bad execution plan for subselects containing windowing-function