Re: Slow insert performace, 8.3 Wal related?

Thanks Scott.

We are in Southern California.
What I need someone for when the SHTF again, and if I can't handle it,
I have some resource to get on the job right away. And it would help if
they were a company that does this kind of thing so that I can get some
buy in from those above.

Rusty
Scott Marlowe wrote:
> On Thu, Jan 15, 2009 at 2:55 PM, Bill Preston
> <billpreston(at)crownepointe(dot)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.
>