Search Postgresql Archives

Re: VACUUM FULL doesn't reduce table size

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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.


-- 
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general




[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux