This looks very promising. I'll have to look over it and try a few things
out but I think it puts me on the right track.
Thanks!
--Rainer
> -----Original Message-----
> From: Tom Lane [mailto:tgl@sss.pgh.pa.us]
> Sent: Thursday, June 21, 2001 10:56 AM
> To: Rainer Mager
> Cc: PostgreSQL Admin
> Subject: Re: [ADMIN] High memory usage
>
>
> "Rainer Mager" <rmager@vgkk.com> writes:
> > First, this type of query seems to use exponential amounts of memory.
>
> Hmm. What does EXPLAIN show as the plan for the query? How long does
> it take to do the EXPLAIN? If the EXPLAIN alone takes a lot of time/
> space, then you need to reduce the size of the planner's search space
> with an explicit JOIN --- see
> http://www.ca.postgresql.org/users-lounge/docs/7.1/postgres/explic
> it-joins.html
>
> regards, tom lane