Re: database design with temporary tables

From: Mladen Gogala <gogala(dot)mladen(at)gmail(dot)com>
To: pgsql-general(at)lists(dot)postgresql(dot)org
Subject: Re: database design with temporary tables
Date: 2021-08-29 17:41:28
Message-ID: ebb9eeb4-8815-65a9-c63e-3d38ff044116@gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general


On 8/29/21 12:24 PM, Adrian Klaver wrote:
> Presumably not. Temporary tables only live at most for the length of a
> session. It would be a really bad idea to hold sessions open for 24
> hours. That is assuming nothing else causes the session to drop and
> the data to be lost.

Well, that's precisely how application servers work. The allocate
connection pool and keep them open for a very long time.

--
Mladen Gogala
Database Consultant
Tel: (347) 321-1217
https://dbwhisperer.wordpress.com

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Adrian Klaver 2021-08-29 18:26:25 Re: database design with temporary tables
Previous Message ourdiaspora 2021-08-29 17:14:20 Re: database design with temporary tables