Cedric Leong <cedricleong@xxxxxxxxx> writes: > 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? I doubt it's even measurable, at least on 64-bit machines. You're basically talking about 32-bit integer comparisons vs 64-bit integer comparisons. On a 32-bit machine it's possible that an index on a date column will be physically smaller, so you could get some wins from reduced I/O. But on (most?) 64-bit machines that difference goes away too, because of alignment restrictions. As always, YMMV; it never hurts to do your own testing. regards, tom lane
