pg.ddx.io  pgsql-performance@postgresql.org mailing list archive  
help / color / mirror / Atom feed
join_collapse_limit, from_collapse_limit options missing
3+ messages / 3 participants
[nested] [flat]

* join_collapse_limit, from_collapse_limit options missing
@ 2003-11-03 16:20  Lee Hughes <lee@owensforestproducts.com>
  0 siblings, 2 replies; 3+ messages in thread

From: Lee Hughes @ 2003-11-03 16:20 UTC (permalink / raw)
  To: pgsql-performance

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



^ permalink  raw  reply  [nested|flat] 3+ messages in thread

* Re: join_collapse_limit, from_collapse_limit options missing
@ 2003-11-03 16:24  Tom Lane <tgl@sss.pgh.pa.us>
  parent: Lee Hughes <lee@owensforestproducts.com>
  1 sibling, 0 replies; 3+ messages in thread

From: Tom Lane @ 2003-11-03 16:24 UTC (permalink / raw)
  To: Lee Hughes <lee@owensforestproducts.com>; +Cc: pgsql-performance

"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



^ permalink  raw  reply  [nested|flat] 3+ messages in thread

* Re: join_collapse_limit, from_collapse_limit options missing
@ 2003-11-03 18:41  Josh Berkus <josh@agliodbs.com>
  parent: Lee Hughes <lee@owensforestproducts.com>
  1 sibling, 0 replies; 3+ messages in thread

From: Josh Berkus @ 2003-11-03 18:41 UTC (permalink / raw)
  To: Lee Hughes <lee@owensforestproducts.com>; pgsql-performance

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



^ permalink  raw  reply  [nested|flat] 3+ messages in thread


end of thread, other threads:[~2003-11-03 18:41 UTC | newest]

Thread overview: 3+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2003-11-03 16:20 join_collapse_limit, from_collapse_limit options missing Lee Hughes <lee@owensforestproducts.com>
2003-11-03 16:24 ` Tom Lane <tgl@sss.pgh.pa.us>
2003-11-03 18:41 ` Josh Berkus <josh@agliodbs.com>

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox