Re: time-based range partitioning and truncate/delete different timezones

2021-01-15 Thread Niels Jespersen
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

Re: time-based range partitioning and truncate/delete different timezones

2021-01-15 Thread Michael Lewis
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