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

Re: sloooow query

From: Robert Treat <xzilla(at)users(dot)sourceforge(dot)net>
To: Justin Clift <justin(at)postgresql(dot)org>
Cc: marie(dot)tuite(at)edisonaffiliates(dot)com, josh(at)agliodbs(dot)com,pgsql-performance(at)postgresql(dot)org
Subject: Re: sloooow query
Date: 2002-10-07 20:50:27
Message-ID: 1034023827.3539.99.camel@camel (view raw or flat)
Thread:
Lists: pgsql-generalpgsql-performance
On Mon, 2002-10-07 at 16:15, Justin Clift wrote:
> Hi Marie,
> 
> Not sure the wal_files = 0 bit is good either.  Haven't seen that set to
> 0 before.
> 

This is the default value, and I don't recall anything in the docs that
would suggest to change it. Also IIRC the back end will auto adjust the
# of wal_files as needed in newer versions.  Unless your seeing messages
like "DEBUG: XLogWrite: new log file created - consider increasing
WAL_FILES" I think you can leave this alone. Can you point me to
something that says different?

Robert Treat



In response to

Responses

pgsql-performance by date

Next:From: Robert TreatDate: 2002-10-07 20:52:16
Subject: Re: sloooow query
Previous:From: Josh BerkusDate: 2002-10-07 20:44:31
Subject: Re: sloooow query

pgsql-general by date

Next:From: Robert TreatDate: 2002-10-07 20:52:16
Subject: Re: sloooow query
Previous:From: Josh BerkusDate: 2002-10-07 20:44:31
Subject: Re: sloooow query

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