From: | Hans-Juergen Schoenig <hs(at)cybertec(dot)at> |
---|---|
To: | pgsql-general(at)postgresql(dot)org |
Subject: | Re: Query Speed!!! |
Date: | 2002-07-08 17:32:24 |
Message-ID: | 3D29CCA8.3090402@cybertec.at |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Thirumoorthy Bhuvneswari wrote:
> hi,
> I am using Postgresql-7.1.3 with RedHat Linux-7.1 and
> JDBC. I am having an indexed table with nearly 3,000
> records for a month. My machine is with 256 MB RAM,
> 600 MHz. I am having a report from the abovesaid
> table, which displays 1 month's records at a stretch
> using Swing components. If I run the query from the
> hard-disk
> it takes about 5 seconds to display all the 3,000
> records. If I connect 3 nodes to it and run the query
> from a node, it takes about 1.5 minutes. I don't know
> where I am wrong. Please do reply. thanks.
>
> bhuvana.
>
Did you define indexes? did you vacuum the database?
if that doesn't work try to give the optimizer some hints (see manual).
HAns
From | Date | Subject | |
---|---|---|---|
Next Message | Darren Ferguson | 2002-07-08 17:36:16 | Re: PostgreSQL doesn't use indexes even is enable_seqscan |
Previous Message | Alvaro Herrera | 2002-07-08 17:28:05 | Re: Null in the where-clause |