Skip site navigation (1) Skip section navigation (2)

Re: Slow insert performace, 8.3 Wal related?

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 (view raw or flat)
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.
>   


In response to

Responses

pgsql-performance by date

Next:From: M. Edward (Ed) BoraskyDate: 2009-01-16 06:03:01
Subject: Re: understanding postgres issues/bottlenecks
Previous:From: Scott MarloweDate: 2009-01-15 22:32:39
Subject: Re: Slow insert performace, 8.3 Wal related?

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group