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 14:37:51 |
Message-ID: | 1425911871079-5841117.post@n5.nabble.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Adrian Klaver-4 wrote
> 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?
>
> Because on production I don't have access to this table.
>
> Or to get back to the original request:
>
> What does select * from pg_stat_activity show?
>
> mainly idle connections and queries to tables in different schemas.
> query select * from pg_stat_activity where query ilike '%my_table%' shows
> nothing as well.
>
> Also did the queries actually get cancelled?
> Yes, but not all.
>
>>
>> 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.
>
> I would like to know as well. Sysadmin team manage it, I'll ask them, but
> as far I know it's matrix feature....
>
>>
>
>
> --
> Adrian Klaver
> adrian.klaver@
>
>
> --
> Sent via pgsql-general mailing list (
> pgsql-general@
> )
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-general
--
View this message in context: http://postgresql.nabble.com/VACUUM-FULL-doesn-t-reduce-table-size-tp5840782p5841117.html
Sent from the PostgreSQL - general mailing list archive at Nabble.com.
From | Date | Subject | |
---|---|---|---|
Next Message | Adrian Klaver | 2015-03-09 14:53:44 | Re: VACUUM FULL doesn't reduce table size |
Previous Message | Adrian Klaver | 2015-03-09 14:25:57 | Re: VACUUM FULL doesn't reduce table size |