Re: [GENERAL] Determining current block size?
In article [EMAIL PROTECTED], John Wells [EMAIL PROTECTED] wrote: % I see that BLOCK_SIZE can be set at compile time, but is there a way % to determine what block size is in use in a running system? I've been % searching but have been unsuccessful so far. show block_size; If you try to start the database with a postmaster compiled with the wrong block size, the error message tells you what block size you need. -- Patrick TJ McPhee North York Canada [EMAIL PROTECTED] ---(end of broadcast)--- TIP 4: Have you searched our list archives? http://archives.postgresql.org/
[GENERAL] Determining current block size?
I see that BLOCK_SIZE can be set at compile time, but is there a way to determine what block size is in use in a running system? I've been searching but have been unsuccessful so far. Thanks! John ---(end of broadcast)--- TIP 6: explain analyze is your friend
Re: [GENERAL] Determining current block size?
John Wells [EMAIL PROTECTED] writes: I see that BLOCK_SIZE can be set at compile time, but is there a way to determine what block size is in use in a running system? I've been searching but have been unsuccessful so far. postgres=# show block_size; block_size 8192 (1 row) -- Gregory Stark EnterpriseDB http://www.enterprisedb.com Ask me about EnterpriseDB's On-Demand Production Tuning ---(end of broadcast)--- TIP 3: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faq
Re: [GENERAL] Determining current block size?
On 12/6/07, Gregory Stark [EMAIL PROTECTED] wrote: John Wells [EMAIL PROTECTED] writes: I see that BLOCK_SIZE can be set at compile time, but is there a way to determine what block size is in use in a running system? I've been searching but have been unsuccessful so far. postgres=# show block_size; block_size 8192 (1 row) Well *that* was unexpected easy. Thanks! John ---(end of broadcast)--- TIP 9: In versions below 8.0, the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match