Re: Slow counting still true?

From: Chris Travers <chris(dot)travers(at)gmail(dot)com>
To: Thomas Guettler <hv(at)tbz-pariv(dot)de>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Slow counting still true?
Date: 2012-09-17 09:13:50
Message-ID: CAKt_Zfs+45uD8VeVMx_U-r_+-CthY6ka7AMDn4YGNGeZJg8Wyw@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Mon, Sep 17, 2012 at 1:07 AM, Thomas Guettler <hv(at)tbz-pariv(dot)de> wrote:

> Release 9.2 should increase count(*) performance. Is this wiki page still
> valid?
>
> http://wiki.postgresql.org/**wiki/Slow_Counting<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

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Herouth Maoz 2012-09-17 11:07:49 Re: Index creation takes more time?
Previous Message Adam Mackler 2012-09-17 09:06:05 Can a view use a schema search_path?