Re: [GENERAL] vacuum on table with all rows frozen

2017-04-01 Thread Tom DalPozzo
2017-04-01 18:34 GMT+02:00 Adrian Klaver : > On 04/01/2017 09:09 AM, Tom DalPozzo wrote: > >> Hi, >> let's suppose I have a table which after beign populated with only >> INSERTs, doesn't receive no more writing queries (neither insert or >> update or delete). Only reading queries. >> Once all tab

Re: [GENERAL] vacuum on table with all rows frozen

2017-04-01 Thread Adrian Klaver
On 04/01/2017 09:09 AM, Tom DalPozzo wrote: Hi, let's suppose I have a table which after beign populated with only INSERTs, doesn't receive no more writing queries (neither insert or update or delete). Only reading queries. Once all table rows get frozen by (auto)vacuum, will a next (auto)vacuum

[GENERAL] vacuum on table with all rows frozen

2017-04-01 Thread Tom DalPozzo
Hi, let's suppose I have a table which after beign populated with only INSERTs, doesn't receive no more writing queries (neither insert or update or delete). Only reading queries. Once all table rows get frozen by (auto)vacuum, will a next (auto)vacuum scan that table for any reason or does it unde

Re: [GENERAL] Keycloak and Postgres

2017-04-01 Thread Bill Moran
On Thu, 30 Mar 2017 13:58:36 + Marc Tempelmeier wrote: > Hi, > > I have a replication question, we have some big Cisco UCS VM thingy, where > VMs are snapshotted, the drives are abstracted etc. If a VM crashes it will > be resumed in 1 min from another rack. What brings us master slave >