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
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
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 ex
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 exposed, and I
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 exposed, and I run a query like:
select * from stats_record_view
whe