Re: 7.3.1 New install, large queries are slow

Поиск
Список
Период
Сортировка
От Curt Sampson
Тема Re: 7.3.1 New install, large queries are slow
Дата
Msg-id Pine.NEB.4.51.0301281952590.1575@angelic.cynic.net
обсуждение исходный текст
Ответ на Re: 7.3.1 New install, large queries are slow  (Ron Johnson <ron.l.johnson@cox.net>)
Список pgsql-performance
On Tue, 27 Jan 2003, Ron Johnson wrote:

> [read-ahead detection stuff deleted]
>
> It wouldn't work well, though, in a client-server DB like Postgres,
> which, in a busy multi-user system, is constantly hitting different
> parts of different files.

It works great. You just do it on a file-descriptor by file-descriptor
basis.

Unfortunately, I don't know of any OSes that detect backwards scans.

cjs
--
Curt Sampson  <cjs@cynic.net>   +81 90 7737 2974   http://www.netbsd.org
    Don't you know, in this new Dark Age, we're all light.  --XTC

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

Предыдущее
От: Stephan Szabo
Дата:
Сообщение: Re: Indexing foreign keys
Следующее
От: Ron Johnson
Дата:
Сообщение: Re: Indexing foreign keys