Re: Huge performance problem between 7.4.1 and 8.0.3 - CS issue?

Поиск
Список
Период
Сортировка
От Robert Creager
Тема Re: Huge performance problem between 7.4.1 and 8.0.3 - CS issue?
Дата
Msg-id 20050718122103.0000064a@C118181.stortek.com
обсуждение исходный текст
Ответ на Re: Huge performance problem between 7.4.1 and 8.0.3 - CS issue?  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-performance
On Mon, 18 Jul 2005 13:52:53 -0400
Tom Lane <tgl@sss.pgh.pa.us> wrote:

> Start a fresh psql session and "SHOW vacuum_cost_delay" to verify what
> the active setting is.

Thanks.  It does show 0 for 803 in a session that was up since I thought I had
HUPed the server with the new value.

This is leading me to believe that 803 doesn't do very well with VACUUM ANALYZE
running often, at least in my particular application...  I will provide a more
definitive statement to that affect, hopefully tonight.

Cheers,
Rob

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

Предыдущее
От: "Kevin Grittner"
Дата:
Сообщение: Re: join and query planner
Следующее
От: Vivek Khera
Дата:
Сообщение: Re: Impact of checkpoint_segments under continual load conditions