Horton

Re: Create tables performance

Richard Huxton <dev@archonet.com>

View thread View on postgr.es
From: Richard Huxton <dev@archonet.com>
To: Sylvain CAILLET <scaillet@alaloop.com>
Cc: pgsql-performance@postgresql.org
Date: 2012-07-06T18:12:24Z
Lists: 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