Re: [PERFORMANCE] Insights: fseek OR read_cluster?

From: Antonio Rodriges <antonio(dot)rrz(at)gmail(dot)com>
To: Craig Ringer <ringerc(at)ringerc(dot)id(dot)au>, pgsql-performance(at)postgresql(dot)org
Subject: Re: [PERFORMANCE] Insights: fseek OR read_cluster?
Date: 2011-09-26 12:51:12
Message-ID: CAPrLoNc2FO0mm6vzm2rc5WRyfQmtpQAJWZpvPr+bwuAZPHZ+tA@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

Thank you, Craig, your answers are always insightful

> What is read_cluster()  ? Are you talking about some kind of async and/or

I meant that if you want to read a chunk of data from file you (1)
might not call traditional fseek but rather memorize hard drive
cluster numbers to boost disk seeks and, (2) perform the read of disk
cluster directly.

> direct I/O? If so, PostgreSQL is not designed for direct I/O, it benefits
> from using the OS's buffer cache, I/O scheduler, etc.
>
> IIRC Pg uses pread() to read from its data files, but I didn't go double
> check in the sources to make sure.
>
> --
> Craig Ringer
>

In response to

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Biswa 2011-09-26 13:34:44 How to find record having % as part of data.
Previous Message Marc Cousin 2011-09-26 09:39:01 Re: overzealous sorting?