Skip site navigation (1) Skip section navigation (2)

Re: Slow Performance in PostgreSQL

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 (view raw or flat)
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

In response to

pgsql-hackers by date

Next:From: Robert VojtaDate: 2001-07-27 10:13:37
Subject: indexes and big tables
Previous:From: Hiroshi InoueDate: 2001-07-27 09:13:54
Subject: Re: LIBPQ on Windows and large Queries

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group