Обсуждение: Postgresql Performance

Hello:

I am using Postgresql 8.0.3 with the ODBC driver
(8.01.100). My application will update a batch of
records (~3000 records) and i really need the update
to be completed in very short time. In order to
increase efficience, I have set "fsync=false".

When i simply use psql command line (i,e. "psql -q
DATABASE < update.sql") it takes around 2 sec to
finish the 3000 records update. However, if I use my
ODBC application to update the records, it nearly
takes about 6-8 sec to finish!!!!

Does anyone have any idea on how to improve the
performance of my update record application through
ODBC driver?? (Also I have set the AUTOCOMMIT as off
in my ODBC application already!)

thanks a lot!



__________________________________
Yahoo! FareChase: Search multiple travel sites in one click.
http://farechase.yahoo.com

> I am using Postgresql 8.0.3 with the ODBC driver
> (8.01.100). My application will update a batch of
> records (~3000 records) and i really need the update
> to be completed in very short time. In order to
> increase efficience, I have set "fsync=false".

Hello

  What's your ODBC settings? Could you send me your application
(or update part of it)? Or could you send mylog output at least?

Regards

Luf