Re: VACUUM WARNING: skipping "pg_statistic" --- only table or database owner can vacuum it

Поиск
Список
Период
Сортировка
От Ray Stell
Тема Re: VACUUM WARNING: skipping "pg_statistic" --- only table or database owner can vacuum it
Дата
Msg-id 20100212170216.GA1118@cns.vt.edu
обсуждение исходный текст
Ответ на Re: VACUUM WARNING: skipping "pg_statistic" --- only table or database owner can vacuum it  (Ray Stell <stellr@cns.vt.edu>)
Список pgsql-admin
On Tue, Feb 09, 2010 at 05:39:52PM -0500, Ray Stell wrote:
> On Sat, Jan 30, 2010 at 09:59:36AM -0500, Ray Stell wrote:
>
> Is autovacuum handing all users off to vacuum all rels?  Even those
> it does not own?  Perhaps "admin" an unfortunate usename choice?


doh...the light comes on.

reading through postinit.c and others makes it clear autovacuum is not the source
of the vacuum.  No doubt the app, Cisco Fabric Manager Server, is doing something
stupid.  Yep:

/var/local/cisco_mds9000
# strings ./jboss/server/default/deploy/dcm.ear/dcm.jar/com/cisco/dcbu/sm/server/db/PostgresWrapper.class | grep -i
vacuum
 vacuum_analyze
vacuum analyze
 vacuum_analyze failed:

2.     Irrelephant
Anything that is unrelated to an elephant.
http://www.urbandictionary.com/define.php?term=irrelephant

В списке pgsql-admin по дате отправления:

Предыдущее
От: Renato Oliveira
Дата:
Сообщение: Re: PG_DUMP backup
Следующее
От: dx k9
Дата:
Сообщение: Postgresql & PAM & active directory