Re: big select is resulting in a large amount of disk writing by kjournald

Поиск
Список
Период
Сортировка
От Greg Smith
Тема Re: big select is resulting in a large amount of disk writing by kjournald
Дата
Msg-id 4B200054.3020209@2ndquadrant.com
обсуждение исходный текст
Ответ на big select is resulting in a large amount of disk writing by kjournald  (Joseph S <jks@selectacast.net>)
Ответы Re: big select is resulting in a large amount of disk writing by kjournald  (Joseph S <jks@selectacast.net>)
Список pgsql-performance
Дерево обсуждения 
Joseph S wrote:
> So I run "select count(*) from large_table" and I see in xosview a
> solid block of write activity. Runtime is 28125.644 ms for the first
> run.  The second run does not show a block of write activity and takes
> 3327.441 ms
http://wiki.postgresql.org/wiki/Hint_Bits

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

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

Предыдущее
От: Kenneth Marshall
Дата:
Сообщение: Re: big select is resulting in a large amount of disk writing by kjournald
Следующее
От: Joseph S
Дата:
Сообщение: Re: big select is resulting in a large amount of disk writing by kjournald