Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-novice by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group