Date: Thu, 27 Oct 2005 12:46:01 -0500
From: "Jim C. Nasby" <jnasby@pervasive.com>
To: Abdul Wahab Dahalan <wahab@mimos.my>
Cc: pgsql-sql@postgresql.org
Subject: Re: How to speed up the database query?
Message-ID: <20051027174601.GI63747@pervasive.com>
References: <5076660.1130396616478.SLOX.WebMail.wwwrun@openx.mimos.my>
Mime-Version: 1.0
Content-Type: text/plain; charset=us-ascii
Content-Disposition: inline
In-Reply-To: <5076660.1130396616478.SLOX.WebMail.wwwrun@openx.mimos.my>
User-Agent: Mutt/1.5.9i

Have you taken a look at
http://www.postgresql.org/docs/8.0/interactive/performance-tips.html ?

On Thu, Oct 27, 2005 at 03:03:36PM +0800, Abdul Wahab Dahalan wrote:
> Hi everyone!
> 
> I'm looking for solution to speed up the database query, means that to get resultset as quicker as we can.
> 
> For example if I've 700 records in the table it will take longer time compared if I've only 20 records. How do we speed up the query?. Any query technique that can be applied?.
> 
> Thus wild card query like : select * from tableA will cause query time increased compare to say select a,b from tableA.
> 
> any help, prettymuch appreciated.
> 
> 
> ---------------------------(end of broadcast)---------------------------
> TIP 5: don't forget to increase your free space map settings
> 

-- 
Jim C. Nasby, Sr. Engineering Consultant      jnasby@pervasive.com
Pervasive Software      http://pervasive.com    work: 512-231-6117
vcard: http://jim.nasby.net/pervasive.vcf       cell: 512-569-9461