David Mitchell wrote:
If your table has got into this state, then vacuum analyze won't fix
it. You will have to do a vacuum full to get it back to normal, then
regularly vacuum (not full) to keep it in good condition. We vacuum
our critical tables every 10 minutes to keep them in good nick.
If your table has got into this state, then vacuum analyze won't fix it.
You will have to do a vacuum full to get it back to normal, then
regularly vacuum (not full) to keep it in good condition. We vacuum our
critical tables every 10 minutes to keep them in good nick.
David
Dennis wrote:
Da
David Mitchell wrote:
What is the load average on this machine? Do you do many updates? If
you do a lot of updates, perhaps you haven't vacuumed recently. We
were seeing similar symptoms when we started load testing our stuff
and it turned out we were vacuuming too infrequently.
The load ave
What is the load average on this machine? Do you do many updates? If you
do a lot of updates, perhaps you haven't vacuumed recently. We were
seeing similar symptoms when we started load testing our stuff and it
turned out we were vacuuming too infrequently.
David
Dennis wrote:
Qingqing Zhou
Qingqing Zhou wrote:
Are you sure 100% CPU usage is solely contributed by Postgresql? Also, from
the ps status you list, I can hardly see that's a problem because of problem
you mentioned below.
The postgreSQL processes are what is taking up all the cpu. There aren't
any other major applicat
"Dennis" <[EMAIL PROTECTED]> writes
>
> checking the status of connections at this point ( ps -eaf | grep
> "postgres:") where the CPU is maxed out I saw this:
>
> 127 idle
> 12 bind
> 38 parse
> 34 select
>
Are you sure 100% CPU usage is solely contributed by Postgresql? Also, from
the ps statu
Hi,
I've got a java based web application that uses PostgreSQL 8.0.2.
PostgreSQL runs on its own machine with RHEL 3, ia32e kernel, dual Xeon
processor, 4 Gb ram.
The web application runs on a seperate machine from the database. The
application machine has three tomcat instances configured t
