Message-ID: <41FFBB95.3090306@PresiNET.com>
Date: Tue, 01 Feb 2005 09:25:41 -0800
From: Bricklen Anderson <BAnderson@PresiNET.com>
User-Agent: Debian Thunderbird 1.0 (X11/20050116)
MIME-Version: 1.0
Cc: Joel Fradkin <jfradkin@wazagua.com>, pgsql-sql@postgresql.org
Subject: Re: MSSQL versus Postgres timing
References: <000001c5087e$b92ddfa0$797ba8c0@jfradkin>
	<20050201170654.GA65518@winnie.fuhr.org>
In-Reply-To: <20050201170654.GA65518@winnie.fuhr.org>
Content-Type: text/plain; charset=us-ascii; format=flowed
Content-Transfer-Encoding: 7bit

Michael Fuhr wrote:
> On Tue, Feb 01, 2005 at 11:54:11AM -0500, Joel Fradkin wrote:
> 
>>A table with 645,000 records for associates has view (basically select *
>>from tblassociates where clientnum = 'test')
>>
>>This is taking 13 seconds in postgres and 3 seconds in MSSQL.
> 
> 
> Please post the EXPLAIN ANALYZE output for the slow query, once
> with enable_seqscan on and once with it off.  For example:
> 
> SET enable_seqscan TO on;  -- if not already on
> EXPLAIN ANALYZE SELECT * FROM tblassociates WHERE clientnum = 'test';
> 
> SET enable_seqscan TO off;
> EXPLAIN ANALYZE SELECT * FROM tblassociates WHERE clientnum = 'test';
> 
> 
>>Be glad to provide the view and tables etc.
> 
> 
> Please do -- it might help us spot something that could be improved.
> What version of PostgreSQL are you using?
> 

Also, is clientnum a string datatype, or are you doing implicit type conversion?