Horton
Menu

Re: [NOVICE] Re: Sizing of LARGE databases.

Francisco Reyes <fran@reyes.somos.net>

View thread
From: Francisco Reyes <fran@reyes.somos.net>
To: Justin Clift <aa2@bigpond.net.au>
Cc: <mykarz@miyabara.com>, <pgsql-novice@postgresql.org>, <pgsql-general@postgresql.org>
Date: 2001-02-02T05:30:40Z
Lists: pgsql-general 
On Wed, 31 Jan 2001, Justin Clift wrote:
> The biggest limitation I have found with this is the
> /opt/postgres/data/pg_log file seeming to need to log (write) bunches of
> data, even when just doing searches (reads) on indexes on other tables.

Is there a way to turn off this logging?
How about setting a virtual disk big enough to hold 5 to 10 minutes worth
of logs and then moving/deleting the log before that time (if it is
possible to delete/move the log).