Re: Join problem - Mailing list pgsql-performance

From Tom Lane
Subject Re: Join problem
Date
Msg-id 27627.1083156740@sss.pgh.pa.us
Whole thread Raw
In response to Join problem  (Silke Trissl <trissl@informatik.hu-berlin.de>)
List pgsql-performance
Silke Trissl <trissl@informatik.hu-berlin.de> writes:
> I found out, that the change of the operator from '~*' to '=' for the
> item.description brought a great boost in performance (425 secs to 1
> sec!), but not in cost (Query plans at the end).

The main problem seems to be bad estimation of the number of rows
extracted from the item table.  Have you ANALYZEd that table lately?

            regards, tom lane

pgsql-performance by date:

Previous
From: Rod Taylor
Date:
Subject: Re: Simply join in PostrgeSQL takes too long
Next
From: Tom Lane
Date:
Subject: Re: planner/optimizer question