Re: gprof SELECT COUNT(*) results

Peripheral Links

From: Christopher Kings-Lynne <chriskl(at)familyhealth(dot)com(dot)au>
To: Simon Riggs <simon(at)2ndquadrant(dot)com>
Cc: Qingqing Zhou <zhouqq(at)cs(dot)toronto(dot)edu>, pgsql-hackers(at)postgresql(dot)org
Subject: Re: gprof SELECT COUNT(*) results
Date: Sun, 27 Nov 2005 00:21:00 +0800
Message-id: <43888B6C(dot)8050501(at)familyhealth(dot)com(dot)au>

...and for emphasis: this optimization of SeqScans is not possible with
any other database system, so its a big win for PostgreSQL.

With any other db system? That's a big call. Why? Not even other MVCCsystems?


Chris

References:
- gprof SELECT COUNT(*) results
  - From: Qingqing Zhou
- Re: gprof SELECT COUNT(*) results
  - From: Simon Riggs
- Re: gprof SELECT COUNT(*) results
  - From: Qingqing Zhou
- Re: gprof SELECT COUNT(*) results
  - From: Tom Lane
- Re: gprof SELECT COUNT(*) results
  - From: Simon Riggs
- Re: gprof SELECT COUNT(*) results
  - From: Tom Lane
- Re: gprof SELECT COUNT(*) results
  - From: Qingqing Zhou
- Re: gprof SELECT COUNT(*) results
  - From: Simon Riggs

Home | Main Index | Thread Index