Fra: Michael Lewis
Dato: 15. januar 2021 kl. 19.49.32 CET
Til: Niels Jespersen
Cc: pgsql-gene...@postgresql.org
Emne: Re: time-based range partitioning and truncate/delete different timezones
What version are you using? How long are you keeping data for
What version are you using? How long are you keeping data for? It is
possible to partition by hour or would that exceed the number of
recommended partitions too quickly for your retention time period? Else, I
would partition on date according to the timezone of your data. Selecting
from multiple pa
Hi all
I need ideas regarding a way to design an insert, truncate/delete, and reinsert
process on data that is in UTC and database range partitions that are in the
Europe/Brussels time zone. Therefore, any input is welcome.
The issue at hand is this. We receive daily file deliveries of time-ba
