Received: from makus.postgresql.org (makus.postgresql.org [98.129.198.125]) by mail.postgresql.org (Postfix) with ESMTP id 4B242EC7B27 for ; Fri, 6 Jul 2012 15:12:44 -0300 (ADT) Received: from archon2012.plus.com ([80.229.41.160] helo=mail.archonet.com) by makus.postgresql.org with esmtp (Exim 4.72) (envelope-from ) id 1SnD1D-0006mY-8P for pgsql-performance@postgresql.org; Fri, 06 Jul 2012 18:12:44 +0000 Received: from [192.168.1.13] (ariel.office.archonet.com [192.168.1.13]) by mail.archonet.com (Postfix) with ESMTP id 248F72C4BA7; Fri, 6 Jul 2012 19:12:24 +0100 (BST) Message-ID: <4FF72A88.7050409@archonet.com> Date: Fri, 06 Jul 2012 19:12:24 +0100 From: Richard Huxton User-Agent: Mozilla/5.0 (X11; Linux x86_64; rv:10.0.4) Gecko/20120510 Icedove/10.0.4 MIME-Version: 1.0 To: Sylvain CAILLET CC: pgsql-performance@postgresql.org Subject: Re: Create tables performance References: <2ea3ab10-6768-45f2-a748-7f6c94be30fc@zimbra-ne01.network-studio.com> In-Reply-To: <2ea3ab10-6768-45f2-a748-7f6c94be30fc@zimbra-ne01.network-studio.com> Content-Type: text/plain; charset=UTF-8; format=flowed Content-Transfer-Encoding: 7bit X-Pg-Spam-Score: -1.9 (-) X-Archive-Number: 201207/71 X-Sequence-Number: 47252 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