Re: Memory usage on subselect - Mailing list pgsql-sql

From Tom Lane
Subject Re: Memory usage on subselect
Date
Msg-id 10740.1085405857@sss.pgh.pa.us
Whole thread Raw
In response to Re: Memory usage on subselect  (Dan Field <dof@llgc.org.uk>)
Responses Re: Memory usage on subselect
List pgsql-sql
Dan Field <dof@llgc.org.uk> 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.
        regards, tom lane


pgsql-sql by date:

Previous
From: Dan Field
Date:
Subject: Re: Memory usage on subselect
Next
From: Andreas
Date:
Subject: Multitable uniqueness ?