Skip site navigation (1) Skip section navigation (2)

Re: What does this tell me?

From: Sean Chittenden <sean(at)chittenden(dot)org>
To: Josh Berkus <josh(at)agliodbs(dot)com>
Cc: Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us>,pgsql-performance(at)postgresql(dot)org
Subject: Re: What does this tell me?
Date: 2002-10-09 04:17:50
Message-ID: 20021009041750.GB56492@perrin.int.nxad.com (view raw or flat)
Thread:
Lists: pgsql-performance
> > Oh, yes, you are right.  My hardware tuning guide mentions it.
> > Strange it is called the transaction log file:
> > 
> >  http://www.ca.postgresql.org/docs/momjian/hw_performance/
> > 
> > Unless you are seeing this more freqently than every minute, it
> > should
> > be fine.
> 
> Actually, it's apparently a real problem, because the function never
> completes.  Each cycle of "recycling transaction logs" takes longer
> and longer, and eventually locks up completely.
> 
> What the function is doing is a succession of data cleanup
> procedures, updating the same table about 50 times.  I will be very
> thankful for the day when I can commit within a procedure.
> 
> Unfortunately, I am already at the maximum number of WAL files (64).
> What do I do now?

Isn't it possible to increase the size of your wal logs?  I seem to
remember a tunable existing, but I can't find it in the default
config.  Someone else know how off the top of their head?  -sc

-- 
Sean Chittenden

In response to

pgsql-performance by date

Next:From: Josh BerkusDate: 2002-10-09 04:33:52
Subject: Re: What does this tell me?
Previous:From: Bruce MomjianDate: 2002-10-09 04:07:24
Subject: Re: What does this tell me?

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group