Search Postgresql Archives

Re: database design with temporary tables

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



On 8/29/21 9:36 AM, ourdiaspora wrote:
‐‐‐‐‐‐‐ Original Message ‐‐‐‐‐‐‐

On Sunday, August 29th, 2021 at 5:24 PM, Adrian Klaver <adrian.klaver@xxxxxxxxxxx> 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.

Is there an alternative scenario, such as the user is able to create a new table with saves the session data for a maximum time (such as 24 hours), even up to a certain time if the web browser crashes for example?

This is a it depends answer. Some factors in play:

1) Number of users over say a 24 hour period.

2) The size of the CSV files.

3) Is the data merge a one time thing or can it be repeated in a time period.

4) Are users going to be repeat customers?

For this sort of thing I write out a detailed outline of the who/what/why/where/when. In doing that answers tend to follow.



The abo


Incomplete response?





--
Adrian Klaver
adrian.klaver@xxxxxxxxxxx





[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]

  Powered by Linux