Postgres Pro
Downloads
Home   >   mailing lists

SQL Query - Performance Problem - Mailing list pgsql-novice

From Dean Sheppard
Subject SQL Query - Performance Problem
Date
Msg-id 024801c4049f$7d76def0$6400a8c0@server
Whole thread Raw
Responses Re: SQL Query - Performance Problem
Re: SQL Query - Performance Problem
List pgsql-novice
Tree view
Hi All,
 
I have a postgres SQL Table which contains 30 Million Records. It is a simple flat table with 4 columns. Each column has an index and I select from this table using a single column at any time.
 
Here's the problem. A simple select statement takes upto 30 seconds to respond, if I add in connection pooling and 15 - 20 concurrent requests the responses are now 15-20 minutes!! I have no idea what the tuning options may be, but I need to get these queries running in 30 seconds or so.
 
Any ideas?
 
Regards,
Dean.
 

pgsql-novice by date:

Previous
From: sashan
Date:
Subject: building using vc++6
Next
From: "Allan Poulsen"
Date:
Subject: to_hex question