Quick Links

[PERFORMANCE] Insights: fseek OR read_cluster?

From:	Antonio Rodriges <antonio(dot)rrz(at)gmail(dot)com>
To:	pgsql-performance(at)postgresql(dot)org
Subject:	[PERFORMANCE] Insights: fseek OR read_cluster?
Date:	2011-09-24 06:49:42
Message-ID:	CAPrLoNdTbOpYEvk8CTbKK6T0VjskGPNve2BCYZCg5RqwQJzvrw@mail.gmail.com
Views:	Raw Message \| Whole Thread \| Download mbox \| Resend email
Thread:
Lists:	pgsql-performance

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

In response to

[PERFORMANCE] Insights: fseek OR read_cluster? at 2011-09-23 20:03:57 from Antonio Rodriges

Responses

Re: [PERFORMANCE] Insights: fseek OR read_cluster? at 2011-09-26 07:59:39 from Craig Ringer

Browse pgsql-performance by date

	From	Date	Subject
Next Message	Mark Wong	2011-09-24 15:45:51	Re: DBT-5 & Postgres 9.0.3
Previous Message	Filip Rembiałkowski	2011-09-24 06:10:13	Re: slow query on tables with new columns added.