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
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
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,
> The delphi program does just one commit for all queries .
> I was wandering if ther is some configuration parameters to be changed to
> improve the performance ?
To help you, we'll need to to trap a query and run an EXPLAIN ANALYZE on it.
--
Josh Berkus
Aglio Database Solutions
San Fr
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 t
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
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
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
