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

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: 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: 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: 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

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