Re: WAL size estimation

2019-06-26 Thread Todd Lipcon
Hey Pavel, I went back and looked at the source here. It appears that 24MB is the expected size for an index file -- each entry is 24 bytes and the index file should keep 1M entries. That said, for a "cold tablet" (in which you'd have only a small number of actual WAL files) I would expect only

Re: Need information about internals of InList predicate

2019-06-26 Thread Todd Lipcon
Hi Sergey, The optimization you're looking for is essentially to realize that IN-list on a primary key prefix can be converted as follows: scan(PK in (1,2,3)) -> scan(PK = 1 OR PK = 2 OR PK = 3) -> scan(PK = 1) union all scan(pk = 2) union all scan(PK = 3) Currently, the tserver doesn't support