Re: There's random access and then there's random access - Mailing list pgsql-hackers

From Tom Lane
Subject Re: There's random access and then there's random access
Date
Msg-id 21814.1196616447@sss.pgh.pa.us
Whole thread Raw
In response to There's random access and then there's random access  (Gregory Stark <stark@enterprisedb.com>)
Responses 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>)
List 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 by date:

Previous
From: Gregory Stark
Date:
Subject: Re: There's random access and then there's random access
Next
From: Jens-Wolfhard Schicke
Date:
Subject: Re: There's random access and then there's random access