Re: Need Help selecting Large Data From PQSQL

From: Richard Huxton <dev(at)archonet(dot)com>
To: shilpa(dot)raghavendra(at)wipro(dot)com
Cc: pgsql-performance(at)postgresql(dot)org
Subject: Re: Need Help selecting Large Data From PQSQL
Date: 2008-02-20 11:38:09
Message-ID: 47BC1121.20800@archonet.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

shilpa(dot)raghavendra(at)wipro(dot)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

In response to

Browse pgsql-performance by date

  From Date Subject
Next Message Douglas J Hunley 2008-02-20 13:26:38 Re: 7 hrs for a pg_restore?
Previous Message ohp 2008-02-20 11:29:59 Re: 7 hrs for a pg_restore?