Re: PostgreSQL client hangs sometimes on 'EXEC SQL PREPARE sid_sisisinst FROM :select_anw;'

I've added the proposed log line to the server code in src/backend/libpq/pqcomm.c and restarted the server with this. In the log file /data/postgresql11/data/serverlog are other messages about length of packages, like: 2020-04-28 09:49:49.877 CEST [16229] LOG: invalid length of startup packet

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

Re: GIN Expression Indexes

On 4/28/20 1:58 PM, Taylor Sarrafian wrote: 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 oper