Postgres Pro
Downloads
Home   >   mailing lists

Re: Create tables performance - Mailing list pgsql-performance

From Richard Huxton
Subject Re: Create tables performance
Date
Msg-id 4FF72A88.7050409@archonet.com
Whole thread Raw
In response to Create tables performance  (Sylvain CAILLET <scaillet@alaloop.com>)
List pgsql-performance
Tree view 
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 by date:

Previous
From: Jeff Janes
Date:
Subject: Re: Create tables performance
Next
From: Chris Hanks
Date:
Subject: 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.