Skip site navigation (1) Skip section navigation (2)

Re: -F option

From: "Alain TESIO" <tesio(at)easynet(dot)fr>
To: "^chewie" <chewie(at)wookimus(dot)net>
Cc: "PGSQL Bugs" <pgsql-bugs(at)postgresql(dot)org>, <pgsql-general(at)hub(dot)org>
Subject: Re: -F option
Date: 2000-01-10 05:35:05
Message-ID: 00fc01bf5b2c$75d75c40$d15f72c3@atesio (view raw or flat)
Thread:
Lists: pgsql-bugspgsql-general
> Alain, have you run postgreSQL with the -F option and compared them then?
> I'd venture to say that if you did so, you'ld find PostgreSQL a bit more
> desireable on the speed factor.  Just remember, when you do so, you loose
> some recovery possibilities -- as you're relying on the OS to sync data
> from memory to disc.

Hello,

I've often experienced crashes with the -F option, the script which fills my
database can never run completely. If any developper is interested, I have
a dump file (about 2 Mo gzipped, directly produced from pg_dump) which
is crashing on a create index with the option -F set, and is working fine
without it.
My configuration is : Linux RedHat 6.0, Kernel 2.2-15, PostgreSQL 6.5.3,
64 Mo RAM.

Alain



In response to

Responses

pgsql-bugs by date

Next:From: Tom LaneDate: 2000-01-10 06:17:00
Subject: Re: [BUGS] Re: -F option
Previous:From: HEALTH&MONEY$!!!Date: 2000-01-08 15:17:03
Subject: MAKE MONEY AT HOME

pgsql-general by date

Next:From: Tom LaneDate: 2000-01-10 06:17:00
Subject: Re: [BUGS] Re: -F option
Previous:From: Tom LaneDate: 2000-01-10 04:35:40
Subject: Re: [ANNOUNCE] Searching http://www.postgresql.org ...

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group