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.