Re: Running PostgreSQL as fast as possible no matter the consequences

Поиск
Список
Период
Сортировка
От Thom Brown
Тема Re: Running PostgreSQL as fast as possible no matter the consequences
Дата
Msg-id AANLkTikn_rY0wrasvNz23Mmuw6g5FDkruvomJeZwqVEU@mail.gmail.com
обсуждение исходный текст
Ответ на Re: Running PostgreSQL as fast as possible no matter the consequences  (Marti Raudsepp <marti@juffo.org>)
Список pgsql-performance
Дерево обсуждения
On 5 November 2010 11:36, Marti Raudsepp <marti@juffo.org> wrote:
On Fri, Nov 5, 2010 at 13:32, A B <gentosaker@gmail.com> wrote:
> I was just thinking about the case where I will have almost 100%
> selects, but still needs something better than a plain key-value
> storage so I can do some sql queries.
> The server will just boot, load data, run,  hopefully not crash but if
> it would, just start over with load and run.

If you want fast read queries then changing
fsync/full_page_writes/synchronous_commit won't help you. 

Yes, those will be for write-performance only, so useless in this case.

--
Thom Brown
Twitter: @darkixion
IRC (freenode): dark_ixion
Registered Linux user: #516935

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

Предыдущее
От: Marti Raudsepp
Дата:
Сообщение: Re: Running PostgreSQL as fast as possible no matter the consequences
Следующее
От: Marti Raudsepp
Дата:
Сообщение: Re: Running PostgreSQL as fast as possible no matter the consequences