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

Поиск
Список
Период
Сортировка
От Jean-Pierre Pelletier
Тема Re: Queries 15 times slower on 8.1 beta 2 than on 8.0
Дата
Msg-id BAYC1-PASMTP04CCFCE482D65D3FEDA93D95970@CEZ.ICE
обсуждение исходный текст
Ответ на Queries 15 times slower on 8.1 beta 2 than on 8.0  ("Jean-Pierre Pelletier" <pelletier_32@sympatico.ca>)
Ответы Re: Queries 15 times slower on 8.1 beta 2 than on 8.0  (Josh Berkus <josh@agliodbs.com>)
Список pgsql-performance
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" <pelletier_32@sympatico.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

В списке pgsql-performance по дате отправления:

Предыдущее
От: "Jean-Pierre Pelletier"
Дата:
Сообщение: Re: Queries 15 times slower on 8.1 beta 2 than on 8.0
Следующее
От: Tom Lane
Дата:
Сообщение: Re: Queries 15 times slower on 8.1 beta 2 than on 8.0