Postgres Pro
Downloads
Home   >   mailing lists

Re: Need Help selecting Large Data From PQSQL - Mailing list pgsql-performance

From Richard Huxton
Subject Re: Need Help selecting Large Data From PQSQL
Date
Msg-id 47BC1121.20800@archonet.com
Whole thread Raw
In response to Need Help selecting Large Data From PQSQL  (<shilpa.raghavendra@wipro.com>)
List pgsql-performance
Tree view 
shilpa.raghavendra@wipro.com wrote:
>        The report contains more than 70,000 records but it takes more
> than half an hour and some time no result.
>
>         Please help me to generating the report fast.

You'll need to provide some more information before anyone can help.
Something along the lines of:
- table definitions
- query definition
- EXPLAIN ANALYSE output (or just plain EXPLAIN if that's not practical)

--
   Richard Huxton
   Archonet Ltd

pgsql-performance by date:

Previous
From: ohp@pyrenet.fr
Date:
Subject: Re: 7 hrs for a pg_restore?
Next
From: Douglas J Hunley
Date:
Subject: Re: 7 hrs for a pg_restore?