Postgres Pro
Downloads
Home   >   mailing lists

[PERFORMANCE] Insights: fseek OR read_cluster? - Mailing list pgsql-performance

From Antonio Rodriges
Subject [PERFORMANCE] Insights: fseek OR read_cluster?
Date
Msg-id CAPrLoNdTbOpYEvk8CTbKK6T0VjskGPNve2BCYZCg5RqwQJzvrw@mail.gmail.com
Whole thread Raw
Responses Re: [PERFORMANCE] Insights: fseek OR read_cluster?  (Craig Ringer <ringerc@ringerc.id.au>)
List pgsql-performance
Tree view 
Hello,

It is interesting how PostgreSQL reads the tablefiie.
Whether its indexes store/use filesystem clusters locations containing
required data (so it can issue a low level cluster read) or it just
fseeks inside a file?

Thank you

pgsql-performance by date:

Previous
From: Filip Rembiałkowski
Date:
Subject: Re: slow query on tables with new columns added.
Next
From: Mark Wong
Date:
Subject: Re: DBT-5 & Postgres 9.0.3