Date vs Timestamp without timezone Partition Key - Mailing list pgsql-performance

From Cedric Leong
Subject Date vs Timestamp without timezone Partition Key
Date
Msg-id CAD6i=X0h3RJFes4E662-HbQRGCV+HcAPjAJbK8vLSVFM20RK6w@mail.gmail.com
Whole thread Raw
Responses Re: Date vs Timestamp without timezone Partition Key  (Tom Lane <tgl@sss.pgh.pa.us>)
List 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.

pgsql-performance by date:

Previous
From: Rory Campbell-Lange
Date:
Subject: Strategy for materialisation and centralisation of data
Next
From: Tom Lane
Date:
Subject: Re: Date vs Timestamp without timezone Partition Key