Hi all,
i have 5 servers that have been installing postgresql .In order to
know the postgresql working status and monitor them ,moreover i don't want
to use the monitor tools .I want to use the SQL commands to monitoring
postgresql system . please suggest any SQL COMMANDS to work succes
On 09/03/2012 01:27 PM, Jeff Janes wrote:
In any case, the behavior you report is exactly would would be
expected if autovacuum is not running. The config file you posted
shows autovac is turned on, but I suspect that is not the config file
actually being used by the running server.
It's also
On 08/02/2012 02:02 PM, Peter Geoghegan wrote:
I made what may turn out to be a useful observation during the
development of the patch, which was that for both the tpc-b.sql and
insert.sql pgbench-tools scripts, a commit_delay of half of my
wal_sync_method's reported raw sync speed looked optimal
On 09/06/2012 07:48 AM, Anibal David Acosta wrote:
Using explain analyze I saw that many of my queries run really fast,
less than 1 milliseconds, for example the analyze output of a simple
query over a table with 5millions of records return "Total runtime:
0.078 ms"
But the real time is a lot
Using explain analyze I saw that many of my queries run really fast, less
than 1 milliseconds, for example the analyze output of a simple query over a
table with 5millions of records return "Total runtime: 0.078 ms"
But the real time is a lot more, about 15 ms, in fact the pgadmin show this
v