Re: multiple group by on same table - Mailing list pgsql-general

From Leonardo Francalanci
Subject Re: multiple group by on same table
Date
Msg-id 74703.25594.qm@web29011.mail.ird.yahoo.com
Whole thread Raw
In response to Re: multiple group by on same table  (Gabriele Bartolini <Gabriele.Bartolini@2ndQuadrant.it>)
List pgsql-general
>  I am not sure if this could apply to your case, but maybe  - unless you have
>done it before -
>
> you could look at windowing functions

Ciao Gabriele,

the problem is that the only thing the N queries have in
common is the base table; everything else is different,
because the different "group by"s aren't related one to
another. My understanding is that windowing functions
can't help in that case, but I'll look at them


Thank you

Leonardo

pgsql-general by date:

Previous
From: Tomas Vondra
Date:
Subject: Re: Cannot reproduce why a query is slow
Next
From: Leonardo Francalanci
Date:
Subject: FILLFACTOR and increasing index