X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id 99F253A4D24 for ; Tue, 16 Nov 2004 02:21:16 +0000 (GMT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 40260-05 for ; Tue, 16 Nov 2004 02:21:04 +0000 (GMT) Received: from www.strato-webmail.de (www.strato-webmail.de [81.169.148.109]) by svr1.postgresql.org (Postfix) with ESMTP id 2125C3A4D1C for ; Tue, 16 Nov 2004 02:21:07 +0000 (GMT) Received: from localhost ([127.0.0.1] helo=cmklein.de) by www.strato-webmail.de with smtp (Exim 4.10) id 1CTsxu-0005et-00 for pgsql-admin@postgresql.org; Tue, 16 Nov 2004 03:21:06 +0100 From: matthias@cmklein.de To: pgsql-admin@postgresql.org Subject: how to handle larger databases? X-Mailer: STRATO-Webmail.de, powered by PHlyMail OEM, http://phlymail.com X-Sender-IP: 156.34.221.80 Message-Id: Date: Tue, 16 Nov 2004 03:21:06 +0100 X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.3 tagged_above=0.0 required=5.0 tests=NO_REAL_NAME X-Spam-Level: X-Archive-Number: 200411/137 X-Sequence-Number: 15521 I am currently creating a database which will have less than 20 quite simple tables. Unfortunately, some of those tables will have more than 1 million entries. In order to maintain fairly good query times I would like to ask for some tips on how I should organize that database, what I should do or what I should avoid. Thanks Matt