From: | Hiroshi Inoue <Inoue(at)tpf(dot)co(dot)jp> |
---|---|
To: | Michael Rudolph <MuK(dot)Rudolph(at)t-online(dot)de> |
Cc: | pgsql-hackers <pgsql-hackers(at)postgresql(dot)org> |
Subject: | Re: Slow Performance in PostgreSQL |
Date: | 2001-07-27 10:05:59 |
Message-ID: | 3B613D06.CA3A0E6C@tpf.co.jp |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers |
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
From | Date | Subject | |
---|---|---|---|
Next Message | Robert Vojta | 2001-07-27 10:13:37 | indexes and big tables |
Previous Message | Hiroshi Inoue | 2001-07-27 09:13:54 | Re: LIBPQ on Windows and large Queries |