Question : I am using the ruby pg_search gem, where code like this: Food.search(“orange”) produces a query like this. SELECT […]
Tag: gin-index
Forcing postgres to use a GIN index on a varchar[]
Question : In a postgres 9.4 database, I have a table with a field identifiers: varchar(512)[] that contains a list […]
Inner join using an array column
Question : Having trouble indexing and executing a query in O (log n) time. The query includes an INNER JOIN, […]
Inner join using an array column
Question : Having trouble indexing and executing a query in O (log n) time. The query includes an INNER JOIN, […]
Occasional/intermittent, slow (10+-second) UPDATE queries on PostgreSQL table with GIN index
Question : The Setup I am running PostgreSQL 9.4.15 on an SSD-based, quad-core Virtual Private Server (VPS) with Debian Linux […]
Inner join using an array column
Question : Having trouble indexing and executing a query in O (log n) time. The query includes an INNER JOIN, […]
Any drawbacks of using GIN PostgreSQL index for an integer foreign key?
Question : I have a large table (600 millions rows) with a foreign key other_id of type integer. A single […]
Does PostgreSQL btree_gin extension use btree or gin data structure?
Question : In order to define a GIN index on an array and scalar field (for example) you need to […]
Optimize select query with OR and ILIKE
Question : I have the following query for my PostgreSQL 13 database: SELECT * FROM “user” INNER JOIN “comment” on […]
How can I make an index covering a ts_vector expression and also an integer?
Question : I am using the ruby pg_search gem, where code like this: Food.search(“orange”) produces a query like this. SELECT […]
- 1
- 2