postgresql-performance Examples and Free Source Code

Query with many self-joins is slow...

sql postgresql database-design entity-attribute-value postgresql-performance

optimize query using explain analyze result...

postgresql postgresql-performance

Counting preceding occurences of an event within a given interval for each event row with a window f...

sql postgresql aggregate-functions window-functions postgresql-performance

Efficiently mark contiguous subsets of rows in postgres...

sql postgresql indexing random postgresql-performance

Is it possible to answer queries on a view before fully materializing the view?...

postgresql view postgresql-performance optimization set-returning-functions

FULL JOIN with =any doesn't use indexes...

sql postgresql indexing outer-join postgresql-performance

Looking in array with a big set of input values...

arrays performance postgresql indexing postgresql-performance

Join/Subquery is fast/slow depending on which column I filter on (not a simple index issue)...

sql performance postgresql subquery postgresql-performance

Postgresql ignoring index on timestamp column even if query is faster using index...

sql postgresql postgresql-9.3 postgresql-performance sql-execution-plan

Efficiently calculate number of currently active users...

sql performance postgresql indexing postgresql-performance

LIMIT optimized queries...

sql postgresql query-optimization lazy-evaluation postgresql-performance

Postgres uses wrong index...

postgresql indexing postgresql-performance sql-execution-plan

PostgreSQL join fetch all rows in table, too slow...

postgresql inner-join query-performance postgresql-performance

What is wrong with the way I count rows in a complex query?...

sql database postgresql count postgresql-performance

Postgresql query optimization Index not used...

sql postgresql query-optimization postgis postgresql-performance

Inner join performance...

sql postgresql join database-design postgresql-performance

How to force PostgreSQL to use my index?...

postgresql indexing postgresql-performance

Optimize time of execution of PSQL query...

sql postgresql postgresql-performance

Improve performance on multicolumn index and sort...

postgresql indexing query-performance postgresql-performance

PostgreSQL window function: partition by comparison...

sql postgresql window-functions postgresql-performance

Searchable Database View with Aggregate Nested Tables in Postgresql...

sql postgresql postgresql-performance

Use the results of SUM in the same query...

sql postgresql aggregate-functions postgresql-performance

Ways to improve this SQL query...

sql postgresql indexing postgresql-performance sql-limit

Does adding extraneous tables in a WITH clauses slow down a query in PostgreSQL?...

sql postgresql common-table-expression postgresql-performance

Update query on big table slow...

sql postgresql sql-update greatest-n-per-group postgresql-performance

Postgres chooses a bad query plan...

postgresql postgresql-performance

query planner inaccurate choosing nested join...

sql postgresql database-design indexing postgresql-performance

DISTINCT INNER JOIN slow...

sql postgresql distinct exists postgresql-performance

Performance impact of empty LIKE in a prepared statement...

sql postgresql pattern-matching prepared-statement postgresql-performance

Indexed ORDER BY with LIMIT 1...

sql postgresql indexing sql-order-by postgresql-performance