Raising the geqo_threshold default

From: "Greg Sabino Mullane" <greg(at)turnstep(dot)com>
To: pgsql-hackers(at)postgresql(dot)org
Subject: Raising the geqo_threshold default
Date: 2009-11-17 02:23:35
Message-ID: 7a2dd95083af1c9d42e839828af94243@biglumber.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers


-----BEGIN PGP SIGNED MESSAGE-----
Hash: RIPEMD160

Is there any chance we can raise the default geqo_threshold from
its current default of 12? This seems too low, as a modern Postgres
on modern hardware has no problem with 12 table joins. However, I have
seen geqo causing trouble for clients when they hit 12 and get
random (and crappy) query plans. Is the value of 12 based on any
recent measurements? Thanks.

- --
Greg Sabino Mullane greg(at)turnstep(dot)com
End Point Corporation
PGP Key: 0x14964AC8 200911162121
http://biglumber.com/x/web?pk=2529DF6AB8F79407E94445B4BC9B906714964AC8
-----BEGIN PGP SIGNATURE-----

iEYEAREDAAYFAksCCN8ACgkQvJuQZxSWSsihOwCgyRldD/QS63rQzcBO6ZoyI/zH
NPUAoNmkgf3Txr/V6p2oZJ/tNY8gx/mt
=u1ut
-----END PGP SIGNATURE-----

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Greg Smith 2009-11-17 02:25:34 Re: Partitioning option for COPY
Previous Message Robert Haas 2009-11-17 02:14:40 Re: next CommitFest