Thank You !
I will monitor this 'runtime partition pruning' patch.
This will be better than using Partitioned DIM tables "Partion wise joined"
with a multi level partitioned FACT table ;o)
Regards
PAscal
--
Sent from: http://www.postgresql-archive.org/PostgreSQL-hackers-f1928748.html
On 04/12/17 17:20, Mark Kirkwood wrote:
On 04/12/17 16:08, Ashutosh Bapat wrote:
On Sun, Dec 3, 2017 at 5:56 AM, legrand legrand
wrote:
Hello,
I have a typical star schema, having dimension tables "product",
"calendar"
and "country" and a fact table "sales".
This fact table is partitionne
On 04/12/17 16:08, Ashutosh Bapat wrote:
On Sun, Dec 3, 2017 at 5:56 AM, legrand legrand
wrote:
Hello,
I have a typical star schema, having dimension tables "product", "calendar"
and "country" and a fact table "sales".
This fact table is partitionned by time (range by month) and country (list
On Sun, Dec 3, 2017 at 5:56 AM, legrand legrand
wrote:
> Hello,
>
> I have a typical star schema, having dimension tables "product", "calendar"
> and "country" and a fact table "sales".
> This fact table is partitionned by time (range by month) and country (list).
>
> Will query like:
>
> select p
Sorry, I apologize.
I though (most) Hackers were not reading General list.
Regards
PAscal
--
Sent from: http://www.postgresql-archive.org/PostgreSQL-hackers-f1928748.html
Hi,
On 2017-12-02 13:56:51 -0700, legrand legrand wrote:
> I have a typical star schema, having dimension tables "product", "calendar"
> and "country" and a fact table "sales".
> This fact table is partitionned by time (range by month) and country
> (list).
You've posted nearly the same a few day
Hello,
I have a typical star schema, having dimension tables "product", "calendar"
and "country" and a fact table "sales".
This fact table is partitionned by time (range by month) and country (list).
Will query like:
select product.name, calendar.month, sum(sales.net_price)
from sales
inner joi
