Re: -F option
Alain TESIO <tesio@easynet.fr>
From: "Alain TESIO" <tesio@easynet.fr>
To: "^chewie" <chewie@wookimus.net>
Cc: "PGSQL Bugs" <pgsql-bugs@postgresql.org>, <pgsql-general@hub.org>
Date: 2000-01-10T05:35:05Z
Lists: pgsql-bugs
> 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