Limit to number of tables and table drops
| От | John Gage |
|---|---|
| Тема | Limit to number of tables and table drops |
| Дата | |
| Msg-id | B9DFB3F6-5268-4094-A1D5-686308EA5CCA@numericable.fr обсуждение исходный текст |
| Ответы |
Re: Limit to number of tables and table drops
|
| Список | 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
В списке pgsql-novice по дате отправления: