Create tables performance

From: Sylvain CAILLET <scaillet(at)alaloop(dot)com>
To: pgsql-performance(at)postgresql(dot)org
Subject: Create tables performance
Date: 2012-07-06 15:15:49
Message-ID: 2ea3ab10-6768-45f2-a748-7f6c94be30fc@zimbra-ne01.network-studio.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance


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. 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. That is a very long time for such a process on such a server !
Do you think there could be some configuration tuning to do to improve the performance for create tables ?
Or do I have to use tablespaces because 100000 files in a single folder is a too many for OS ?
It's possible to migrate the DB in 9.1 version. Do you think it could solve the trouble ?

Thank you all for your advices,

Best regards

Sylvain

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Marc Mamin 2012-07-06 15:24:54 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 Albe Laurenz 2012-07-06 14:46:05 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.