Re: plan using BTree VS GIN

2023-06-25 Thread Nicolas Seinlet
On Friday, June 23rd, 2023 at 2:52 PM, Laurenz Albe wrote: > > > On Fri, 2023-06-23 at 12:08 +, Nicolas Seinlet wrote: > > > we faced an issue with a select query on a relatively large table on our > > database. > > The query involves one single table. The table has more than 10 mill

Re: plan using BTree VS GIN

2023-06-23 Thread Laurenz Albe
On Fri, 2023-06-23 at 12:08 +, Nicolas Seinlet wrote: > we faced an issue with a select query on a relatively large table on our > database. > The query involves one single table. The table has more than 10 million > records. > It's mainly composed of varchar fields, have a primary key (id) o

plan using BTree VS GIN

2023-06-23 Thread Nicolas Seinlet
Hello, we faced an issue with a select query on a relatively large table on our database. The query involves one single table. The table has more than 10 million records. It's mainly composed of varchar fields, have a primary key (id) of type serial, and when records of this table are shown to u