Received: from hawk.prod.itd.earthlink.net (hawk.mail.pas.earthlink.net [207.217.120.22]) by postgresql.org (8.11.3/8.11.4) with ESMTP id g0AFw4B41767 for ; Thu, 10 Jan 2002 10:58:04 -0500 (EST) (envelope-from nickf@ontko.com) Received: from 1cust209.tnt1.richmond.in.da.uu.net ([63.27.103.209] helo=nick) by hawk.prod.itd.earthlink.net with smtp (Exim 3.33 #1) id 16OhaI-0002BJ-00; Thu, 10 Jan 2002 07:57:43 -0800 Reply-To: From: "Nick Fankhauser" To: "Guru\(External\)" , Subject: Re: Resources Date: Thu, 10 Jan 2002 10:54:03 -0500 Message-ID: MIME-Version: 1.0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: 7bit X-Priority: 3 (Normal) X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook IMO, Build 9.0.2416 (9.0.2911.0) In-Reply-To: <4423720517.20020110190329@indvalley.com> Importance: Normal X-MimeOLE: Produced By Microsoft MimeOLE V5.00.2919.6600 X-Archive-Number: 200201/76 X-Sequence-Number: 6166 I think we'll need a lot more of the particulars about this query to help. The query itself & the results of an "explain" on the query are a good starting place. Unless the query is really unusual, that does seem like a very excessive time which can probably be improved. Please give us some of the details. Regards, -Nick > -----Original Message----- > From: pgsql-sql-owner@postgresql.org > [mailto:pgsql-sql-owner@postgresql.org]On Behalf Of Gurudutt > Sent: Thursday, January 10, 2002 8:33 AM > To: pgsql-sql@postgresql.org > Subject: [SQL] Resources > > > Hi, > > I have a pentium III server, running on RHL 7.1 with 256 MB RAM, > > The following is output of the "top" command for query which involves > fetch from a table with about MAX of 10,000 rows. > > -------------------------------------TOP------------------------------ > PID USER PRI NI SIZE RSS SHARE STAT %CPU %MEM TIME COMMAND > > 3174 postgres 19 0 3328 3328 2672 R 99.0 1.3 0:58 postmaster > 1199 nobody 9 0 3728 3728 2704 S 0.5 1.4 0:03 httpd > 3035 root 10 0 1048 1048 840 R 0.3 0.4 0:15 top > 1 root 8 0 544 544 472 S 0.0 0.2 0:04 init > 2 root 9 0 0 0 0 SW 0.0 0.0 0:00 keventd > 3 root > > > Now, my question is, it takes ages(2 mints) for the query to run > (regularly > VACUUM ANALYZED Database) and if you look closely at the resources > consumed by the postgres, it is almost taking away 100% CPU time. > > How can we make it faster and to consume less resources ?? > > Can anybody suggest the steps they are taking for time-critical > applications to run efficiently. > > Thanks in advance > > -- > Best regards, > Gurudutt mailto:guru@indvalley.com > > Life is not fair - get used to it. > Bill Gates > > > ---------------------------(end of broadcast)--------------------------- > TIP 1: subscribe and unsubscribe commands go to majordomo@postgresql.org >