Re: I: About "Our CLUSTER implementation is pessimal" patch
Alvaro Herrera <alvherre@commandprompt.com>
From: Alvaro Herrera <alvherre@commandprompt.com>
To: Josh Kupershmidt <schmiddy@gmail.com>
Cc: Itagaki Takahiro <itagaki.takahiro@gmail.com>, Leonardo Francalanci <m_lists@yahoo.it>, pgsql-hackers <pgsql-hackers@postgresql.org>
Date: 2010-09-29T04:27:50Z
Lists: pgsql-hackers
Excerpts from Josh Kupershmidt's message of mar sep 28 23:53:33 -0400 2010: > I started looking at the performance impact of this patch based on > Leonardo's SQL file. On the 2 million row table, I see a consistent > ~10% advantage for the sequential scan clusters. I'm going to try to > run the bigger tests a few times and post results from there when I > get a chance. 10% is nothing. I was expecting this patch would give an order of magnitude of improvement or somethine like that in the worst cases of the current code (highly unsorted input) -- Álvaro Herrera <alvherre@commandprompt.com> The PostgreSQL Company - Command Prompt, Inc. PostgreSQL Replication, Consulting, Custom Development, 24x7 support