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

Re: performance hit with large tables...jdbc?

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: mikeg(at)robot6(dot)com
Cc: pgsql-novice(at)postgresql(dot)org
Subject: Re: performance hit with large tables...jdbc?
Date: 2000-10-17 03:25:24
Message-ID: 28960.971753124@sss.pgh.pa.us (view raw or flat)
Thread:
Lists: pgsql-novice
<mikeg(at)robot6(dot)com> writes:
> but now that we're going live with more data, we're suddenly
> noticing that a select on the primary key field is taking
> about 90 seconds.  However, if I go into the command line
> on the db server and do the exact same SQL select manually,
> it takes < 1 sec.  This makes me think it's some problem
> with my JDBC driver, or some hardware between the web-server
> and the db-server.

Hm.  Run the postmaster with -d2 so that queries are logged into
the postmaster log file, and see what query the client is really
sending.  I'll bet it's not what you think it is.

Another possibility is that there's some horrid inefficiency
in transmitting the query results, but unless this query is
returning a whole lot of data, that doesn't seem like it'd
explain 90 seconds.

			regards, tom lane

In response to

pgsql-novice by date

Next:From: Stoffel van AswegenDate: 2000-10-17 05:44:40
Subject: Comparison of Postgres vs MySQL
Previous:From: mikegDate: 2000-10-17 03:01:28
Subject: performance hit with large tables...jdbc?

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