Talk About Network

Google


Register and Login
Nick
Password
Register create new account Sign up is FREE and you can post replies, new topics, bookmark posts and more!
Recover lost password


Data Bases > Pgsql Hackers > Re: Adding vari...
Latest [ Topics | Posts ] Archive Post A New Topic Post a Reply
<< Topic < Post Post 5 of 8 Topic 9371 of 11009
Post > Topic >>

Re: Adding variables for segment_size, wal_segment_size and block sizes

by ams@[EMAIL PROTECTED] (Abhijit Menon-Sen) Jul 8, 2008 at 09:15 AM

At 2008-07-03 16:36:02 +0200, mailings@[EMAIL PROTECTED]
 wrote:
>
> Here's a patch for this.

I reviewed the patch, it basically looks fine. A few quibbles with the
provided do***entation:

> +         Re****ts the number of pages which can be stored within a file
segment.  
> +         The total physical size of a segment file in bytes can be
determined by multiplying
> +         the <varname>block_size</varname> parameter with
<varname>segment_size</varname>.

I would say:

    Re****ts the number of blocks/pages which can be stored within a file
    segment. The total size of a segment file in bytes is equal to the
    <varname>segment_size</> multiplied by the <varname>block_size</>.

> +         Re****ts the size of a write ahead log disk block.  It is
determined by the value
> +         of <literal>XLOG_BLCKSZ</> when building the server. The
default
> +         value is 8192 bytes. <varname>wal_block_size</varname>
influences the total physical
> +         size of a write ahead log segment. See <xref
> +         linkend="guc-wal-segment-size"> for more information.
> +        </para>

I'd change "write ahead log disk block" to "WAL disk block". How about
this:

    Re****ts the size of a WAL disk block, as determined by the value of
    <literal>XLOG_BLCKSZ</> when compiling the server. The default is
    8192 bytes. <varname>wal_block_size</> influences the total size of
    a WAL segment file. See <xref linkend="guc-wal-segment-size"> for
    more information.

> +         Re****ts the number of pages within a write ahead log segment
file. <varname>wal_segment_size</varname> multiplied with
<varname>wal_block_size</varname> gives the total physical size of a write
ahead
> +         log segment file in bytes.

Again, I'd say "WAL" here instead of "write ahead log", because the full
form is clumsy in context. How about this:

    Re****ts the number of pages in a WAL segment file. The total size of
    a WAL segment file in bytes is equal to <varname>wal_segment_size</>
    multiplied by <varname>wal_block_size</>.

What do you think?

-- ams

-- 
Sent via pgsql-hackers mailing list (pgsql-hackers@[EMAIL PROTECTED]
)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-hackers
 




 8 Posts in Topic:
Adding variables for segment_size, wal_segment_size and block si
mailings@[EMAIL PROTECTED  2008-05-15 16:56:23 
Re: Adding variables for segment_size, wal_segment_size
euler@[EMAIL PROTECTED]   2008-05-17 12:14:58 
Re: Adding variables for segment_size,
bruce@[EMAIL PROTECTED]   2008-06-30 18:47:33 
Re: Adding variables for segment_size, wal_segment_size
mailings@[EMAIL PROTECTED  2008-07-03 16:36:02 
Re: Adding variables for segment_size, wal_segment_size and bloc
ams@[EMAIL PROTECTED] (A  2008-07-08 09:15:29 
Re: Adding variables for segment_size, wal_segment_size and bloc
tgl@[EMAIL PROTECTED] (T  2008-07-10 18:09:13 
Re: Adding variables for segment_size, wal_segment_size
simon@[EMAIL PROTECTED]   2008-07-04 10:48:03 
Re: Adding variables for segment_size, wal_segment_size
simon@[EMAIL PROTECTED]   2008-07-08 07:50:47 

Post A Reply:
  Go here to Signup

AddThis Feed Button


About - Advertising - Contact - Frequently Asked Questions - Privacy Policy - Terms of Use - Signup

Contact
tan12V112 Fri Dec 5 8:27:04 CST 2008.