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:[EMAIL PROTECTED]] > Sent: Thursday, June 21, 2001 10:56 AM > To: Rainer Mager > Cc: PostgreSQL Admin > Subject: Re: [ADMIN] High memory usage > > > "Rainer Mager" <[EMAIL PROTECTED]> 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 ---------------------------(end of broadcast)--------------------------- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/users-lounge/docs/faq.html
