Re: Slow insert performace, 8.3 Wal related?
От | Scott Marlowe |
---|---|
Тема | Re: Slow insert performace, 8.3 Wal related? |
Дата | |
Msg-id | dcc563d10901151432w396780c4i41534fe0f939f9f3@mail.gmail.com обсуждение исходный текст |
Ответ на | Re: Slow insert performace, 8.3 Wal related? (Bill Preston <billpreston@crownepointe.net>) |
Ответы |
Re: Slow insert performace, 8.3 Wal related?
|
Список | pgsql-performance |
On Thu, Jan 15, 2009 at 2:55 PM, Bill Preston <billpreston@crownepointe.net> wrote: > Nothing special about that table. One index. > > It really seems that the system would grind to a stand-still when a lot of > non-transaction inserts were run combined with the creation of some large > temp tables. > > Since we added transactions and started using truncate, things have cleared > up nicely. The suggestions here really helped. > > Does anyone know of some established postgresql consultants that can be > hired for emergency analysis/tuning when things come up? There are several companies who have employees on this list who provide for fee contract / consulting work. If you're local to me and need help over a weekend I might have some spare time. :) But I'm generally pretty busy on weekends.
В списке pgsql-performance по дате отправления: