Planner constants for RAM resident databases

Поиск
Список
Период
Сортировка
От Emil Briggs
Тема Planner constants for RAM resident databases
Дата
Msg-id 200507012159.39041.emil@baymountain.com
обсуждение исходный текст
Ответы Re: Planner constants for RAM resident databases  (Steve Atkins <steve@blighty.com>)
Re: Planner constants for RAM resident databases  (John A Meinel <john@arbash-meinel.com>)
Список pgsql-performance
I'm working with an application where the database is entirely resident in RAM
(the server is a quad opteron with 16GBytes of memory). It's a web
application and handles a high volume of queries. The planner seems to be
generating poor  plans for some of our queries which I can fix by raising
cpu_tuple_cost. I have seen some other comments in the archives saying that
this is a bad idea  but is that necessarily the case when the database is
entirely resident in RAM?

Emil

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

Предыдущее
От: John Mendenhall
Дата:
Сообщение: Re: ported application having performance issues
Следующее
От: Steve Atkins
Дата:
Сообщение: Re: Planner constants for RAM resident databases