Re: Partition pruning for Star Schema

From: Andres Freund <andres(at)anarazel(dot)de>
To: legrand legrand <legrand_legrand(at)hotmail(dot)com>
Cc: pgsql-hackers(at)postgresql(dot)org
Subject: Re: Partition pruning for Star Schema
Date: 2017-12-02 21:04:18
Message-ID: 20171202210418.fimj5w4m5e72nulm@alap3.anarazel.de
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

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 days ago:
http://archives.postgresql.org/message-id/1511986639005-0.post%40n3.nabble.com

Please don't just duplicate threads just because you've not received an
answer a few days ago. If you'd done additional research / provided more
context *and* linked to the last time you sent something it'd be
different.

Greetings,

Andres Freund

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Jeff Janes 2017-12-02 21:17:47 Re: Bitmap scan is undercosted?
Previous Message Andres Freund 2017-12-02 21:01:21 Re: [HACKERS] Parallel Hash take II