Re: PG writes a lot to the disk

Поиск
Список
Период
Сортировка
От Laurent Raufaste
Тема Re: PG writes a lot to the disk
Дата
Msg-id 669dc9710803210645m530b492cs6de98f215bcecb23@mail.gmail.com
обсуждение исходный текст
Ответ на Re: PG writes a lot to the disk  (Gregory Stark <stark@enterprisedb.com>)
Ответы Re: PG writes a lot to the disk  (Bill Moran <wmoran@collaborativefusion.com>)
Список pgsql-performance
2008/3/21, Gregory Stark <stark@enterprisedb.com>:
>
> Well that's true it does. But only once per row. So analyze would have set the
>  bit on every row. You could do the same thing with something ligter like
>  "select count(*) from <table>".

Well, the table has been analyzed, I did SELECT, PG write on the
table. That's a fact.

But it's also true (I juste tested it) that every file of a table is
modified by a SELECT COUNT.
>
>  Tom's thinking was that you would only expect a high update rate for a short
>  time until all those bits were set.
>
>  Slony's inserts, updates, and deletes count as updates to the table as well.
>

Slony is shut down when I'm testing.

--
Laurent Raufaste
<http://www.glop.org/>

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

Предыдущее
От: Gregory Stark
Дата:
Сообщение: Re: PG writes a lot to the disk
Следующее
От: Bill Moran
Дата:
Сообщение: Re: PG writes a lot to the disk