join_collapse_limit, from_collapse_limit options missing

Поиск
Список
Период
Сортировка
Искать

join_collapse_limit, from_collapse_limit options missing

От:
"Lee Hughes" <lee@owensforestproducts.com>
Дата:
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

Re: join_collapse_limit, from_collapse_limit options missing

От:
Tom Lane <tgl@sss.pgh.pa.us>
Дата:
"Lee Hughes"  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

Re: join_collapse_limit, from_collapse_limit options missing

От:
Josh Berkus <josh@agliodbs.com>
Дата:
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
FAQ