Re: Finding Current Page Size

From: Curt Sampson <cjs(at)cynic(dot)net>
To: Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Finding Current Page Size
Date: 2003-06-17 09:40:14
Message-ID: Pine.NEB.4.51.0306171834330.408@angelic-vtfw.cvpn.cynic.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Mon, 16 Jun 2003, Bruce Momjian wrote:

> 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
> ...
> Database block size: 8192

Right. So, basically, write a C function to do it. I'll probably get
around to doing that one day and contributing it, but it's not really
all that high on my priority list right now.

cjs
--
Curt Sampson <cjs(at)cynic(dot)net> +81 90 7737 2974 http://www.netbsd.org
Don't you know, in this new Dark Age, we're all light. --XTC

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Kaarel 2003-06-17 09:57:08 Re: Postgres performance comments from a MySQL user
Previous Message Nigel J. Andrews 2003-06-17 09:39:05 Damn triggers and NEW