Rhaoni,
Total runtime: 3.56 msec
(4 rows)
Well, from that figure it's not the query that's holding you up.
You said that the system bogs down when you're doing a whole series of these
updates, or just one? If the former, then I'm afraid that it's your disk
that's to blame ... large
Rhaoni,
First of all , thank's for your atention and fast answer. The system
really bogs down when I'm doing a whole series of these updates.
That would be consistent with a single-disk problem.
Take a
look at my postgresql.conf I'm afraid of putting some parameters wrong (
too high or
Hi List;
Here follow the update query, explain analyze of it , my postgresql.conf and
my db configuration. This is my first PostgreSQL DB so I would like to know if
its performance is normal !
If there is some postgresql.conf's parameter that you think will optmize the
database just tell me
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
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
On Mon, 20 Oct 2003 12:13:26 -0200
Rhaoni Chiu Pereira [EMAIL PROTECTED] wrote:
Hi List,
I got a P4 1.7Ghz , 512MB RAM , HD 7200 RPM, on RED HAT 9 running
PostgreSQL
7.3.2-3 Database.
[clip]
Please send schema queries or we will not be able to help you. Also,
if you could provide
Rhaoni,
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.
Obviously not.
How about posting the update queries?
--
Josh