I am having a problem with queries.
First, my setup. I have PostgreSQL 6.3.2 running on a dual PPro200 box with
SuSE 5.2, Linux-SMP 2.0.35. The box has 64 meg RAM and 130 meg swap. I have
a database that has three tables and several indexes. The two biggest tables
have 331,200 rows of information. One of those has 5 columns, the other has
I connect to the database via ODBC on a Windows NT 4 SP3 workstation, with
Access 97. I am using the Insight Distribution Systems PostgreSQL ODBC
driver version 6.30.0249.
I can add data to the tables without any problems, however my queries seem
to fail miserably, with ODBC call failed.
Here's an example. I have the following columns
YYYYMMDD HHMM SYSTEM USER USAGE
where YYYYMMDD,HHMM,USAGE is int4, SYSTEM is char(16), and USER is char(32).
YYYYMMDD, HHMM, SYSTEM, USER are all indexed individually, plus they are all
used to create a unique key.
The following query is used:
(((usage.yyyymmdd) Between 19980701 And 19980731)
AND ((usage.link)='swbt08')) OR (((usage.link)='swbtja'))
usage.yyyymmdd, usage.hhmm, usage.stp, usage.link;
When run from psql the answer is returned fairly quickly. When run from
Access via ODBC, the system memory starts increasing until it gets to 60/70%
on the single postgres process, and CPU is usually below 10% (normal queries
shoot CPU up to 50 to 99 % and memory stays around 3 to 8 percent). Then the
ODBC call fails and Access doesn't get any information.
Also, using Access, when I have the database open, and the ables linked into
my Access database, if I open the actual table itself, the same thing
happens. The server sucks down memory to PostgreSQL until the ODBC call
Anyone have any ideas on what may be causing this? Or ways to fix this?
Gregory S. Youngblood
pgsql-interfaces by date
|Next:||From: David Hartwig||Date: 1998-09-15 21:08:55|
|Subject: Re: [NOVICE] Problems with queries on small/medium sized tables|
|Previous:||From: Mikael Hammarin||Date: 1998-09-15 10:48:49|