Em 18/09/2012 15:24, Jeff Janes escreveu:
On Mon, Sep 17, 2012 at 9:14 AM, Edson Richter edsonrich...@hotmail.com wrote:
The wiki page in question has been updated today, and I see the alert in top
of page Note that the following article only applies to versions of
PostgreSQL prior to 9.2.
On Mon, Sep 17, 2012 at 9:14 AM, Edson Richter edsonrich...@hotmail.com wrote:
The wiki page in question has been updated today, and I see the alert in top
of page Note that the following article only applies to versions of
PostgreSQL prior to 9.2. Index-only scans are now implemented.
So
Release 9.2 should increase count(*) performance. Is this wiki page still valid?
http://wiki.postgresql.org/wiki/Slow_Counting
Please update the content.
Thank you,
Thomas Güttler
--
Thomas Guettler, http://www.thomas-guettler.de/
E-Mail: guettli (*) thomas-guettler + de
--
Sent via
On Mon, Sep 17, 2012 at 1:07 AM, Thomas Guettler h...@tbz-pariv.de wrote:
Release 9.2 should increase count(*) performance. Is this wiki page still
valid?
http://wiki.postgresql.org/**wiki/Slow_Countinghttp://wiki.postgresql.org/wiki/Slow_Counting
Please update the content.
As I
On Mon, Sep 17, 2012 at 1:07 AM, Thomas Guettler h...@tbz-pariv.de wrote:
Release 9.2 should increase count(*) performance. Is this wiki page still
valid?
Even with index only scans, it still has to walk through every tuple,
even if they are only index tuples not table tuples. So nothing has
Em 17/09/2012 06:13, Chris Travers escreveu:
On Mon, Sep 17, 2012 at 1:07 AM, Thomas Guettler h...@tbz-pariv.de
mailto:h...@tbz-pariv.de wrote:
Release 9.2 should increase count(*) performance. Is this wiki
page still valid?
http://wiki.postgresql.org/wiki/Slow_Counting
@postgresql.org
Subject: Re: [GENERAL] Slow counting still true?
Em 17/09/2012 06:13, Chris Travers escreveu:
On Mon, Sep 17, 2012 at 1:07 AM, Thomas Guettler
h...@tbz-pariv.demailto:h...@tbz-pariv.de wrote:
Release 9.2 should increase count(*) performance. Is this wiki page still valid?
http