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  (Sergey Moiseev <bopm@maloletka.ru>)
Список 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 по дате отправления:

Предыдущее
От: "Orlando Giovanny Solarte Delgado"
Дата:
Сообщение: Create/Erase 5000 Tables in PostGRE SQL in execution Time
Следующее
От: "Jim C. Nasby"
Дата:
Сообщение: Real-time TB databases (not PostgreSQL related)