Re: (auto) vacuum mysterious

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

 



walpino@xxxxxxxxx wrote:
> Hi There 
> 
> My Name is Martin
> And we are running PostgreSQL 9.5.3 
> 
> We are doing a lot of deletes updates and Inserts on some tables
> 
> Until now we didn’t Encounter so much Problems with the vacuumizer but in the last view days we have the fact the vacuum cannot remove dead rows anymore
> 
> I know it is the case when there are other Long running Transactions running but this isn’t the case

Maybe you have an inactive replication slot.  See
  select * from pg_replication_slots;
and consider dropping those that are unused.

-- 
Álvaro Herrera                https://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services


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



[Index of Archives]     [KVM ARM]     [KVM ia64]     [KVM ppc]     [Virtualization Tools]     [Spice Development]     [Libvirt]     [Libvirt Users]     [Linux USB Devel]     [Linux Audio Users]     [Yosemite Questions]     [Linux Kernel]     [Linux SCSI]     [XFree86]

  Powered by Linux