Sorry It's not in the contrib folder of PostgreSQL ... but you will find it on
gborg.postgresql.org !
Regards,
Le vendredi 25 Juin 2004 22:51, Hervé Piedvache a écrit :
> Let see in contrib/ the application pg_who ... you will see the process,
> the queries, and the CPU ... ;o)
>
> Regards,
>
>
Hi Richard,
Thanks so much for replying. Pls see below.
Thanks in advance for any advice,
Chris
> People are going to need more information. Are you talking about
> CPU/disk IO/memory?
## CPU is at 100%.
>
> > My settings are default on both boxes I think.
>
> Doubtful - PG crawls with the de
Let see in contrib/ the application pg_who ... you will see the process,
the queries, and the CPU ... ;o)
Even easier:
SELECT * FROM pg_stat_activity;
As a superuser.
Chris
---(end of broadcast)---
TIP 5: Have you checked our extensive FAQ?
Chris Cheston <[EMAIL PROTECTED]> writes:
> shared_buffers = 40 # min 16, at least max_connections*2, 8KB each
This is ridiculously low for any kind of production server. Try
something like 5000-1 for a start.
-Doug
---(end of broadcast)
Hello,
Not to mention upping your effective_cache.
Doug McNaught wrote:
Chris Cheston <[EMAIL PROTECTED]> writes:
shared_buffers = 40 # min 16, at least max_connections*2, 8KB each
This is ridiculously low for any kind of production server. Try
something
Christopher Kings-Lynne <[EMAIL PROTECTED]> writes:
> Even easier:
> SELECT * FROM pg_stat_activity;
But note you must enable stats_command_string to make this very useful.
regards, tom lane
---(end of broadcast)---
TIP 9: t
Hi all,
I upped effective_cache to 16000 KB and I could only up the
shared_buffers to 3000. Anything more and postgres would not start.
Postmaster is still using lots of CPU. pg_stat_activity shows only
query is happening at a time so the requests are probably queueing on
this one thread. Is th
I upped effective_cache to 16000 KB and I could only up the
shared_buffers to 3000. Anything more and postgres would not start.
You need to greatly incrase the shared memory max setting on your
machine so that you can use at the very least, 1 shared buffers.
Chris
---