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 CAPrLoNeyDqHwsm80iVTDeUg8-pa+pG6D43K8O1_rG2o9KHBGLw@mail.gmail.com
Whole thread Raw
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: Antonio Rodriges
Date:
Subject: Re: [PERFORMANCE] Insights: fseek OR read_cluster?
Next
From: Timothy Garnett
Date:
Subject: Performance Anomaly with "col in (A,B)" vs. "col = A OR col = B" ver. 9.0.3