| From: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
|---|---|
| To: | Alvaro Herrera <alvherre(at)commandprompt(dot)com> |
| Cc: | Larry Rosenman <lrosenman(at)pervasive(dot)com>, Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us>, Casey Duncan <casey(at)pandora(dot)com>, pgsql-general(at)postgresql(dot)org |
| Subject: | Re: autovacuum "connections" are hidden |
| Date: | 2006-05-18 22:24:55 |
| Message-ID: | 21493.1147991095@sss.pgh.pa.us |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general pgsql-hackers |
Alvaro Herrera <alvherre(at)commandprompt(dot)com> writes:
> The problem is that pgstat_bestart (called in InitPostgres, which
> autovac calls) deliberately ignores autovacuum, due to not having a
> client address. We could create a fake client address (which doesn't
> seem easy to do), or we could change pg_stat_activity to use an OUTER
> JOIN. Not sure what other options are there.
Seems like the client address should read as NULL. Not sure if that's
hard or not. Changing the view definition is no fun (at least for an
8.1 back-patch) because it'd require initdb.
regards, tom lane
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Alvaro Herrera | 2006-05-18 23:20:21 | Re: autovacuum "connections" are hidden |
| Previous Message | Alvaro Herrera | 2006-05-18 22:11:03 | Re: autovacuum "connections" are hidden |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Alvaro Herrera | 2006-05-18 23:20:21 | Re: autovacuum "connections" are hidden |
| Previous Message | Alvaro Herrera | 2006-05-18 22:11:03 | Re: autovacuum "connections" are hidden |