Received: from localhost (unknown [200.46.204.187]) by postgresql.org (Postfix) with ESMTP id 512902E0276 for ; Tue, 29 Jan 2008 06:26:03 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.187]) (amavisd-maia, port 10024) with ESMTP id 03082-09 for ; Tue, 29 Jan 2008 06:25:37 -0400 (AST) Received: from ns1.officenet.no (ns1.officenet.no [193.212.174.3]) by postgresql.org (Postfix) with ESMTP id 2A5E92E00DB for ; Tue, 29 Jan 2008 06:25:51 -0400 (AST) Received: from [89.10.27.2] (helo=andreak-laptop.local) by ns1.officenet.no with esmtpsa (TLS-1.0:DHE_RSA_AES_256_CBC_SHA1:32) (Exim 4.63) (envelope-from ) id 1JJnep-0007sg-PJ; Tue, 29 Jan 2008 11:25:41 +0100 From: Andreas Joseph Krogh Organization: OfficeNet AS To: "Premsun Choltanwanich" Subject: Re: Slow Query problem Date: Tue, 29 Jan 2008 11:24:23 +0100 User-Agent: KMail/1.9.6 (enterprise 0.20070907.709405) Cc: "Tom Lane" , pgsql-sql@postgresql.org References: <479DE418.C5F7.004C.0@nsasia.co.th> <3741.1201540806@sss.pgh.pa.us> <479F4382.C5F7.004C.0@nsasia.co.th> In-Reply-To: <479F4382.C5F7.004C.0@nsasia.co.th> MIME-Version: 1.0 Content-Disposition: inline Message-Id: <200801291124.23660.andreak@officenet.no> Content-Type: text/plain; charset="utf-8" Content-Transfer-Encoding: quoted-printable X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200801/220 X-Sequence-Number: 30073 On Tuesday 29 January 2008 09:18:00 Premsun Choltanwanich wrote: > I already install the latest version of PostgreSQL on my machine then try > again. I found that it has a little improvement about 0.5 second but I > think it still slow. > > What is the 'more detail' you need? Your tables, views and index definitions. > Any other advise? You haven't provided any information on how your tables/views look like and= =20 what indexes you have defined. A rule of thumb is to define an index for ea= ch=20 column you join on. =2D-=20 Andreas Joseph Krogh Senior Software Developer / Manager =2D-----------------------+---------------------------------------------+ OfficeNet AS | The most difficult thing in the world is to | Karenslyst All=C3=A9 11 | know how to do a thing and to watch | PO. Box 529 Sk=C3=B8yen | somebody else doing it wrong, without | 0214 Oslo | comment. | NORWAY | | Tlf: +47 24 15 38 90 | | =46ax: +47 24 15 38 91 | | Mobile: +47 909 56 963 | | =2D-----------------------+---------------------------------------------+