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
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs pgsql-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

Browse pgsql-bugs by date

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

Browse pgsql-general by date

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