Re: "critical mass" reached?

> Hm.  As Richard remarks, 6M records is not an especially big table;
> there are people running larger ones.  The leftover sorttemp files sound
> like you are suffering backend crashes --- but you didn't mention
> anything about unexpected disconnects.

I haven't noticed any myself, but the majority of our connections come from a
public web based app -- so I can't really tell if the consumer is experiencing
problems or not.

> The postmaster log would be a good place to look for more info (if
> you're not keeping one, turn it on).

I have a debug level 2 log of almost the entire day's activity. I scanned it
briefly but found nothing (it's 180 meg). Is there anything in particular I
should be looking for?

>  Also, make sure the postmaster is not being run with an environment of
> "ulimit -c 0" ... if the backends are crashing, we want to get some core
> files so we can see what's happening.

Ok, will verify. Thanks.

--
Alex Howansky
Wankwood Associates
http://www.wankwood.com/