From: | "Scott Marlowe" <scott(dot)marlowe(at)gmail(dot)com> |
---|---|
To: | "Bill Preston" <billpreston(at)crownepointe(dot)net> |
Cc: | pgsql-performance(at)postgresql(dot)org |
Subject: | Re: Slow insert performace, 8.3 Wal related? |
Date: | 2009-01-15 22:32:39 |
Message-ID: | dcc563d10901151432w396780c4i41534fe0f939f9f3@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-performance |
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 | Bill Preston | 2009-01-15 22:36:19 | Re: Slow insert performace, 8.3 Wal related? |
Previous Message | Bill Preston | 2009-01-15 21:55:51 | Re: Slow insert performace, 8.3 Wal related? |