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 > several millions of

Re: Postgresql 13 partitioning advice

2022-08-02 Thread David Rowley
On Tue, 2 Aug 2022 at 19:48, Ameya Bidwalkar wrote: > 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 u