Performance - fsync-off

From: Thomas Weholt <Thomas(at)cintra(dot)no>
To: pgsql-novice(at)postgresql(dot)org
Subject: Performance - fsync-off
Date: 2000-06-02 06:07:14
Message-ID: 01EEE08EC217D311B67400105AC8AB0E088884@ns1.cintra.no
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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(at)druid(dot)net(dot) 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

Responses

Browse pgsql-novice by date

  From Date Subject
Next Message Thomas Weholt 2000-06-02 06:08:33 Bulk-copy?
Previous Message davidb 2000-05-31 15:41:17 Fw: change column after creation?