Postgres Pro
Downloads
Home   >   mailing lists

Re: Partition pruning / agg push down for star schema in pg v11 - Mailing list pgsql-general

From legrand legrand
Subject Re: Partition pruning / agg push down for star schema in pg v11
Date
Msg-id 1512322791450-0.post@n3.nabble.com
Whole thread Raw
In response to Partition pruning / agg push down for star schema in pg v11  (legrand legrand <legrand_legrand@hotmail.com>)
Responses Re: Partition pruning / agg push down for star schema in pg v11
List pgsql-general
Tree view 
Adding partitioning on the dim tables, with the same keys as those used in
the fact table,
gives any star schema a good chance to use Partition Wise Join / Aggregate
plans.

Will test it soon
Regards
PAscal



--
Sent from: http://www.postgresql-archive.org/PostgreSQL-general-f1843780.html

pgsql-general by date:

Previous
From: Zach Walton
Date:
Subject: Re: Warm standby can't start because logs stream too quickly from the master
Next
From: Gmail
Date:
Subject: building a server