Search Postgresql Archives

VACUUM and transactions in different databases

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

 



Hi all

If I have a running transaction in database1 and try to vacuum database2 but the dead tuples in database2 cannot be removed.

INFO:  vacuuming "public.dummy1"
INFO: "dummy1": found 0 removable, 140000 nonremovable row versions in 1341 pages
DETAIL:  135000 dead row versions cannot be removed yet.

How can I achieve that database2 is vacuumed while a transaction in database1 is not yet commited?

Regards
conni


[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