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 Patches > Re: configure o...
Latest [ Topics | Posts ] Archive Post A New Topic Post a Reply
<< Topic < Post Post 1 of 1 Topic 3689 of 3869
Post > Topic >>

Re: configure option for XLOG_BLCKSZ

by simon@[EMAIL PROTECTED] (Simon Riggs) May 5, 2008 at 06:52 PM

On Mon, 2008-05-05 at 13:06 -0400, Tom Lane wrote:
> Alvaro Herrera <alvherre@[EMAIL PROTECTED]
> writes:
> >> On Sat, 03 May 2008 13:14:35 -0400 Tom Lane wrote:
> >>> I think the use-case for varying the WAL segment size is unrelated
to
> >>> performance of the master server, but would instead be concerned
with
> >>> adjusting the granularity of WAL log ****pping.
> 
> > Seems the stuff to zero out the unused segment tail would be more
useful
> > here.
> 
> Well, that's also useful, but it hardly seems like a substitute for
> picking a more optimal segment size in the first place.

I can't imagine having separately compiled executables depending upon
the write rate of different applications. What would you do if the write
rate increases over time (like it usually does)? How would you manage a
server farm like that? There's no practical answer there, just a great
way to introduce instability where there previously wasn't any.

-- 
  Simon Riggs
  2ndQuadrant  http://www.2ndQuadrant.com


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




 1 Posts in Topic:
Re: configure option for XLOG_BLCKSZ
simon@[EMAIL PROTECTED]   2008-05-05 18:52:23 

Post A Reply:
  Go here to Signup

AddThis Feed Button


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

Contact
tan13V112 Sun Jul 6 18:29:45 CDT 2008.