Re: seperate swap drive, was Re: [ADMIN] Speed problem - Mailing list pgsql-admin

From Bruce Momjian
Subject Re: seperate swap drive, was Re: [ADMIN] Speed problem
Date
Msg-id 199811060435.XAA01132@candle.pha.pa.us
Whole thread Raw
In response to Re: seperate swap drive, was Re: [ADMIN] Speed problem  (The Hermit Hacker <scrappy@hub.org>)
List 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 by date:

Previous
From: The Hermit Hacker
Date:
Subject: Re: [ADMIN] unable to compile postgresql-6.3.2 on alpha-dec-osf4.0
Next
From: "William Barber"
Date:
Subject: unsubscribe pgsql-SQL