Search Postgresql Archives

Re: json datatype and table bloat?

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

 



So, between yesterday and today we actually failed over to our hot-standby instance and the issue hasn't changed. I don't think you can have a pending transaction across streaming replication.


On Tue, Oct 29, 2013 at 12:49 PM, John R Pierce <pierce@xxxxxxxxxxxx> wrote:
On 10/29/2013 12:41 PM, Gregory Haase wrote:
db_name=# VACUUM FULL VERBOSE table_schema.table_name;
INFO:  vacuuming "table_schema.table_name"
INFO:  "table_name": found 2 removable, 29663 nonremovable row versions in 1754 pages
DETAIL:  0 dead row versions cannot be removed yet.
CPU 0.07s/0.10u sec elapsed 0.30 sec.

is there an old transaction pending?   that 'masks' vacuum from touching any tuples newer than the start of that transaction.



-- 
john r pierce                                      37N 122W
somewhere on the middle of the left coast


[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