Re: Various performance questions - Mailing list pgsql-performance

From Shridhar Daithankar
Subject Re: Various performance questions
Date
Msg-id 3F9CC7B3.2090501@persistent.co.in
Whole thread Raw
In response to Re: Various performance questions  (Dror Matalon <dror@zapatec.com>)
Responses Re: Various performance questions  (Dror Matalon <dror@zapatec.com>)
List pgsql-performance
Dror Matalon wrote:

> On Mon, Oct 27, 2003 at 01:04:49AM -0500, Christopher Browne wrote:
>>Most of the time involves:
>>
>> a) Reading each page of the table, and
>> b) Figuring out which records on those pages are still "live."
>
>
> The table has been VACUUM ANALYZED so that there are no "dead" records.
> It's still not clear why select count() would be slower than select with
> a "where" clause.

Do a vacuum verbose full and then everything should be within small range of
each other.

Also in the where clause, does explicitly typecasting helps?

Like 'where channel<5000::int2;'

  HTH

  Shridhar


pgsql-performance by date:

Previous
From: Dror Matalon
Date:
Subject: Re: Various performance questions
Next
From: Dror Matalon
Date:
Subject: Re: Various performance questions