Skip site navigation (1) Skip section navigation (2)

Re: Join problem

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Silke Trissl <trissl(at)informatik(dot)hu-berlin(dot)de>
Cc: pgsql-performance(at)postgresql(dot)org
Subject: Re: Join problem
Date: 2004-04-28 12:52:20
Message-ID: 27627.1083156740@sss.pgh.pa.us (view raw or flat)
Thread:
Lists: pgsql-performance
Silke Trissl <trissl(at)informatik(dot)hu-berlin(dot)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

In response to

pgsql-performance by date

Next:From: Tom LaneDate: 2004-04-28 13:05:04
Subject: Re: planner/optimizer question
Previous:From: Rod TaylorDate: 2004-04-28 12:23:35
Subject: Re: Simply join in PostrgeSQL takes too long

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group