Create/Erase 5000 Tables in PostGRE SQL in execution Time
От | Orlando Giovanny Solarte Delgado |
---|---|
Тема | Create/Erase 5000 Tables in PostGRE SQL in execution Time |
Дата | |
Msg-id | BAY114-F36813EA234ABA4B9AD49A0A01B0@phx.gbl обсуждение исходный текст |
Ответы |
Re: Create/Erase 5000 Tables in PostGRE SQL in execution
|
Список | pgsql-general |
I am designing a system that it takes information of several databases distributed in Interbase (RDBMS). It is a system web and each user can to do out near 50 consultations for session. I can have simultaneously around 100 users. Therefore I can have 5000 consultations simultaneously. Each consultation goes join to a space component in Postgis, therefore I need to store each consultation in PostgreSQL to be able to use all the capacity of PostGIS. The question is if for each consultation in execution time build a table in PostGRESQL I use it and then I erase it. Is a system efficient this way? Is it possible to have 5000 tables in PostGRESQL? How much performance? Thanks for your help! Orlando Giovanny Solarte Delgado Ingeniero en Electrónica y Telecomunicaciones Universidad del Cauca, Popayan. Colombia. E-mail Aux: orlandos@gmail.com Orlando Giovanny Solarte Delgado Ingeniero en Electrónica y Telecomunicaciones Universidad del Cauca E-mail Aux: orlandos@gmail.com
В списке pgsql-general по дате отправления: