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.
pgsql-novice by date
|Next:||From: Bruno Wolff III||Date: 2004-03-08 04:42:12|
|Subject: Re: postgresql already installed? version?|
|Previous:||From: Tom Lane||Date: 2004-03-07 03:48:12|
|Subject: Re: installing pgsql |