RE: [PoC] Partition path cache

2024-10-28 Thread Bykov Ivan
Hello > This sounds like an interesting idea, I like it because it omit the needs for > "global statistics" effort for partitioned table since it just use the first > partition it knows. Of couse it has its drawback that "first" > partition can't represent other partitions. This method uses glo

Re: [PoC] Partition path cache

2024-10-24 Thread Andy Fan
Bykov Ivan writes: > Our customers use databases (1-10 TB) with big tables. Often these tables are > big and split on sections. For example, we have tables with almost > thousand sections. In most cases, those sections have a similar set of > indexes > and contain similar data. Often this par