Re: Indexes that would span partitions.

2022-03-15 Thread Tim Uckun
> How many partitions do you expect to have? Why are you partitioning on that > column? Do you have need to drop old data all at the same time? How many rows > in each partition or in total do you expect to have? In my case there is a hierarchy so the partitions are based on certain parts of the

Re: Indexes that would span partitions.

2022-03-14 Thread Michael Lewis
How many partitions do you expect to have? Why are you partitioning on that column? Do you have need to drop old data all at the same time? How many rows in each partition or in total do you expect to have?

Indexes that would span partitions.

2022-03-13 Thread Tim Uckun
What's a good strategy for dealing with indexes (multiple) that would span multiple partitions of a table. For example: Let's say I have a table that's partitioned by group_id because I want all the records for a group to be in the same partition. Let's say I have a field called "expires_at" whi