Re: VACUUM FULL doesn't reduce table size

From: pinker <pinker(at)onet(dot)eu>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: VACUUM FULL doesn't reduce table size
Date: 2015-03-09 15:05:36
Message-ID: 1425913536570-5841123.post@n5.nabble.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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.

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Eli Murray 2015-03-09 15:12:41 Re: Creating composite keys from csv
Previous Message Adrian Klaver 2015-03-09 14:53:44 Re: VACUUM FULL doesn't reduce table size