Re: Increasing system speed by using -F option

Joseph Shraibman wrote:
>
> Dave Smith wrote:
> >
> > Mitch Vincent wrote:
> > >
> > > -F makes PG *not* call fsync(), therefore the risk of corruption and the
> > > speed increase. (The good, the bad and if it crashes , the ugly)
> > >
> > > It's possible to speed up queries by increasing your -B and -S parameters to
> > > use some more memory.. There is also a lot to be said for _proper_ use of
> > > indexes ( Use EXPLAIN!)..
> > >
> > > If you could give us a little more information about the tables you're
> > > searching and the queries you're using, maybe we could provide some more
> > > specific help..
> > >
> > > Good luck!
> > >
> > > ----- Original Message -----
> > > From: "Mark Alliban" <MarkA(at)idnltd(dot)com>
> > > To: <pgsql-general(at)postgresql(dot)org>
> > > Sent: Friday, September 01, 2000 5:53 AM
> > > Subject: [GENERAL] Increasing system speed by using -F option
> > >
> > > Hi,
> > >
> > > I notice a dramatic speed increase (3 to 4 times faster) by using the -F
> > > option when starting the database, at a cost of database corruption if the
> > > OS crashes. This database is mission-critical so data reliability is
> > > extremely important, meaning I cannot use the -F option. Are there any ways
> > > of achieving similar speed increases without using the -F option? I am using
> > > RedHat 6.1, 7.0.2, -B 2048 -N 1024 -i.
> > >
> > > Thanks,
> > > Mark.
> >
> > Well from my experience the reason systems crash are hardware failuers
> > or power failuers.
>
> You obviously aren't running a M$ operating system.

Microsoft doesn't run their own mission critcal applications on their
OS's

--
Dave Smith
Candata Systems Ltd.
(416) 493-9020
dave(at)candata(dot)com