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
