Re: seperate swap drive, was Re: [ADMIN] Speed problem

Поиск
Список
Период
Сортировка
От Bruce Momjian
Тема Re: seperate swap drive, was Re: [ADMIN] Speed problem
Дата
Msg-id 199811060435.XAA01132@candle.pha.pa.us
обсуждение исходный текст
Ответ на Re: seperate swap drive, was Re: [ADMIN] Speed problem  (The Hermit Hacker <scrappy@hub.org>)
Список pgsql-admin
> On Thu, 5 Nov 1998, G. Anthony Reina wrote:
>
> > Marc,
> >
> >
> >     I'm running PostgreSQL v. 6.3.2. No I don't want to disable
> > fsync just in case someone stops a process midstream (which has
> > happened before-- I figure it could screw up the db). So maybe it is
> > those "memory leaks" that you've suggested. I'll try closing and
> > re-connecting to see if there are any differences. However, I would be
> > interested in downloading v. 6.4. Do you know where to get it? (I
> > think it is a beta version but I couldn't find it on the www site).
>
>     First off, fsync() only helps if the system itself
> crashes...someone else might want to correct me, but if a process stops
> midstream, it should not affect the db in any way, shape or form...
>

Yes, only OS crashes.  Any other crash, fsync has not affect, because
the buffers get written to the disk.  Vadim should have that fixed by
6.5, so we wouln't need fsync anymore.

--
  Bruce Momjian                        |  http://www.op.net/~candle
  maillist@candle.pha.pa.us            |  (610) 853-3000
  +  If your life is a hard drive,     |  830 Blythe Avenue
  +  Christ can be your backup.        |  Drexel Hill, Pennsylvania 19026

В списке pgsql-admin по дате отправления:

Предыдущее
От: The Hermit Hacker
Дата:
Сообщение: Re: [ADMIN] unable to compile postgresql-6.3.2 on alpha-dec-osf4.0
Следующее
От: "William Barber"
Дата:
Сообщение: unsubscribe pgsql-SQL