From: | Stefan Kaltenbrunner <stefan(at)kaltenbrunner(dot)cc> |
---|---|
To: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
Cc: | "Joshua D(dot) Drake" <jd(at)commandprompt(dot)com>, Peter Eisentraut <peter_e(at)gmx(dot)net>, Josh Berkus <josh(at)agliodbs(dot)com>, pgsql-hackers(at)postgresql(dot)org |
Subject: | Re: [CORE] RC1 blocker issues |
Date: | 2006-11-27 07:17:18 |
Message-ID: | 456A90FE.4080209@kaltenbrunner.cc |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers |
Tom Lane wrote:
> "Joshua D. Drake" <jd(at)commandprompt(dot)com> writes:
>>> Nobody has a use for CREATE INDEX CONCURRENTLY?
>
>> Of course they do, again need not want. CREATE INDEX CONCURRENTLY is a
>> great feature but it isn't something that is whiz, bang, pow (such as
>> the enormous performance increase between 7.4/8.0 and 8.1).
>
> Hm, are you sure there aren't equivalent performance increases between
> 8.1 and 8.2? I don't know of any single performance fix we've done in
> the last ten years that's not a niche feature for some value of "niche".
> There are certainly things in 8.2 that are killer improvements for some
> classes of applications, just as 7.4, 8.0, and 8.1 could say the same
> for some other classes. Considering that 8.2 has been focused on
> performance fixes to a much greater degree than any prior release,
> I find it surprising that you're dismissing it as uninteresting on
> that dimension.
from the testing i have done with some of our production databases - 8.2
gives a tremendous performance boost (nearly on a similiar scale that
7.4->8.1 gave us!). Some of those gains are planner improvments (like
the out-joins enhancements others seem to come from the improved sorting
and concurrency. Last but least 8.2 seems to use a bit less of memory
for some queries too which helps concurrency.
So I'm a bit surprised that Josh is not considering those as very
interesting either ...
Stefan
From | Date | Subject | |
---|---|---|---|
Next Message | Joshua D. Drake | 2006-11-27 07:20:45 | Re: [CORE] RC1 blocker issues |
Previous Message | Michael Paesold | 2006-11-27 07:14:40 | Re: Missing ParameterStatus for backslash_quote |