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
Somewhat unrelated but note to anyone who wants to swap out partition keys.
Don't create a clone of the table with the new partition key and insert
data. It messes up the query planner massively and makes everything much
slower.
On Mon, May 25, 2020 at 12:48 AM Tom Lane wrote:
> Cedr
exception that they use their respective partition keys.
On Fri, Jun 5, 2020 at 10:17 PM David Rowley wrote:
> On Sat, 6 Jun 2020 at 14:12, Cedric Leong wrote:
> > Somewhat unrelated but note to anyone who wants to swap out partition
> keys. Don't create a clone of the table w
ll if it's
indexed.
Thanks again,
On Fri, Jun 5, 2020 at 11:13 PM David Rowley wrote:
> On Sat, 6 Jun 2020 at 14:49, Cedric Leong wrote:
> > It's less of a complaint rather than just a warning not to do what I did.
>
> My point was really that nobody really knew what you
