New posts in postgresql-performance

Postgres query optimization (forcing an index scan)

postgresql indexing query-optimization postgresql-9.1 postgresql-performance

Finding similar strings with PostgreSQL quickly

sql postgresql text similarity postgresql-performance

Configuration parameter work_mem in PostgreSQL on Linux

postgresql postgresql-performance server-configuration

How do I speed up counting rows in a PostgreSQL table?

sql postgresql count postgresql-performance

How does PostgreSQL perform ORDER BY with a b-tree index on the field?

postgresql sorting indexing sql-order-by postgresql-performance

Function executes faster without STRICT modifier?

postgresql performance sql-function strict postgresql-performance

Multicolumn index on 3 fields with heterogenous data types

postgresql indexing postgis postgresql-performance

Optimize Postgres query on timestamp range

postgresql indexing query-optimization database-partitioning postgresql-performance

Best way to delete millions of rows by ID

sql postgresql bigdata sql-delete postgresql-performance

Best indexing alternative to speed up querying my millions of data in PostgreSQL

sql postgresql indexing named-query postgresql-performance

Way to try multiple SELECTs till a result is available?

sql postgresql union postgresql-performance

Running PostgreSQL in memory only

postgresql unit-testing postgresql-performance

Keep PostgreSQL from sometimes choosing a bad query plan

database performance postgresql sql-execution-plan postgresql-performance

Any downsides of using data type "text" for storing strings?

sql postgresql types postgresql-performance

Intersection of SQL statements efficiently

sql postgresql intersection postgresql-performance

Optimize GROUP BY query to retrieve latest row per user

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