-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 On Thu, 17 Jan 2008 16:54:47 -0500 Tom Lane <[EMAIL PROTECTED]> wrote:
> > - -1? That way by default it will use the settings in > > postgresql.conf? > > Surely we're not going to force initdb for that. I didn't realize it would take that so sure lets do it for 8.4. > > > Secondly can we set the default for freeze_min_age to 100mil (I > > think that is the default in the docs) and freeize_max_age to the > > default 200000000 . > > This is an outright bad idea, because those defaults aren't > hard-wired. Why would you not use -1 if you want a default value? There are two things here. One having a default value 8.2 currently doesn't (8.3 I don't know). Two what the default value should be. I will happily defer to you on that determination. Sincerely, Joshua D. Drake - -- The PostgreSQL Company: Since 1997, http://www.commandprompt.com/ Sales/Support: +1.503.667.4564 24x7/Emergency: +1.800.492.2240 Donate to the PostgreSQL Project: http://www.postgresql.org/about/donate SELECT 'Training', 'Consulting' FROM vendor WHERE name = 'CMD' -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.4.6 (GNU/Linux) iD8DBQFHj9FuATb/zqfZUUQRAlt3AKCWo+v26U2iyD2wpoRAQxFlmHwfWwCePyYf qQcaopPJ1ocYe+kcKIwEWYM= =AtNk -----END PGP SIGNATURE----- ---------------------------(end of broadcast)--------------------------- TIP 9: In versions below 8.0, the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match
