Re: There's random access and then there's random access

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: There's random access and then there's random access
Дата
Msg-id 21814.1196616447@sss.pgh.pa.us
обсуждение исходный текст
Ответ на There's random access and then there's random access  (Gregory Stark <stark@enterprisedb.com>)
Ответы Re: There's random access and then there's random access  (Jens-Wolfhard Schicke <drahflow@gmx.de>)
Re: There's random access and then there's random access  (Gregory Stark <stark@enterprisedb.com>)
Список pgsql-hackers
Gregory Stark <stark@enterprisedb.com> writes:
> Recently there was a post on -performance about a particular case where
> Postgres doesn't make very good use of the I/O system. This is when you try to
> fetch many records spread throughout a table in random order.

> http://archives.postgresql.org/pgsql-performance/2007-12/msg00005.php

Since the OP in that thread has still supplied zero information
(no EXPLAIN, let alone ANALYZE, and no version info), it's pure
guesswork as to what his problem is.
        regards, tom lane


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

Предыдущее
От: Gregory Stark
Дата:
Сообщение: Re: There's random access and then there's random access
Следующее
От: Jens-Wolfhard Schicke
Дата:
Сообщение: Re: There's random access and then there's random access