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

From Frank Wiles
Subject Re: Seqscan rather than Index
Date
Msg-id 20041220134059.215cf049.frank@wiles.org
Whole thread Raw
In response to Re: Seqscan rather than Index  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-performance
On Fri, 17 Dec 2004 23:37:37 -0500
Tom Lane <tgl@sss.pgh.pa.us> wrote:

> 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.

  Yeah now that I think about it that sounds about the right time
  frame I last benchmarked it.

 ---------------------------------
   Frank Wiles <frank@wiles.org>
   http://www.wiles.org
 ---------------------------------


pgsql-performance by date:

Previous
From: sarlav kumar
Date:
Subject: Re: Postgres version change - pg_dump
Next
From: sarlav kumar
Date:
Subject: slony replication