Re: Lock during insert statement

Поиск
Список
Период
Сортировка
От Jeff Janes
Тема Re: Lock during insert statement
Дата
Msg-id CAMkU=1z2dGJQWhnEfizWBQh2uSax634hnH3vUKYts0QT19FKoA@mail.gmail.com
обсуждение исходный текст
Ответ на Re: Lock during insert statement  (AI Rumman <rummandba@gmail.com>)
Список pgsql-general
Дерево обсуждения
On Wednesday, May 21, 2014, AI Rumman <rummandba@gmail.com> wrote:
Got it. 
Thanks. 
Any special parameter to tune it? Like wal_buffers or shared_buffers?

Possible but unlikely.  You probably just need  better hardware (or more patience).  How fast is the database growing? How much is actually being written (sar, vmstat)?  What is the expected theoretical write throughput of your RAID?
 
Cheers,

Jeff

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

Предыдущее
От: David G Johnston
Дата:
Сообщение: Re: Question regarding DEALLOCATE pdo_stmt_00000001
Следующее
От: Joe Van Dyk
Дата:
Сообщение: Re: Do foreign key triggers get ran even if the key's value doesn't change?