From: sathiya psql <sathiya.psql@gmail.com>
To: pgsql-sql@postgresql.org
Subject: report generation from table.
Date: Wed, 21 Oct 2009 17:22:41 +0530
Message-ID: <f966c2ee0910210452x4a60093ds772b62063e72fe8c@mail.gmail.com> (raw)
Hi All,
I have been searching for, Preparing report from a huge table.
Queries am executing now are,
SELECT count(*) from HUGE_TBL where cond1, cond2;
SELECT count(*) from HUGE_TBL where cond1, cond3;
--- like this i have different conditions(10-15 different things ) and
different amount of conditions ( 2 - 5 condition ).
As that is a very huge table, it took time to execute each query ( 2 min ).
And finally it takes 15 times that ( 30 min ). Is there anyway to do the
above report efficiently ?
Such executing the query only once, and getting all different outputs
required ? or fetching result from some cache ?
Or i dont have any other way ?!
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: sathiya.psql@gmail.com
Subject: Re: report generation from table.
In-Reply-To: <f966c2ee0910210452x4a60093ds772b62063e72fe8c@mail.gmail.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
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