Date vs Timestamp without timezone Partition Key

From: Cedric Leong <cedricleong(at)gmail(dot)com>
To: pgsql-performance(at)lists(dot)postgresql(dot)org
Subject: Date vs Timestamp without timezone Partition Key
Date: 2020-05-25 03:50:05
Message-ID: CAD6i=X0h3RJFes4E662-HbQRGCV+HcAPjAJbK8vLSVFM20RK6w@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

Just in case someone is interested enough to answer this. Does anyone know
if the performance for a date column vs a timestamp column as a partition
key is large? What i mean with large is that say you have 6 partitions with
10GB each. Would it be a 10 second+ difference? An explanation of how this
internally works would be appreciated.

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Tom Lane 2020-05-25 04:48:23 Re: Date vs Timestamp without timezone Partition Key
Previous Message Rory Campbell-Lange 2020-05-22 14:48:20 Strategy for materialisation and centralisation of data