Postgres Pro
Downloads
Home   >   mailing lists

Re: Simply join in PostrgeSQL takes too long - Mailing list pgsql-performance

From Josh Berkus
Subject Re: Simply join in PostrgeSQL takes too long
Date
Msg-id 200404291510.08757.josh@agliodbs.com
Whole thread Raw
In response to Re: Simply join in PostrgeSQL takes too long  (Vitaly Belman <vitalib@012.net.il>)
List pgsql-performance
Tree view 
Vitaly,

> I am in the middle of going through them all, till now disabling the
> enable_mergejoin really helped.

In that case, your random_page_cost is probably too low.   Check the ratio of
per-tuple times on index vs. seqscan seeks.

--
-Josh Berkus
 Aglio Database Solutions
 San Francisco

pgsql-performance by date:

Previous
From: Tom Lane
Date:
Subject: Re: planner/optimizer question
Next
From: "Gary Doades"
Date:
Subject: Re: planner/optimizer question