Re: [GENERAL] Slow counting still true?

2012-09-20 Thread Edson Richter
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.

Re: [GENERAL] Slow counting still true?

2012-09-18 Thread Jeff Janes
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

[GENERAL] Slow counting still true?

2012-09-17 Thread Thomas Guettler
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

Re: [GENERAL] Slow counting still true?

2012-09-17 Thread Chris Travers
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

Re: [GENERAL] Slow counting still true?

2012-09-17 Thread Jeff Janes
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

Re: [GENERAL] Slow counting still true?

2012-09-17 Thread Edson Richter
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

Re: [GENERAL] Slow counting still true?

2012-09-17 Thread Dann Corbit
@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