On 12/6/07, Gregory Stark <stark@xxxxxxxxxxxxxxxx> wrote:
> "John Wells" <jb@xxxxxxxxxxxxxxxxxxxxx> 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
