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

SQL Query - Performance Problem

From: "Dean Sheppard" <dean(dot)sheppard(at)rogers(dot)com>
To: <pgsql-novice(at)postgresql(dot)org>
Subject: SQL Query - Performance Problem
Date: 2004-03-07 23:54:12
Message-ID: 024801c4049f$7d76def0$6400a8c0@server (view raw or flat)
Thread:
Lists: pgsql-novice
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.

Responses

pgsql-novice by date

Next:From: Bruno Wolff IIIDate: 2004-03-08 04:42:12
Subject: Re: postgresql already installed? version?
Previous:From: Tom LaneDate: 2004-03-07 03:48:12
Subject: Re: installing pgsql

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