Re: VACUUM FULL doesn't reduce table size - Mailing list pgsql-general

From pinker
Subject Re: VACUUM FULL doesn't reduce table size
Date
Msg-id 1425913536570-5841123.post@n5.nabble.com
Whole thread Raw
In response to Re: VACUUM FULL doesn't reduce table size  (Adrian Klaver <adrian.klaver@aklaver.com>)
Responses Re: VACUUM FULL doesn't reduce table size
Re: VACUUM FULL doesn't reduce table size
List pgsql-general
select * from pg_stat_activity where state ilike 'idle in transaction%' it's
empty.

>And there is no relation between this table and the tables or functions
being queried?

no...

>If  snapshot is what I think it means, you might want to point them at:

>http://www.postgresql.org/docs/9.3/interactive/backup-file.html

hmmm, maybe it's because WAL is in another tablespace?



--
View this message in context: http://postgresql.nabble.com/VACUUM-FULL-doesn-t-reduce-table-size-tp5840782p5841123.html
Sent from the PostgreSQL - general mailing list archive at Nabble.com.


pgsql-general by date:

Previous
From: Adrian Klaver
Date:
Subject: Re: VACUUM FULL doesn't reduce table size
Next
From: Eli Murray
Date:
Subject: Re: Creating composite keys from csv