Re: -F option
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
Import Notes
Reference msg id not found: Pine.LNX.4.10.10001071125010.15164-100000@geeks.linux.com
"Alain TESIO" <tesio@easynet.fr> writes:
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.
Really!? Wow, I can hardly guess what's causing that, but it sure
deserves looking into. Send me your dump, or give me an FTP or web
pointer if that's easier.
regards, tom lane