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 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 im

Re: [GENERAL] Slow counting still true?

2012-09-18 Thread Jeff Janes
On Mon, Sep 17, 2012 at 9:14 AM, Edson Richter 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 seems that traversin

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 mailto:h...@tbz-pariv.de>> wrote: Release 9.2 should increase count(*) performance. Is this wiki page still valid?

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

Re: [GENERAL] Slow counting still true?

2012-09-17 Thread Jeff Janes
On Mon, Sep 17, 2012 at 1:07 AM, Thomas Guettler 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 fundamentally cha

Re: [GENERAL] Slow counting still true?

2012-09-17 Thread Chris Travers
On Mon, Sep 17, 2012 at 1:07 AM, Thomas Guettler 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, co

[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 pgsql