Re: Question regarding performance (large objects involved)

Поиск
Список
Период
Сортировка
От Mark Kirkwood
Тема Re: Question regarding performance (large objects involved)
Дата
Msg-id 3EFAA9A3.9000707@paradise.net.nz
обсуждение исходный текст
Ответ на Question regarding performance (large objects involved)  (u15074 <u15074@hs-harz.de>)
Ответы Re: Question regarding performance (large objects involved)  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-general
Could be the the database is checkpointing then. Try experimenting with :

checkpoint_segments
checkpoint_timeout

Might be worth playing with :

wal_buffers

as well

regards

Mark

u15074 wrote:

>The performance is ok and stays constant over the whole time. But I have the
>following effect: from time to time a short interruption occurs (my test program
>is standing still for a moment) and then it goes on.
>Has anyone an idea what might cause these pauses? Is it due to caching
>mechanisms of the database?
>
>



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

Предыдущее
От: "Shridhar Daithankar"
Дата:
Сообщение: Re: How many fields in a table are too many
Следующее
От: Benjamin Jury
Дата:
Сообщение: FW: INSERT WHERE NOT EXISTS