Harald Fuchs escribió:
> In article <20090204165933.gb32...@alvh.no-ip.org>,
> Alvaro Herrera writes:
>
> > Marc Mamin wrote:
> >> There are 2 features that would be helpfull in my case:
> >>
> >> - define vacuum properties on table groups rather than on given tables:
> > Hmm. I'm not really s
In article <20090204165933.gb32...@alvh.no-ip.org>,
Alvaro Herrera writes:
> Marc Mamin wrote:
>> There are 2 features that would be helpfull in my case:
>>
>> - define vacuum properties on table groups rather than on given tables:
>>
>> For example, I don't want to vacuum daily tables which ca
Marc Mamin wrote:
> There are 2 features that would be helpfull in my case:
>
> - define vacuum properties on table groups rather than on given tables:
>
> For example, I don't want to vacuum daily tables which can be
> identified with a regexp:
> tablename ~ '\.*d_[0-9]{8}'
Hmm. I
autovacuum question
Hello,
I'not using autovacuum as the largest part of my tables are filled with
COPY FROM, not modified afterward and dropped when obsolete.
Other tables are regularily vacuumed from an application driven job
that knows which tables were modified recently.
(It also vacuums th
On Wednesday 04 April 2007 20:40, Carol Walter wrote:
| Hi, I'm looking in my log file with today's date. I'm using VIM and
| have done a search for a pattern match on "autovac", "vacuum", and
| "auto" VIM returned "string not found" for each search. Am I
| looking for the wrong string, or is t
Hi, I'm looking in my log file with today's date. I'm using VIM and
have done a search for a pattern match on "autovac", "vacuum", and
"auto" VIM returned "string not found" for each search. Am I
looking for the wrong string, or is there another log file I should
be looking at?
Carol
Carol Walter wrote:
> I ran the command "show autovacuum" and postgres responds with "ON."
> My colleague says that I should be able to see it running if I run ps
> -aef. He said that he doesn't trust postgres reporting on itself.
I wouldn't trust your colleague then ...
> When I run the
Hi,
On Friday 30 March 2007 16:43, Carol Walter wrote:
| I ran the command "show autovacuum" and postgres responds with "ON."
| My colleague says that I should be able to see it running if I run ps
| -aef. He said that he doesn't trust postgres reporting on itself.
| When I run the Unix ps comman
I ran the command "show autovacuum" and postgres responds with "ON."
My colleague says that I should be able to see it running if I run ps
-aef. He said that he doesn't trust postgres reporting on itself.
When I run the Unix ps command as above I don't see autovacuum. Does
anyone know if
Laszlo Nagy wrote:
> Jim Nasby írta:
> >Autovacuum doesn't launch a separate daemon; you'll only see an
> >autovac process when an autovac is actually working.
> Where should I see it? The output of "ps ax | grep auto" is empty. Does
> it mean that auto vacuum is not running? How can I check if t
Jim Nasby írta:
Autovacuum doesn't launch a separate daemon; you'll only see an
autovac process when an autovac is actually working.
Where should I see it? The output of "ps ax | grep auto" is empty. Does
it mean that auto vacuum is not running? How can I check if there is a
problem?
Also, 8.
Autovacuum doesn't launch a separate daemon; you'll only see an
autovac process when an autovac is actually working.
Also, 8.1 has code to prevent wraparound, so that's not it (see
backend/access/transam/varsup.c)
On Mar 27, 2007, at 5:17 AM, Laszlo Nagy wrote:
Hello,
I had a problem i
Hello,
I had a problem in my computer system yesterday. Some data has
disappeared. I was looking for a program that might have deleted it
accidentally. Before I found anything, the data suddenly came back. I
thought it must be a transaction id wraparound problem.
The system is running on F
On Tue, May 16, 2006 at 10:30:26AM -0700, Mark Liberman wrote:
> >Does this mean that each run of autovacuum will vacuum/analyze all tables
> >that need work in the database that autovacuum is looking at?
>
> Yes, it will do all tables that satisfy the criteria.
>
> >Also, with over 200 databases
I just happened to be reading this page from
the 8.1 docs:
"The autovacuum daemon, when enabled, runs
every autovacuum_naptime seconds and
determines which database to process. Any database which is close to transaction
ID wraparound is immediately processed. In this case, autovacuum issue
Title: RE: [ADMIN] Autovacuum Question
>Does this mean that each run of autovacuum will vacuum/analyze all tables
>that need work in the database that autovacuum is looking at?
Yes, it will do all tables that satisfy the criteria.
>Also, with over 200 databases, does this me
PostgreSQL 8.1.3Question on autovacuum.autovacuum_naptime (integer) Specifies the delay between activity rounds for the autovacuum subprocess. In each round the subprocess examines one database and issues VACUUM and ANALYZE commands as needed for tables in that database. The delay is measured in se
17 matches
Mail list logo
