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

Поиск
Список
Период
Сортировка
От Tatsuo Ishii
Тема Re: Re: [NOVICE] Re: Sizing of LARGE databases.
Дата
Msg-id 20010207101258V.t-ishii@sra.co.jp
обсуждение исходный текст
Ответ на Re: [NOVICE] Re: Sizing of LARGE databases.  (Francisco Reyes <fran@reyes.somos.net>)
Список 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 по дате отправления:

Предыдущее
От: Brice Ruth
Дата:
Сообщение: Re: [SQL] Re: SQL Join - MySQL/PostgreSQL difference?
Следующее
От: Brice Ruth
Дата:
Сообщение: Re: [SQL] Re: SQL Join - MySQL/PostgreSQL difference?