Postgresql 13 partitioning advice

2022-08-02 Thread Ameya Bidwalkar
We have a Postgresql 13 database where we have a single table with several millions of rows . We plan to partition it based on timestamp . We have been seeking advice for best practices for building this. This table will get lots of updates for the same rows during a short period of time.During

Re: Postgresql 13 partitioning advice

2022-08-03 Thread Ameya Bidwalkar
Hello David, Thank you for the valuable inputs.We will test these scenarios . Regards, Ameya On Tue, Aug 2, 2022 at 12:16 PM David Rowley wrote: > On Tue, 2 Aug 2022 at 19:48, Ameya Bidwalkar > wrote: > > We have a Postgresql 13 database where we have a single table with > s