[HACKERS] File IO - why does PG do things in pages?

2009-11-26 Thread Dan Eloff
Hi Hackers, I've familiarized myself a little with the architecture of postgresql, largely because it's interesting. There's one thing I can't quite figure out though, and it seems that there's no better group of people in the world to ask about it. At the lower levels in PG, reading from the

Re: [HACKERS] File IO - why does PG do things in pages?

2009-11-26 Thread Florian G. Pflug
Dan Eloff wrote: At the lower levels in PG, reading from the disk into cache, and writing from the cache to the disk is always done in pages. Why does PG work this way? Is it any slower to write whole pages rather than just the region of the page that changed? Conversely, is it faster? From

Re: [HACKERS] File IO - why does PG do things in pages?

2009-11-26 Thread Robert Haas
On Thu, Nov 26, 2009 at 4:14 PM, Dan Eloff dan.el...@gmail.com wrote: Hi Hackers, I've familiarized myself a little with the architecture of postgresql, largely because it's interesting. There's one thing I can't quite figure out though, and it seems that there's no better group of people in