pg.ddx.io  pgsql-performance@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Hannu Krosing <hannu@tm.ee>
To: Rhaoni Chiu Pereira <rhaoni@sistemica.info>
Cc: PostgreSQL ADMIN <pgsql-admin@postgresql.org>
Cc: PostgreSQL Performance <pgsql-performance@postgresql.org>
Subject: Re: [PERFORM] Low Insert/Update Performance
Date: Mon, 20 Oct 2003 20:50:22 +0300
Message-ID: <1066672221.5434.5.camel@fuji.krosing.net> (raw)
In-Reply-To: <1066659206.3f93ed86b9907@sistemica.info>
References: <1066659206.3f93ed86b9907@sistemica.info>

Rhaoni Chiu Pereira kirjutas E, 20.10.2003 kell 17:13:
> Hi List,
> 
>    I got a P4 1.7Ghz , 512MB RAM , HD 7200 RPM, on RED HAT 9 running PostgreSQL 
> 7.3.2-3 Database.
>    I have a Delphi aplication that updates the Oracle database using .dbf 
> file's information  ( converting the data from the old clipper aplication ) and 
> it takes about 3min and 45 seconds to update Jan/2003 .

Have you tried contrib/dbase to do the same ?

How fast does this run

>     My problem is that I must substitute this Oracle for  a PostgreSQL database 
> and this same Delphi aplication takes 45 min to update Jan/2003.
>     All delphi routines are converted and optmized to work with PgSQL.

Could it be that you try to run each insert in a separate transaction in
PgSQL version ?

Another possibility is that there is a primary key index created on
empty tables which is not used in subsequent UNIQUE tests when tables
start to fill and using index would be useful. An ANALYZE in a parallel
backend could help here. Same can be true for foreign keys and unique
constraints.

---------------
Hannu




view thread (8+ messages)  latest in thread

Message-ID: <1066672221.5434.5.camel@fuji.krosing.net>
Permalink:  ../1066672221.5434.5.camel@fuji.krosing.net/
Also on:    postgresql.org/message-id/1066672221.5434.5.camel@fuji.krosing.net

 · 

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients from your mail client; the link fills in
  the headers below: reply via email
  Some clients, webmail especially, drop In-Reply-To and References from
  a link, and the reply then starts a new thread: use the mbox below.

  To: pgsql-performance@postgresql.org
  Cc: hannu@tm.ee, rhaoni@sistemica.info, pgsql-admin@postgresql.org
  Subject: Re: [PERFORM] Low Insert/Update Performance
  In-Reply-To: <1066672221.5434.5.camel@fuji.krosing.net>
  References: <1066659206.3f93ed86b9907@sistemica.info> <1066672221.5434.5.camel@fuji.krosing.net>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox