Michael Rudolph wrote: > > To let all of you know the status of my problem: I got on one large > step when realized, that I forgot a "vacuum analyze" after copying the > data. When I did this, my performance gain was huge - but didn't reach > the performance of centura at all. It is still a bit slower. Maybe I > can optimize the ODBC-Connection in any way, because there is still > one unsolved question when watching the postgres-logfile: Every query > is done two times (I don't know why) and both queries of one type need > the same execution time. So I think, if I manage to reduce that load, > I can get an acceptable performance. >
Could you turn on mylog debug though it generates a lot of debug output ? To turn on it, please add the Windows registry entry HKEY_LOCAL_MACHINE\SOFTWARE\ODBC\ODBCINST.INI\PostgreSQL\Debug as 1. To turn off mylog debug, please set the entry to 0 or remove it. regards, Hiroshi Inoue ---------------------------(end of broadcast)--------------------------- TIP 3: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly
