Re: 8.2 is 30% better in pgbench than 8.3

Поиск
Список
Период
Сортировка
От Josh Berkus
Тема Re: 8.2 is 30% better in pgbench than 8.3
Дата
Msg-id 46A37DCF.5070003@agliodbs.com
обсуждение исходный текст
Ответ на Re: 8.2 is 30% better in pgbench than 8.3  (Tom Lane <tgl@sss.pgh.pa.us>)
Ответы Re: 8.2 is 30% better in pgbench than 8.3
Список pgsql-hackers
Tom,

> Note to all: we ***HAVE TO*** settle on some reasonable default
> vacuum_cost_delay settings before we can ship 8.3.  With no cost delay
> and two or three workers active, 8.3's autovac does indeed send
> performance into the tank.

I've been using 20ms for most of my setups.  That's aimed at reducing 
autovac to almost no impact at all, but taking a long time.  Maybe 10ms?

--Josh



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

Предыдущее
От: Josh Berkus
Дата:
Сообщение: Re: 8.2 is 30% better in pgbench than 8.3
Следующее
От: "Florian G. Pflug"
Дата:
Сообщение: Full page images in WAL & Cache Invalidation