Performance - fsync-off - Mailing list pgsql-novice

From Thomas Weholt
Subject Performance - fsync-off
Date
Msg-id 01EEE08EC217D311B67400105AC8AB0E088884@ns1.cintra.no
Whole thread Raw
Responses Re: Performance - fsync-off  (Alfred Perlstein <bright@wintelcom.net>)
List pgsql-novice
Hi,

I just got my Postgres-database up and running, putting in data using a
Python-script, using the latest version of the PyGres-module by
Darcy@druid.net. It works great! But insertion seems slow, even though I
just got a few indexes. How can I turn off the fsync-variable? There must be
a way to turn it off when starting the database, like postmaster -x where x
is some command-line option or a setting in a config-file etc. I haven`t
found anything in my search so far. What will this do in terms of
performance ( 1-5 times ??? ) and is it considered safe? ( I`m running Linux
)

How does PostgreSQL compare in terms of speed compared to other databases,
commercial products included??

Thomas

pgsql-novice by date:

Previous
From: davidb@vectormath.com
Date:
Subject: Fw: change column after creation?
Next
From: Thomas Weholt
Date:
Subject: Bulk-copy?