| From: | Richard Huxton <dev(at)archonet(dot)com> |
|---|---|
| To: | Sylvain CAILLET <scaillet(at)alaloop(dot)com> |
| Cc: | pgsql-performance(at)postgresql(dot)org |
| Subject: | Re: Create tables performance |
| Date: | 2012-07-06 18:12:24 |
| Message-ID: | 4FF72A88.7050409@archonet.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| 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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Chris Hanks | 2012-07-06 18:32:25 | 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. |
| Previous Message | Jeff Janes | 2012-07-06 17:22:16 | Re: Create tables performance |