Hi Tom & Alvaro,
> Hey,
>
> > > They are all under 200 million
> >
> > Weird
> >
> > Could you fetch from pg_stat_activity the table it's processing, and its
> > pg_class row and that of its toast table (if any)?
>
> Sorry for the delay. Required details are at
> http://pastebin.com/pastebin.php?d
Hey,
> > They are all under 200 million
>
> Weird
>
> Could you fetch from pg_stat_activity the table it's processing, and its
> pg_class row and that of its toast table (if any)?
Sorry for the delay. Required details are at
http://pastebin.com/pastebin.php?dl=fd699fbb
Let me know if you need
Hi,
Tom Lane sss.pgh.pa.us> writes:
> Dushyanth gmail.com> writes:
> >> Tom Lane sss.pgh.pa.us> writes:
> >> Then the only other possibility is that autovacuum is being launched to
> >> prevent XID wraparound. Are there any tables in that database with
> >> particularly old relfrozenxid?
>
>
Dushyanth <[EMAIL PROTECTED]> writes:
>> Tom Lane sss.pgh.pa.us> writes:
>> Then the only other possibility is that autovacuum is being launched to
>> prevent XID wraparound. Are there any tables in that database with
>> particularly old relfrozenxid?
> Below are the unique age(relfrozenxid) val
Dushyanth escribió:
> Below are the unique age(relfrozenxid) values that i see from the above query
>
> # psql -U postgres -d dbname -c "select relname, age(relfrozenxid) from
> pg_class
> where relkind in ( 'r', 't') order by 2 desc;" | awk '{print $3}' | sort |
> uniq
>
> 140835139
> 1509457
Hey,
> Tom Lane sss.pgh.pa.us> writes:
> > Dushyanth gmail.com> writes:
> >> Does "show autovacuum" confirm that it's off?
>
> > Yes.
>
> > # show autovacuum;
> > autovacuum
> >
> > off
> > (1 row)
>
> Then the only other possibility is that autovacuum is being launched to
> pr
Dushyanth <[EMAIL PROTECTED]> writes:
>> Does "show autovacuum" confirm that it's off?
> Yes.
> # show autovacuum;
> autovacuum
>
> off
> (1 row)
Then the only other possibility is that autovacuum is being launched to
prevent XID wraparound. Are there any tables in that database
Hi,
Tom Lane sss.pgh.pa.us> writes:
> dushy gmail.com> writes:
> > On Fri, Jul 4, 2008 at 10:56 PM, Adrian Klaver comcast.net>
wrote:
> >> One question? Did you do pg_ctl reload after changing the config file?
>
> > I did not change any config yet - autovacuum was always disabled since
> > th
dushy <[EMAIL PROTECTED]> writes:
> On Fri, Jul 4, 2008 at 10:56 PM, Adrian Klaver <[EMAIL PROTECTED]> wrote:
>> One question? Did you do pg_ctl reload after changing the config file?
> I did not change any config yet - autovacuum was always disabled since
> the day PG was set up.
A mistake here
Hey,
There is only one autovacuum process when it starts up. Below is the
correct output from one of the logs
Good.
Do you have entries in the pg_autovacuum table in this database?
No. Its empty.
TIA
Dushyanth
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make
dushy escribió:
> My bad - I messed up the above. I grepped for autovacuum in my process
> logs and included all matches.
Ah, ok -- that makes more sense.
> There is only one autovacuum process when it starts up. Below is the
> correct output from one of the logs
Good.
Do you have entries in t
Hey,
>> # autovacuum processes
>>
>> postgres 16508 9.2 0.1 2310836 37984 ? Ds 09:58 0:09 \_ postgres:
>> autovacuum process db1
>> postgres 19626 7.2 0.0 2289524 27704 ? Ds 10:09 0:03 \_ postgres:
>> autovacuum process db1
>> postgres 20861 7.8 0.0 2298844 31028 ?
Hey,
On Fri, Jul 4, 2008 at 10:56 PM, Adrian Klaver <[EMAIL PROTECTED]> wrote:
>
> Am forwarding back to list.
> One question? Did you do pg_ctl reload after changing the config file?
I did not change any config yet - autovacuum was always disabled since
the day PG was set up.
Thanks
Dushyanth
Dushyanth escribió:
> # autovacuum processes
>
> postgres 16508 9.2 0.1 2310836 37984 ? Ds 09:58 0:09 \_ postgres:
> autovacuum process db1
> postgres 19626 7.2 0.0 2289524 27704 ? Ds 10:09 0:03 \_ postgres:
> autovacuum process db1
> postgres 20861 7.8 0.0 2298844 310
-- Forwarded Message --
Subject: Re: [GENERAL] [Postgresql 8.2.3] autovacuum starting up even after
disabling ?
Date: Friday 04 July 2008 9:51 am
From: dushy <[EMAIL PROTECTED]>
To: "Adrian Klaver" <[EMAIL PROTECTED]>
Hey,
Thanks for the quick r
On Friday 04 July 2008 7:51 am, Dushyanth wrote:
> Hey all,
>
> Iam using PostgreSQL 8.2.3 on RHEL4 (Linux 2.6.20.3-custom #4 SMP x86_64
> x86_64 x86_64 GNU/Linux).
>
> I have autovacuum tunrned off in the config, but it still seems to start up
> once everyday. What could be the cause of this ?
>
>
Hey all,
Iam using PostgreSQL 8.2.3 on RHEL4 (Linux 2.6.20.3-custom #4 SMP x86_64 x86_64
x86_64 GNU/Linux).
I have autovacuum tunrned off in the config, but it still seems to start up once
everyday. What could be the cause of this ?
TIA
Dushyanth
$ psql -U postgres
postgres=# show autovacuum;
17 matches
Mail list logo