From: | John Gage <jsmgage(at)numericable(dot)fr> |
---|---|
To: | pgsql-novice(at)postgresql(dot)org |
Subject: | Limit to number of tables and table drops |
Date: | 2010-05-21 08:42:56 |
Message-ID: | B9DFB3F6-5268-4094-A1D5-686308EA5CCA@numericable.fr |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-novice |
I am creating a web application that uses very small temporary tables
(i.e. tables that are created and then destroyed nearly immediately)
to store state data for a particular browser "session".
A table might have four columns and four rows each containing a small
piece of text.
The "sessions" last a minute at best.
I can contemplate (hope for?) as many as 100,000 sessions in an hour.
That would mean 100,000 table creations and destructions in an hour
( or getting on 2000 per minute).
Will that stress a postgres database? Stress defined as slow response
or exceeding storage.
What are the measures one would take to minimize stress?
I have looked at the documentation but don't find something exactly
apposite to this question.
Thanks,
John
From | Date | Subject | |
---|---|---|---|
Next Message | Prefeitura Cajuru | 2010-05-21 12:54:57 | Problem with MESSAGE 2185 |
Previous Message | Andreas Schmitz | 2010-05-21 08:35:39 | Re: Transferring Data between databases |