Postgres Pro
Downloads
Home   >   mailing lists

Re: Slow counting still true? - Mailing list pgsql-general

From Chris Travers
Subject Re: Slow counting still true?
Date
Msg-id CAKt_Zfs+45uD8VeVMx_U-r_+-CthY6ka7AMDn4YGNGeZJg8Wyw@mail.gmail.com
Whole thread Raw
In response to Slow counting still true?  (Thomas Guettler <hv@tbz-pariv.de>)
Responses Re: Slow counting still true?  (Edson Richter <edsonrichter@hotmail.com>)
List pgsql-general
Tree view


On Mon, Sep 17, 2012 at 1:07 AM, Thomas Guettler <hv@tbz-pariv.de> wrote:
Release 9.2 should increase count(*) performance. Is this wiki page still valid?

http://wiki.postgresql.org/wiki/Slow_Counting

Please update the content.

As I understand it, covering indexes don't currently help with count(*) because indexes can't be traversed in physical order, so it is a matter of trading random disk I/O for a much larger amount of sequential disk I/O.

Best Wishes,
Chris Travers

pgsql-general by date:

Previous
From: Rafal Pietrak
Date:
Subject: foreign key from array element
Next
From: "Herouth Maoz"
Date:
Subject: Re: Index creation takes more time?