Question : We have a PostgreSQL 9.4.9 production server which was replicating to a slave instance, but today I discovered […]
Tag: postgresql-9.4
How simplify/optimize a search of keywords in two tables at the same time?
Question : I’m trying to model a function which will be used by a search engine (of cars for the […]
“parameter name used more than once” error when declaring function – why this is happening?
Question : create function test(a integer, b integer) returns table (a integer, b integer) as $$ begin return query select […]
Have DB users share tables
Question : I want to have 2 users of the DB (user_app and user_migration), one for executing migrations (which will […]
Minimizing SELECT latency in PostgreSQL
Question : I am evaluating Postgres 9.4 performance on a machine with Intel i7 quad-core 3.6 GHz CPU, 8 GB […]
Count approximation with where clause
Question : I have the following problem, we have a table of facilities for apartments that looks something like this: […]
Optimizing query in PostgreSQL that tries to match a string and matches a timestamp range
Question : I am building a database in PostgreSQL for financial data, where the table looks like this: create table […]
Retrieving latest record using DISTINCT ON is slow [duplicate]
Question : This question already has answers here: How do I efficiently get “the most recent corresponding row”? (6 answers) […]
Postgres is performing sequential scan instead of index scan
Question : I have a table with about 10 million rows in it and an index on a date field. […]
Trying to upgrade PostgreSQL 9.1 to 9.4 on Debian
Question : After upgrading my Debian development box I have both PostgreSQL 9.1 and 9.4 on my system. I want […]