On Wed, 2005-08-31 at 07:18, Bohdan Linda wrote:
> >
> > From the postgresql manual
> > http://www.postgresql.org/docs/8.0/interactive/maintenance.html :
> > " The standard form of VACUUM is best used with the goal of maintaining
> > a fairly level steady-state usage of disk space. If you need t
Bohdan Linda wrote:
From the postgresql manual
http://www.postgresql.org/docs/8.0/interactive/maintenance.html :
" The standard form of VACUUM is best used with the goal of maintaining
a fairly level steady-state usage of disk space. If you need to return
disk space to the operating system you
01 69 29 36 18
---
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] Behalf Of Bohdan Linda
Sent: mercredi 31 aout 2005 14:19
To: Ben-Nes Yonatan
Cc: pgsql-general@postgresql.org
Subject: Re: [GENERAL] detecti
>
> From the postgresql manual
> http://www.postgresql.org/docs/8.0/interactive/maintenance.html :
> " The standard form of VACUUM is best used with the goal of maintaining
> a fairly level steady-state usage of disk space. If you need to return
> disk space to the operating system you can use
Bohdan Linda wrote:
On Tue, Aug 30, 2005 at 06:07:24PM +0200, Michael Fuhr wrote:
tables, and a VACUUM might start or complete immediately after you
issue the query but before you read the results). This method is
therefore unreliable.
I intend to do the VACUUM FULL during quiet hours, thus
On Tue, Aug 30, 2005 at 06:07:24PM +0200, Michael Fuhr wrote:
> tables, and a VACUUM might start or complete immediately after you
> issue the query but before you read the results). This method is
> therefore unreliable.
I intend to do the VACUUM FULL during quiet hours, thus the chance of
fitti
On Tue, Aug 30, 2005 at 05:35:13PM +0200, Bohdan Linda wrote:
>
> Is there any way how to detect running command VACUUM by reading pg_* tables?
If you have stats_command_string enabled then you could query
pg_stat_activity, but be aware that the results will be stale by
the time you see them (the
Bohdan Linda <[EMAIL PROTECTED]> writes:
> Is there any way how to detect running command VACUUM by reading pg_* tables?
> The idea is to detectect when table is not accessible due maintainance.
Um, ordinary VACUUM doesn't render the table "not accessible". If
you're using VACUUM FULL, maybe the
Hello,
Is there any way how to detect running command VACUUM by reading pg_* tables?
The idea is to detectect when table is not accessible due maintainance. The
approach of explicitely setting a flag into status table is not very
convenient, while I want to cover also non-systematic launching
