Re: transaction wrap around

2017-12-05 Thread Thomas Munro
On Tue, Dec 5, 2017 at 5:43 PM, Jeff Janes <jeff.ja...@gmail.com> wrote: > On Mon, Dec 4, 2017 at 5:52 PM, John R Pierce <pie...@hogranch.com> wrote: >> On 12/4/2017 2:21 PM, chris kim wrote: >>> How would I investigate if my database is nearing a transaction w

Re: transaction wrap around

2017-12-04 Thread Jeff Janes
On Mon, Dec 4, 2017 at 5:52 PM, John R Pierce <pie...@hogranch.com> wrote: > On 12/4/2017 2:21 PM, chris kim wrote: > >> >> >> How would I investigate if my database is nearing a transaction wrap >> around. >> > > > it would be screaming b

Re: transaction wrap around

2017-12-04 Thread Tom Lane
John R Pierce <pie...@hogranch.com> writes: > On 12/4/2017 2:21 PM, chris kim wrote: >> How would I investigate if my database is nearing a transaction wrap >> around. > it would be screaming bloody murder in the log, for one. I think the simplest thing is to keep an ey

Re: transaction wrap around

2017-12-04 Thread John R Pierce
On 12/4/2017 2:21 PM, chris kim wrote: How would I investigate if my database is nearing a transaction wrap around. it would be screaming bloody murder in the log, for one. -- john r pierce, recycling bits in santa cruz

transaction wrap around

2017-12-04 Thread chris kim
Hello, How would I investigate if my database is nearing a transaction wrap around. Best Regards, Chris