I think I can answer this cause I recently had a similar problem. There is a
voodoo setting in postgresql called "analyze target". It controls how much
statistic information is kept per table. This information affects the query
planner. If it makes a bad guess based on insufficient statistics da
So can anyone offer any insight on this? BTW, I tried reposting it with
attachments and it didn't show up.
thanks,
Eugene
>
> From: <[EMAIL PROTECTED]>
> Date: 2005/08/18 Thu AM 09:24:30 EST
> To:
> Subject: [GENERAL] total db lockup
>
> (NOTE: reposting this for the *fifth* time because my
(NOTE: reposting this for the *fifth* time because my previous messages didn't
go through).
Hi all,
We have experienced a really weird problem with
postgresql yesterday. When I was called in to take a
look, all the non-superuser connections were used up
and they were all in a waiting state (SEL
