Skip site navigation (1)
Skip section navigation (2)
Peripheral Links
Header And Logo
|
Site Navigation
wholly / partially table read into shared buffer
- From: Григорий Титов <nav73(at)narod(dot)ru>
- To: pgsql-admin(at)postgresql(dot)org
- Subject: wholly / partially table read into shared buffer
- Date: Thu, 20 Sep 2007 19:07:49 +0400
Hello! I am newbie in Postgres, but previously worked with Oracle. Now I am puzzled with heap_blks_hit/heap_blks_read ratio. I make select from table (whose size is larger than shared_buffer) and saw that it was wholly read from disk after second, third and so on runs. Isn't is wrong that RDBMS tries to cache table data blocks at least PARTIALLY in the case of insufficient cache buffer? WBW&R, Grigory Titov.
- Follow-Ups:
- Re: wholly / partially table read into shared buffer
- From: Simon Riggs
- Re: wholly / partially table read into shared buffer
- Prev by Date: Re: pgpool question?
- Next by Date: How to update from 8.1 to 8.2 ?
- Previous by thread: pgpool question?
- Next by thread: Re: wholly / partially table read into shared buffer
- Indexes: