pg.ddx.io pgsql-performance@postgresql.org mailing list archive
help / color / mirror / Atom feedNeed Help selecting Large Data From PQSQL
2+ messages / 2 participants
[nested] [flat]
* Need Help selecting Large Data From PQSQL
@ 2008-02-20 11:02 shilpa.raghavendra@wipro.com
2008-02-20 11:38 ` Re: Need Help selecting Large Data From PQSQL Richard Huxton <dev@archonet.com>
0 siblings, 1 reply; 2+ messages in thread
From: shilpa.raghavendra@wipro.com @ 2008-02-20 11:02 UTC (permalink / raw)
To: pgsql-performance
Hi,
I am using Postgresql 8.1 for handling large data.
I am having One Parent Table and Child Table I.e.inherits from
parent table.
The constraint for partitioning table is date range.
I have to generate monthly report, report generation query
contains union with other table also.
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.
Regards,
Shilpa
The information contained in this electronic message and any attachments to this message are intended for the exclusive use of the addressee(s) and may contain proprietary, confidential or privileged information. If you are not the intended recipient, you should not disseminate, distribute or copy this e-mail. Please notify the sender immediately and destroy all copies of this message and any attachments.
WARNING: Computer viruses can be transmitted via email. The recipient should check this email and any attachments for the presence of viruses. The company accepts no liability for any damage caused by any virus transmitted by this email.
www.wipro.com
^ permalink raw reply [nested|flat] 2+ messages in thread
* Re: Need Help selecting Large Data From PQSQL
2008-02-20 11:02 Need Help selecting Large Data From PQSQL shilpa.raghavendra@wipro.com
@ 2008-02-20 11:38 ` Richard Huxton <dev@archonet.com>
0 siblings, 0 replies; 2+ messages in thread
From: Richard Huxton @ 2008-02-20 11:38 UTC (permalink / raw)
To: shilpa.raghavendra@wipro.com; +Cc: pgsql-performance
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
^ permalink raw reply [nested|flat] 2+ messages in thread
end of thread, other threads:[~2008-02-20 11:38 UTC | newest]
Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2008-02-20 11:02 Need Help selecting Large Data From PQSQL shilpa.raghavendra@wipro.com
2008-02-20 11:38 ` Richard Huxton <dev@archonet.com>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox