From: | Bill Preston <billpreston(at)crownepointe(dot)net> |
---|---|
To: | pgsql-performance(at)postgresql(dot)org |
Subject: | Re: Slow insert performace, 8.3 Wal related? |
Date: | 2009-01-15 22:36:19 |
Message-ID: | 496FBA63.80405@crownepointe.net |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-performance |
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.
>
From | Date | Subject | |
---|---|---|---|
Next Message | M. Edward (Ed) Borasky | 2009-01-16 06:03:01 | Re: understanding postgres issues/bottlenecks |
Previous Message | Scott Marlowe | 2009-01-15 22:32:39 | Re: Slow insert performace, 8.3 Wal related? |