Re: Finding Current Page Size

Curt Sampson wrote:
>
> How do I, in SQL, find out the page size used in the current database
> cluster?

Sure, but I am not sure how to determine this from SQL:

$ pg_controldata
pg_control version number: 72
Catalog version number: 200306051
Database cluster state: in production
pg_control last modified: 06/16/03 10:39:47
Current log file ID: 0
Next log file segment: 3
Latest checkpoint location: 0/27114C8
Prior checkpoint location: 0/941EB4
Latest checkpoint's REDO location: 0/27114C8
Latest checkpoint's UNDO location: 0/0
Latest checkpoint's StartUpID: 13
Latest checkpoint's NextXID: 6174
Latest checkpoint's NextOID: 156346
Time of latest checkpoint: 06/16/03 10:39:45
Database block size: 8192

^^^^
Blocks per segment of large relation: 131072
Maximum length of identifiers: 64
Maximum number of function arguments: 32
Date/time type storage: Floating point
Maximum length of locale name: 128
LC_COLLATE: C
LC_CTYPE: C

--
Bruce Momjian | http://candle.pha.pa.us
pgman(at)candle(dot)pha(dot)pa(dot)us | (610) 359-1001
+ If your life is a hard drive, | 13 Roberts Road
+ Christ can be your backup. | Newtown Square, Pennsylvania 19073