Postgres Pro
Downloads
Home   >   mailing lists

Re: slow select - Mailing list pgsql-performance

From Josh Berkus
Subject Re: slow select
Date
Msg-id 200310221403.12570.josh@agliodbs.com
Whole thread Raw
In response to Re: slow select  ("Medora Schauer" <mschauer@fairfield.com>)
List pgsql-performance
Tree view 
Medora,

> So why did were the indices not used before when they yield a better plan?

Your .conf settings, most likely.  I'd lower your random_page_cost and raise
your effective_cache_size.

--
-Josh Berkus
 Aglio Database Solutions
 San Francisco

pgsql-performance by date:

Previous
From: "Medora Schauer"
Date:
Subject: Re: slow select
Next
From: "Medora Schauer"
Date:
Subject: Re: slow select