On Thu, Jan 15, 2009 at 2:55 PM, Bill Preston <billpreston@xxxxxxxxxxxxxxxx> 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. -- Sent via pgsql-performance mailing list (pgsql-performance@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance
