Re: slow performance postgres 7.0.3 and odbc - Mailing list pgsql-odbc

From Johann Zuschlag
Subject Re: slow performance postgres 7.0.3 and odbc
Date
Msg-id E15Axel-0003AG-00@mrelay00.kundenserver.de
Whole thread Raw
In response to slow performance postgres 7.0.3 and odbc  (juerg.rietmann@pup.ch)
List pgsql-odbc
Hi,

Unlike access, PostgreSQL (and any other SQL-DB) flushes all writes directly to disk.
That makes SQL databases quite safe against power failures.
To improve performance database servers need fast hard drives.

If you are just creating a new table switching off fscnc() might speed up things considerably.
For normal (save) operation you should switch it on again.
When I create my database with several tables (with 20.000+ rows), I switch it off.

With fsync() off (backend option) you might get results less than 30 sec.

So it's not the driver.

Hope that helps,

regards

Johann

On Fri, 15 Jun 2001 15:21:16 +0200, juerg.rietmann@pup.ch wrote:

>Hello there
>
>I just made a test creating 2495 records from a C++ prog. into a postgres
>table. This took me around 4 minutes. Doing the same against an access db
>takes 30 seconds ! I use Version 6.50.00.00 from 04.02.2000.
>
>What can I do to speed up the ODBC performance?
>
>Thanks ... jr
>
>============================================
>PFISTER + PARTNER, SYSTEM - ENGINEERING AG
>Juerg Rietmann
>Grundstrasse 22a
>6343 Rotkreuz
>Switzerland
>
>phone: +4141 790 4040
>fax: +4141 790 2545
>mobile: +4179 211 0315
>============================================
>
>
>---------------------------(end of broadcast)---------------------------
>TIP 3: if posting/reading through Usenet, please send an appropriate
>subscribe-nomail command to majordomo@postgresql.org so that your
>message can get through to the mailing list cleanly



Johann Zuschlag
zuschlag2@online.de



pgsql-odbc by date:

Previous
From: Bob Woodside
Date:
Subject: MSACCESS & Apostrophe in Column Name
Next
From: "Hiroshi Inoue"
Date:
Subject: Re: MSACCESS & Apostrophe in Column Name