gin-index Archives

Forcing postgres to use a GIN index on a varchar[]

By adminPosted on September 7, 2022

Question : In a postgres 9.4 database, I have a table with a field identifiers: varchar(512)[] that contains a list […]

By adminPosted on August 21, 2022

Question : Having trouble indexing and executing a query in O (log n) time. The query includes an INNER JOIN, […]

By adminPosted on July 23, 2022

Question : Having trouble indexing and executing a query in O (log n) time. The query includes an INNER JOIN, […]

By adminPosted on July 13, 2022

Question : The Setup I am running PostgreSQL 9.4.15 on an SSD-based, quad-core Virtual Private Server (VPS) with Debian Linux […]

By adminPosted on May 24, 2022

Question : Having trouble indexing and executing a query in O (log n) time. The query includes an INNER JOIN, […]

By adminPosted on April 28, 2022

Question : I have a large table (600 millions rows) with a foreign key other_id of type integer. A single […]

By adminPosted on March 17, 2022

Question : In order to define a GIN index on an array and scalar field (for example) you need to […]

By adminPosted on November 29, 2021

Question : I have the following query for my PostgreSQL 13 database: SELECT * FROM “user” INNER JOIN “comment” on […]

By adminPosted on November 16, 2021

Question : I am using the ruby pg_search gem, where code like this: Food.search(“orange”) produces a query like this. SELECT […]

By adminPosted on August 12, 2021

Question : Hello I have about 50 million forums and each forum has over 30 million topics which this is […]