| From: | Adrian Klaver <adrian(dot)klaver(at)aklaver(dot)com> |
|---|---|
| To: | pinker <pinker(at)onet(dot)eu>, pgsql-general(at)postgresql(dot)org |
| Subject: | Re: VACUUM FULL doesn't reduce table size |
| Date: | 2015-03-09 14:25:57 |
| Message-ID: | 54FDAD75.6070005@aklaver.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
On 03/09/2015 07:08 AM, pinker wrote:
> I did: select pg_cancel_backend(pid) from pg_stat_activity where usename <>
> 'mine';
What makes you think that queries from usename = 'mine' are not important?
Or to get back to the original request:
What does select * from pg_stat_activity show?
Also did the queries actually get cancelled?
>
> and then tried again vacuum full:
>
> INFO: vacuuming "my_table"
> INFO: "my_table": found 0 removable, 3043947 nonremovable row versions in
> 37580 pages
> DETAIL: 0 dead row versions cannot be removed yet.
> CPU 1.07s/1.56u sec elapsed 3.24 sec.
> Query returned successfully with no result in 6436 ms.
>
>
> PostgreSQL 9.3.5 on x86_64-unknown-linux-gnu, compiled by gcc (GCC) 4.8.2
> 20140120 (Red Hat 4.8.2-16), 64-bit
>
> It was flash copy snapshot
So what does that mean?
In other words detail the steps you took to get the snapshot.
>
--
Adrian Klaver
adrian(dot)klaver(at)aklaver(dot)com
| From | Date | Subject | |
|---|---|---|---|
| Next Message | pinker | 2015-03-09 14:37:51 | Re: VACUUM FULL doesn't reduce table size |
| Previous Message | pinker | 2015-03-09 14:08:37 | Re: VACUUM FULL doesn't reduce table size |