Logical Replication for Very Large Databases

Hi friends, We have a relatively large database (~5TB) receiving very frequent INSERTs/UPDATEs, and we’d like to create a logical replica of it. To put things in perspective, we often generate up to 10 WAL-segments (16MB each) per second (wal_level=replica). We successfully set up logical repl

GIN Expression Indexes

Hi friends! We tried to index an array function like this: CREATE INDEX my_arr_index ON my_table USING GIN ( my_arr_func( my_col ) ) But the planner can’t seem to figure out how to use the index with any query! It doesn’t work with any array operators. SELECT * FROM my_table WHERE ARRAY[ 1