From: | Leonardo Francalanci <m_lists(at)yahoo(dot)it> |
---|---|
To: | pgsql-general <pgsql-general(at)postgresql(dot)org> |
Subject: | multiple group by on same table |
Date: | 2011-05-04 10:51:08 |
Message-ID: | 100741.56348.qm@web29004.mail.ird.yahoo.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Hi,
I'm going to need to GROUP BY the same table
multiple times. That is, something like:
select (some aggregate functions here) from
tableA group by f1, f2
select (some other aggregate functions here) from
tableA group by f3, f4
etc
The table is pretty large; can someone suggest the
best way of doing it? Is running N queries at the same
time (that is, using N connections with N threads in
the client code) the only way to speed up things (so
that the "concurrent scan" thing can help)? Or it's
more likely that it won't help that much, given that
we have a fairly good storage? Just trying to get some
ideas before starting testing....
(table will be 5M rows, where some of the group by
select could return 3-400K groups)
Leonardo
From | Date | Subject | |
---|---|---|---|
Next Message | Sim Zacks | 2011-05-04 10:59:21 | Re: multiple group by on same table |
Previous Message | Willy-Bas Loos | 2011-05-04 10:31:29 | Re: [PERFORMANCE] expanding to SAN: which portion best to move |