Re: Temporary table has become problematically persistent

2020-05-05 Thread Ricky Ramirez
aparound warning was printed), but nothing appeared to change from that. Vacuuming the full database would have taken prohibitively long so we never completed that operation. On Mon, May 4, 2020 at 6:17 PM Jerry Sievers wrote: > Ricky Ramirez writes: > > > Hello, > > > > W

Re: Temporary table has become problematically persistent

2020-05-04 Thread Ricky Ramirez
Forgive me for forgetting the basics PG 11.2 on Ubuntu Bionic, amd64. No extensions enabled. On Mon, May 4, 2020 at 4:54 PM Tom Lane wrote: > Ricky Ramirez writes: > > We have run into a strange situation with our database. A temporary table > > was created some time ago and t

Temporary table has become problematically persistent

2020-05-04 Thread Ricky Ramirez
Hello, We have run into a strange situation with our database. A temporary table was created some time ago and that session has since died. However, the temporary table stuck around. It's been around long enough that postgres stopped accepting writes to prevent transaction ID wraparound. Problem i