Date vs Timestamp without timezone Partition Key

Поиск
Список
Период
Сортировка
От Cedric Leong
Тема Date vs Timestamp without timezone Partition Key
Дата
Msg-id CAD6i=X0h3RJFes4E662-HbQRGCV+HcAPjAJbK8vLSVFM20RK6w@mail.gmail.com
обсуждение исходный текст
Ответы Re: Date vs Timestamp without timezone Partition Key  (Tom Lane <tgl@sss.pgh.pa.us>)
Список 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 по дате отправления:

Предыдущее
От: Rory Campbell-Lange
Дата:
Сообщение: Strategy for materialisation and centralisation of data
Следующее
От: Tom Lane
Дата:
Сообщение: Re: Date vs Timestamp without timezone Partition Key