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@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
