Tagged Questions
0
votes
1answer
48 views
postgres explain plan with giant gaps between operations
I have a postgresql explain plan that seems to have large gaps between the join, sort & filter processes and can't explain (sorry) it. The query is taking an inordinate amount of time and the ...
2
votes
1answer
142 views
Postgresql not using GIN trigram index when performing non-ASCII LIKE query?
Steps to reproduce
Create database
CREATE DATABASE citiesdb
WITH OWNER = citiesowner
ENCODING = 'UTF8'
TABLESPACE = pg_default
LC_COLLATE = 'C'
LC_CTYPE = 'C'
...
1
vote
1answer
179 views
Postgres, levenshtein distance and nested queries
I have a DB Table with 3,000,000 rows or more like that:
|ID|T4|T16|T64|TL
where ID =INTEGER (PK)
and T4,T16,T64,TL are text fields. Each one is larger in length than the previous, i.e., LENGTH(T4)
...
0
votes
1answer
97 views
Postgres EXPLAIN ANALYZE behavior
I want to benchmark performance of a particular complicated query JOIN for various values of primary key ID. Most previous approaches say to use EXPLAIN ANALYZE for the query in question and get the ...
7
votes
3answers
6k views
Optimizing queries on a range of timestamps (two columns)
I use postgresql-9.1 with ubuntu 12.04.
I need to select records inside a range of time: my table time_limits has two timestamp fields and one property integer. Indeed there are other info columns ...
