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

From: "Jean-Pierre Pelletier" <pelletier_32(at)sympatico(dot)ca>
To: <josh(at)agliodbs(dot)com>
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:10:25
Message-ID: BAYC1-PASMTP04CCFCE482D65D3FEDA93D95970@CEZ.ICE
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

my settings are:

effective_cache_size = 1000
random_page_cost = 4
work_mem = 20000

----- Original Message -----
From: "Josh Berkus" <josh(at)agliodbs(dot)com>
To: "Jean-Pierre Pelletier" <pelletier_32(at)sympatico(dot)ca>
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

In response to

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Tom Lane 2005-09-22 23:12:14 Re: Queries 15 times slower on 8.1 beta 2 than on 8.0
Previous Message Jean-Pierre Pelletier 2005-09-22 23:07:41 Re: Queries 15 times slower on 8.1 beta 2 than on 8.0