Re: Impact of checkpoint_segments under continual load conditions

Поиск
Список
Период
Сортировка
От Christopher Petrilli
Тема Re: Impact of checkpoint_segments under continual load conditions
Дата
Msg-id 59d991c405072009163b149809@mail.gmail.com
обсуждение исходный текст
Ответ на Re: Impact of checkpoint_segments under continual load conditions  (Christopher Petrilli <petrilli@gmail.com>)
Список pgsql-performance
On 7/19/05, Christopher Petrilli <petrilli@gmail.com> wrote:
> It looks like the CVS HEAD is definately "better," but not by a huge
> amount.  The only difference is I wasn't run autovacuum in the
> background (default settings), but I don't think this explains it.
> Here's a graph of the differences and density of behavior:
>
> http://blog.amber.org/diagrams/pgsql_copy_803_cvs.png
>
> I can provide the raw data.  Each COPY was 500 rows.  Note that fsync
> is turned off here.  Maybe it'd be more stable with it turned on?

I've updated this with trend-lines.

Chris

--
| Christopher Petrilli
| petrilli@gmail.com

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

Предыдущее
От: Christopher Petrilli
Дата:
Сообщение: Re: Impact of checkpoint_segments under continual load conditions
Следующее
От: Richard Huxton
Дата:
Сообщение: Re: Optimizer seems to be way off, why?