Re: Create tables performance

Поиск
Список
Период
Сортировка
От Richard Huxton
Тема Re: Create tables performance
Дата
Msg-id 4FF72A88.7050409@archonet.com
обсуждение исходный текст
Ответ на Create tables performance  (Sylvain CAILLET <scaillet@alaloop.com>)
Список pgsql-performance
Дерево обсуждения 
On 06/07/12 16:15, Sylvain CAILLET wrote:
> Hi to all,
>
> I run Postgresql 8.3.9 on a dedicated server running with Debian 5.0.4,
> a strong bi quad-proc with RAM 16Go. My biggest db contains at least 100
> 000 tables.

That is a *lot* of tables and it's probably going to be slow whatever
you do.

> Last time, I started a Java process I use to make some
> change on it, it created 170 new tables and it took one full minute.

What are you using all these tables for? I'm assuming most of them have
identical structure.

--
   Richard Huxton
   Archonet Ltd

В списке pgsql-performance по дате отправления:

Предыдущее
От: Jeff Janes
Дата:
Сообщение: Re: Create tables performance
Следующее
От: Chris Hanks
Дата:
Сообщение: Re: PostgreSQL db, 30 tables with number of rows < 100 (not huge) - the fastest way to clean each non-empty table and reset unique identifier column of empty ones.