vacuum curiosity

CAVEAT: I may have another version of this email bouncing around, sorry. Running PG10.0 on Centos 7.4 I thought the current database was quiescent so I’m curious about the line isolated below with “0 dead row" Does that suggest there is an open transaction? vacuum (analyse, verbose) sui.segment

Re: vacuum curiosity

>Does that suggest there is an open transaction? No, it simply means there are zero/no dead rows that can be removed at that time. Please refer to the documentation on VACUUM, specifically 24.1.2. Recovering Disk Space https://w

Re: Dependency tree to tie type/function deps to a table

> > Perhaps you'll find the version on the wiki useful as reference, it's an > older version of the dependencies, and can be found at > https://wiki.postgresql.org/wiki/Pg_depend_display​ > This is where I started. However, I noticed that it do everything I need. As I said in my original post, as

Re: Dependency tree to tie type/function deps to a table

On Sun, Dec 17, 2017 at 3:31 PM, Jeremy Finzel wrote: > Perhaps you'll find the version on the wiki useful as reference, it's an >> older version of the dependencies, and can be found at >> https://wiki.postgresql.org/wiki/Pg_depend_display​ >> > > This is where I started. However, I noticed tha

Re: PgBackRest question?

Thanks David for the replay. we are not interested to use replication/Standby configuration at this moment with pgbackrest. We are looking to restore the QA backups on Dev systems . Please help us if any blogs/documentations for remote databases recovery scenarios?. Thanks, Chiru

Re: pgbench

On 15/12/2017 23:18, John R Pierce wrote: On 12/15/2017 7:37 AM, Olga Lytvynova-Bogdanova wrote: Is there a way to integrate pgbench with TeamCity? If yes, could you share very briefly how to do this? I would suspect this is a question for TeamCity, not for postgresql.   I don't even know wha