From: | "Ross J(dot) Reedstrom" <reedstrm(at)rice(dot)edu> |
---|---|
To: | pgsql-hackers(at)postgresql(dot)org |
Subject: | Re: Pull up aggregate subquery |
Date: | 2011-05-25 17:21:14 |
Message-ID: | 20110525172114.GC31648@rice.edu |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers |
On Mon, May 23, 2011 at 11:08:40PM -0400, Robert Haas wrote:
>
> I don't really like the idea of adding a GUC for this, unless we
> convince ourselves that nothing else is sensible. I mean, that leads
> to conversations like this:
>
> Newbie: My query is slow.
> Hacker: Turn on enable_magic_pixie_dust and it'll get better.
> Newbie: Oh, yeah, that is better. Why isn't this turned on by default, anyway?
> Hacker: Well, on pathological queries, it makes planning take way too
> long, so we think it's not really safe to enable it by default.
> Newbie: Wait... I thought you just told me to enable it. It's not safe?
> Hacker: Well, sort of. I mean, uh... hey, look, an elephant!
>
ROTFL! This needs to go on the wiki somewhere discussing why HACKERs
rejects tunable knobs as often as happens.
Ross
--
Ross Reedstrom, Ph.D. reedstrm(at)rice(dot)edu
Systems Engineer & Admin, Research Scientist phone: 713-348-6166
Connexions http://cnx.org fax: 713-348-3665
Rice University MS-375, Houston, TX 77005
GPG Key fingerprint = F023 82C8 9B0E 2CC6 0D8E F888 D3AE 810E 88F0 BEDE
From | Date | Subject | |
---|---|---|---|
Next Message | Bruce Momjian | 2011-05-25 17:22:36 | Re: [BUGS] BUG #6034: pg_upgrade fails when it should not. |
Previous Message | Robert Haas | 2011-05-25 17:15:59 | Re: [ADMIN] pg_class reltuples/relpages not updated by autovacuum/vacuum |