Ben <[EMAIL PROTECTED]> writes:
> After some tests, it seems that autovacuum doesn't kick in from simple
> inserts, as the manual says it will. You have to delete and/or update as
> well. Am I misreading the manual?
There's nothing to vacuum until you delete or update.
You should see some auto-
On Tue, 28 Aug 2007, Decibel! wrote:
On Tue, Aug 28, 2007 at 03:10:34PM -0700, Ben wrote:
Hm, I assumed it wasn't running because pg_stat_all_tables shows the last
vacuum from several weeks ago, and this is an active db. Also, I see no
vacuum activity in the logs. But "show autovacuum" does sho
Ben wrote:
> Hm, I assumed it wasn't running because pg_stat_all_tables shows the last
> vacuum from several weeks ago, and this is an active db. Also, I see no
> vacuum activity in the logs. But "show autovacuum" does show it being
> on
>
> So if it is running after all, how can I track down
On Tue, Aug 28, 2007 at 03:10:34PM -0700, Ben wrote:
> Hm, I assumed it wasn't running because pg_stat_all_tables shows the last
> vacuum from several weeks ago, and this is an active db. Also, I see no
> vacuum activity in the logs. But "show autovacuum" does show it being
> on
Last vacuum,
Ben <[EMAIL PROTECTED]> writes:
> Hm, I assumed it wasn't running because pg_stat_all_tables shows the last
> vacuum from several weeks ago, and this is an active db. Also, I see no
> vacuum activity in the logs. But "show autovacuum" does show it being
> on
Just to double-check, make sure s
Hm, I assumed it wasn't running because pg_stat_all_tables shows the last
vacuum from several weeks ago, and this is an active db. Also, I see no
vacuum activity in the logs. But "show autovacuum" does show it being
on
So if it is running after all, how can I track down why things aren't
Ben wrote:
> My autovacuum daemon isn't running on 8.2.4, and I'm guessing it's because
> I changed my unix socket directory in postgresql.conf. Is there a way I can
> tell autovacuum which socket file to use, or which IP to connect to?
It doesn't use a socket. How do you know it's not running?
My autovacuum daemon isn't running on 8.2.4, and I'm guessing it's because
I changed my unix socket directory in postgresql.conf. Is there a way I
can tell autovacuum which socket file to use, or which IP to connect to?
---(end of broadcast)---
TI
