B
shared memory.
- Original Message -
From: "Matthew T. O'Connor"
To: "Otto Blomqvist" <[EMAIL PROTECTED]>;
Sent: Thursday, March 24, 2005 3:58 PM
Subject: Re: [PERFORM] pg_autovacuum not having enough suction ?
> I would rather keep this on list since
od. If you or pg_autovacuum are running plain
> analyze commands, that could explain the invalid reltules numbers.
>
> Was reltuples = 113082 correct right after the vacuum?
>
> Matthew
>
>
> Otto Blomqvist wrote:
>
> >It looks like the reltuples-values are
> Another thing to check is whether the reltuples (and relpages!) that
> autovacuum is reporting are the same as what's actually in the pg_class
> row for the relation. I'm wondering if this could be a similar issue
> to the old autovac bug where it wasn't reading the value correctly.
These valu
ok, Thanks a lot for your time guys ! I guess my table is pretty unusual
and thats why this problem has not surfaced until now. Better late then
never ;) I'll cron a "manual" vacuum full on the table.
"Tom Lane" <[EMAIL PROTECTED]> wrote in message
news:[EMAI
suction is not strong enough ;)
Any ideas ? It would be greatly appreciated as this is taking me one step
closer to the looney bin.
Thanks
/Otto Blomqvist
---(end of broadcast)---
TIP 2: you can get off all lists at once with the unregister command
(send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])
Sorry about that. I'm Running 8.0.0 on Linux Redhat 8.0
"Tom Lane" <[EMAIL PROTECTED]> wrote in message
news:[EMAIL PROTECTED]
> "Otto Blomqvist" <[EMAIL PROTECTED]> writes:
> > Over 100'000 Index Rows removed, 300'000 unused item pointers