| 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: | Whole Thread | Raw Message | 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-----
| 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 |