Re: [SQL] Memory usage on subselect

2004-05-24 Thread Tom Lane
Dan Field <[EMAIL PROTECTED]> writes: > I have a similar problem with just one of my queries (although it isn't > a sub select): You really ought to vacuum and/or analyze occasionally. The EXPLAIN results show that the planner hasn't got any non-default statistics for any of these tables.

Re: [SQL] Memory usage on subselect

2004-05-24 Thread Dan Field
On 23 May 2004, at 19:32, Alexander M. Pravking wrote: BTW, after cancelling the original query postgres freed all the memory, and used ~7M again, so the leak was not "forever". I have a similar problem with just one of my queries (although it isn't a sub select): SELECT da_records.* FROM d