| 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: | Whole Thread | Raw Message | 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
| 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? |