Re: [PERFORM] plan problem

2004-04-09 Thread Tom Lane
Ken Geis [EMAIL PROTECTED] writes: Does anyone think that the planner issue has merit to address? Can someone help me figure out what code I would look at? The planner doesn't currently attempt to drill down into a sub-select- in-FROM to find statistics about the variables emitted by the

Re: [PERFORM] plan problem

2004-04-07 Thread Ken Geis
Richard Huxton wrote: On Tuesday 06 April 2004 21:25, Ken Geis wrote: I am trying to find an efficient way to draw a random sample from a complex query. I also want it to be easy to use within my application. So I've defined a view that encapsulates the query. The id in the driving table is

Re: [PERFORM] plan problem

2004-04-07 Thread Richard Huxton
On Wednesday 07 April 2004 10:03, Ken Geis wrote: Richard Huxton wrote: On Tuesday 06 April 2004 21:25, Ken Geis wrote: I am trying to find an efficient way to draw a random sample from a complex query. I also want it to be easy to use within my application. So I've defined a view that