Postgres Pro
Downloads
Home   >   mailing lists

Re: Seqscan rather than Index - Mailing list pgsql-performance

From Tom Lane
Subject Re: Seqscan rather than Index
Date
Msg-id 27633.1103344657@sss.pgh.pa.us
Whole thread Raw
In response to Re: Seqscan rather than Index  (Frank Wiles <frank@wiles.org>)
Responses Re: Seqscan rather than Index
List pgsql-performance
Tree view 
Frank Wiles <frank@wiles.org> writes:
>   I've also seen a huge difference between select count(*) and
>   select count(1) in older versions,

That must have been before my time, ie, pre-6.4 or so.  There is
certainly zero difference now.

            regards, tom lane

pgsql-performance by date:

Previous
From: Bruno Wolff III
Date:
Subject: Re: Seqscan rather than Index
Next
From: John A Meinel
Date:
Subject: Re: Improve performance of query