my settings are:
effective_cache_size = 1000
random_page_cost = 4
work_mem = 20000
----- Original Message -----
From: "Josh Berkus" <josh@agliodbs.com>
To: "Jean-Pierre Pelletier" <[EMAIL PROTECTED]>
Sent: Thursday, September 22, 2005 6:58 PM
Subject: Re: [PERFORM] Queries 15 times slower on 8.1 beta 2 than on 8.0
Jean-Pierre,
How do I produce an "Index scan plan" ?
You just did. What's your effective_cache_size set to?
random_page_cost? work_mem?
--
--Josh
Josh Berkus
Aglio Database Solutions
San Francisco
---------------------------(end of broadcast)---------------------------
TIP 3: Have you checked our extensive FAQ?
http://www.postgresql.org/docs/faq