From: | Joe Conway <mail(at)joeconway(dot)com> |
---|---|
To: | Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us> |
Cc: | "Marc G(dot) Fournier" <scrappy(at)postgresql(dot)org>, "Hackers (PostgreSQL)" <pgsql-hackers(at)postgresql(dot)org> |
Subject: | Re: request for feedback - read-only GUC variables, |
Date: | 2003-12-04 14:57:37 |
Message-ID: | 3FCF4B61.8000800@joeconway.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers |
Bruce Momjian wrote:
> Marc G. Fournier wrote:
>>I'd go with block_size ...
>
> True, page size usually references virtual memory pages, so it is
> related to virtual memory mapping. Block size is much more related to
> on-disk storage, true. The only reason I was leaning toward page is
> that it is possible to confuse disk block (512 bytes) with a PostgreSQL
> block (8k), but maybe that is not relivant.
I committed this yesterday as block_size because that had the majority
support. Of course it's not too late to change it, but as Tom mentioned,
we want to settle on something relatively quickly and then not mess with
it afterwards.
As another data point in the discussion, pg_controldata gives this:
# pg_controldata
pg_control version number: 72
Catalog version number: 200312031
Database cluster state: in production
pg_control last modified: Wed Dec 3 12:06:35 2003
Current log file ID: 0
Next log file segment: 3
Latest checkpoint location: 0/27D5EEC
Prior checkpoint location: 0/9BA8A0
Latest checkpoint's REDO location: 0/27D5EEC
Latest checkpoint's UNDO location: 0/0
Latest checkpoint's StartUpID: 14
Latest checkpoint's NextXID: 6376
Latest checkpoint's NextOID: 156406
Time of latest checkpoint: Wed Dec 3 12:06:31 2003
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: 64-bit integers
Maximum length of locale name: 128
LC_COLLATE: C
LC_CTYPE: C
Note that pg_controldata also uses "block size", so I'm still inclined
to stick with that.
Joe
From | Date | Subject | |
---|---|---|---|
Next Message | Andrew Dunstan | 2003-12-04 15:00:37 | Re: Encoding problem with 7.4 |
Previous Message | E.Rodichev | 2003-12-04 14:21:52 | Re: Encoding problem with 7.4 |