Received: from icebox.venux.net (icebox.venux.net [216.120.166.10]) by hub.org (8.9.3/8.9.3) with ESMTP id IAA56078 for ; Fri, 2 Jun 2000 08:56:39 -0400 (EDT) (envelope-from mitch@venux.net) Received: from servbox.venux.net (matrix.venux.net [216.120.166.5]) by icebox.venux.net (Postfix) with ESMTP id 0149026202; Fri, 2 Jun 2000 09:01:25 -0400 (EDT) Received: from doot (doot.venux.net [10.0.0.65]) by servbox.venux.net (Postfix) with SMTP id B55D72BD82; Fri, 2 Jun 2000 09:00:01 -0400 (EDT) Message-ID: <03cf01bfcc92$16d1c140$4100000a@venux.net> From: "Mitch Vincent" To: "Alessandro Rossi" , References: Subject: Re: SPEED UP. Date: Fri, 2 Jun 2000 08:57:20 -0400 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 5.00.2615.200 X-MimeOLE: Produced By Microsoft MimeOLE V5.00.2615.200 X-Archive-Number: 200006/18 Lets see your queries you're running and their plan, I'd bet there are ways to speed them up (that's always been the case with mine!).. fields - Mitch "The only real failure is quitting." ----- Original Message ----- From: Alessandro Rossi To: Sent: Friday, June 02, 2000 2:49 AM Subject: [SQL] SPEED UP. > > > I would like to know is there is a specific way to speed up my query to > postgres. > > I have a DB-MACHINE that I use just and only for postgres witch runs > linux RedHad 6.2 with 1Gb of RAM on ULTRA SCSI discs. > > I run vacuum every hour, but there is something else I can do (compile > postgres in a special way ) to get the best from postgres ?? > > > Thanks in advance > > Alex > > >