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@candle.pha.pa.us               |  (610) 359-1001
  +  If your life is a hard drive,     |  13 Roberts Road
  +  Christ can be your backup.        |  Newtown Square, Pennsylvania 19073