Greg Stark wrote: > Bruce Momjian <[EMAIL PROTECTED]> writes: > > > I hate to reply to this because I have already cast my vote, but > > "block_size" does not report the size of a disk block. It reports the > > size of a PostgreSQL block/page. Disk blocks are almost always 512 > > bytes in size. > > Perhaps then neither "block" nor "page" is best. Perhaps it should be > "buffer_size" or something like that?
It is really the storage block size, and that is manifest in the buffer size and disk block size used. -- Bruce Momjian | http://candle.pha.pa.us [EMAIL PROTECTED] | (610) 359-1001 + If your life is a hard drive, | 13 Roberts Road + Christ can be your backup. | Newtown Square, Pennsylvania 19073 ---------------------------(end of broadcast)--------------------------- TIP 9: the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match
