Horton
Menu

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

Tatsuo Ishii <t-ishii@sra.co.jp>

View thread
From: Tatsuo Ishii <t-ishii@sra.co.jp>
To: fran@reyes.somos.net
Cc: aa2@bigpond.net.au, mykarz@miyabara.com, pgsql-novice@postgresql.org, pgsql-general@postgresql.org
Date: 2001-02-07T01:12:58Z
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.

This is not true.

1) We do not write "bunches of data" into pg_log. We write just 2 bits
   per transaction.

2) Simple read-only SELECT does not write pg_log at all.
--
Tatsuo Ishii