[pgsql-cluster-hackers][performance] fast reads on a busy server

Поиск
Список
Период
Сортировка
От Willy-Bas Loos
Тема [pgsql-cluster-hackers][performance] fast reads on a busy server
Дата
Msg-id CAHnozTgLOqcAZWJu482Nh9K0f2BobXh3LPGYvycvr+Tb8prozw@mail.gmail.com
обсуждение исходный текст
Ответы Re: [pgsql-cluster-hackers][performance] fast reads on a busy server  (Hannu Krosing <hannu@2ndQuadrant.com>)
Список pgsql-performance
Дерево обсуждения
Hi,

I've read this:
http://wiki.postgresql.org/wiki/Prioritizing_databases_by_separating_into_multiple_clusters

But it doesn't really say anything about memory.
If i can fit an extra cluster into it's shared buffer, it should have fast reads, right?
Even if i don't have seperate spindles and the disks are busy.
This is on a Debain server, postgres 8.4

Cheers,

WBL
--
"Quality comes from focus and clarity of purpose" -- Mark Shuttleworth

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

Предыдущее
От: Merlin Moncure
Дата:
Сообщение: Re: Can I do better than this heapscan and sort?
Следующее
От: Hannu Krosing
Дата:
Сообщение: Re: [pgsql-cluster-hackers][performance] fast reads on a busy server