Re: Queries 15 times slower on 8.1 beta 2 than on 8.0

From: Josh Berkus <josh(at)agliodbs(dot)com>
To: "Jean-Pierre Pelletier" <pelletier_32(at)sympatico(dot)ca>
Cc: pgsql-performance(at)postgresql(dot)org
Subject: Re: Queries 15 times slower on 8.1 beta 2 than on 8.0
Date: 2005-09-22 23:16:25
Message-ID: 200509221616.25781.josh@agliodbs.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

Jean-Pierre,

> effective_cache_size = 1000

Try setting this to 16,384 as a test.

> random_page_cost = 4

Try setting this to 2.5 as a test.

> work_mem = 20000

--
--Josh

Josh Berkus
Aglio Database Solutions
San Francisco

In response to

Browse pgsql-performance by date

  From Date Subject
Next Message Michael Fuhr 2005-09-22 23:17:46 Re: Queries 15 times slower on 8.1 beta 2 than on 8.0
Previous Message Tom Lane 2005-09-22 23:12:14 Re: Queries 15 times slower on 8.1 beta 2 than on 8.0