Re: Efficient Partitioning Strategies for PostgreSQL Table with KSUID and High Volume

2023-09-05 Thread Lorusso Domenico
Hello, Increase of access cost is logarithmic when we access by index, so partition often isn't a solution to improve performance, but a solution to solve human difficulties to manage huge amounts of data, to develop expensive parallel jobs and, in some cases, to improve performance for sequential

Efficient Partitioning Strategies for PostgreSQL Table with KSUID and High Volume

2023-09-05 Thread wheels
Hi Team, I'm working with a PostgreSQL table containing terabytes of data, and it grows by millions of rows weekly. Each row is identified by a [KSUID][1], and my primary read patterns are: 1. Retrieve a row by its KSUID. 2. List rows by `user_id` in descending order, pagination acceptable. Curr