From: Richard Huxton <dev@archonet.com>
To: Sylvain CAILLET <scaillet@alaloop.com>
Cc: pgsql-performance@postgresql.org
Subject: Re: Create tables performance
Date: Fri, 06 Jul 2012 19:12:24 +0100
Message-ID: <4FF72A88.7050409@archonet.com> (raw)
In-Reply-To: <2ea3ab10-6768-45f2-a748-7f6c94be30fc@zimbra-ne01.network-studio.com>
References: <2ea3ab10-6768-45f2-a748-7f6c94be30fc@zimbra-ne01.network-studio.com>
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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-performance@postgresql.org
Cc: dev@archonet.com, scaillet@alaloop.com
Subject: Re: Create tables performance
In-Reply-To: <4FF72A88.7050409@archonet.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox