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 DCA63D1B345 for ; Thu, 29 Jul 2004 12:27:20 -0300 (ADT) 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 10274-02 for ; Thu, 29 Jul 2004 15:27:15 +0000 (GMT) Received: from jais.jouy.inra.fr (jais.jouy.inra.fr [138.102.1.17]) by svr1.postgresql.org (Postfix) with ESMTP id 119DED1B23C for ; Thu, 29 Jul 2004 12:27:12 -0300 (ADT) Received: from diamant.jouy.inra.fr (localhost [127.0.0.1]) by jais.jouy.inra.fr (8.10.1/8.10.1) with ESMTP id i6TFR8N26980 for ; Thu, 29 Jul 2004 17:27:09 +0200 (CEST) Received: from pc502jlo (pc502ljo [138.102.3.71]) by diamant.jouy.inra.fr (8.10.1/8.10.1) with SMTP id i6TFR9i26261 for ; Thu, 29 Jul 2004 17:27:09 +0200 (CEST) Message-ID: <011101c47580$85144ba0$4703668a@pc502jlo> From: "Jouneau Luc" To: References: Subject: Re: please please please PLEASE help! Date: Thu, 29 Jul 2004 17:27:12 +0200 MIME-Version: 1.0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: 7bit X-Priority: 3 X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook Express 6.00.2800.1437 X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1441 X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.0 tagged_above=0.0 required=5.0 tests= X-Spam-Level: X-Archive-Number: 200407/313 X-Sequence-Number: 14381 Hi, I don't want to offense you asking if you run vacuum full regullary. I suppose that the 10Gb are plain of usefull data, aren't they ? Luc ----- Original Message ----- From: "Steve" To: Sent: Friday, July 23, 2004 8:10 AM Subject: [ADMIN] please please please PLEASE help! > Hi, > > I've asked this question a couple of times before on this forum but no > one seems to be nice enough to point me to the right direction or help > me out with any information, if possible. Please help me out with this > because this is a very serious issue for me and I need to learn more > about this. And here it is again: > > I've been running postgres on my server for over a year now and the > tables have become huge. I have 3 tables that have data over 10GB each > and these tables are read very very frequently. In fact, heavy searches > on these tables are expected every 2 to 3 minutes. This unfortunately > gives a very poor response time to the end user and so I'm looking at > other alternatives now. > > Currently, the postgresql installation is on a single disk and so all > the tables have their data read from a single disk. Searching on > different tables by multiple users at the same time results in very slow > searches, as it's mainly dependant on the spindle speed. I recently > gained access to another server which has 3 SCSI disks. I know there is > a way to mirror the tables across the three different disks but I'm not > sure if it's as easy as symlinking the files (WAL files only?) across. > Can anyone please tell me what to do here and how to harness the power > of the three SCSI drives that I have. Which files in the data directory > need to be moved? Is this safe? Can backups etc be easily done? Any > information will be greatly appreciated. Thank you, > > > Steve > > > ---------------------------(end of broadcast)--------------------------- > TIP 2: you can get off all lists at once with the unregister command > (send "unregister YourEmailAddressHere" to majordomo@postgresql.org) >