Re: Re: [NOVICE] Re: Sizing of LARGE databases. - Mailing list pgsql-general

From Tatsuo Ishii
Subject Re: Re: [NOVICE] Re: Sizing of LARGE databases.
Date
Msg-id 20010207101258V.t-ishii@sra.co.jp
Whole thread Raw
In response to Re: [NOVICE] Re: Sizing of LARGE databases.  (Francisco Reyes <fran@reyes.somos.net>)
List 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

pgsql-general by date:

Previous
From: Brice Ruth
Date:
Subject: Re: [SQL] Re: SQL Join - MySQL/PostgreSQL difference?
Next
From: Brice Ruth
Date:
Subject: Re: [SQL] Re: SQL Join - MySQL/PostgreSQL difference?