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.
- Date vs Timestamp without timezone Partition Key Cedric Leong
- Re: Date vs Timestamp without timezone Partition Key Tom Lane
- Re: Date vs Timestamp without timezone Partition Key Cedric Leong
- Re: Date vs Timestamp without timezone Partition... David Rowley
- Re: Date vs Timestamp without timezone Parti... Cedric Leong
- Re: Date vs Timestamp without timezone ... David Rowley
- Re: Date vs Timestamp without timez... Cedric Leong