Обсуждение: join_collapse_limit, from_collapse_limit options missing
Hi, I'm trying to set these two options to tune performance but both return 'not a valid option name'. Dumping the pg_settings table confirms that they are missing. I'm using the PostgreSQL packages included with RedHat 9 (7.3.2) and Mandrake 9.2 Beta (7.3.4). Do I need to install the full tarball to get these options? Any help greatly appreciated. Thanks, Lee
"Lee Hughes" <lee@owensforestproducts.com> writes: > Hi, I'm trying to set these two options to tune performance but both > return 'not a valid option name'. Dumping the pg_settings table confirms > that they are missing. I'm using the PostgreSQL packages included with > RedHat 9 (7.3.2) and Mandrake 9.2 Beta (7.3.4). Do I need to install the > full tarball to get these options? Any help greatly appreciated. They don't exist in 7.3. Why are you consulting 7.4 documentation for a 7.3 installation? regards, tom lane
Lee, > Hi, I'm trying to set these two options to tune performance but both > return 'not a valid option name'. Dumping the pg_settings table confirms > that they are missing. I'm using the PostgreSQL packages included with > RedHat 9 (7.3.2) and Mandrake 9.2 Beta (7.3.4). Do I need to install the > full tarball to get these options? Any help greatly appreciated. If you're working from the documentation on General Bits, please notice that both of those options are marked as "new for 7.4". -- Josh Berkus Aglio Database Solutions San Francisco