About PostgreSQL query optimisation.
I want to run a small PostgreSQL database which runs in memory only, for each unit test I write. For …
postgresql unit-testing postgresql-performanceI'm having trouble regarding speed in a SELECT query on a Postgres database. I have a table with two integer …
sql performance postgresql postgresql-performanceI need to delete about 2 million rows from my PG database. I have a list of IDs that I need …
sql postgresql bigdata sql-delete postgresql-performanceBelow is my query. I am trying to get it to use an index scan, but it will only seq …
postgresql indexing query-optimization postgresql-9.1 postgresql-performanceI have the following log table for user messages (simplified form) in Postgres 9.2: CREATE TABLE log ( log_date DATE, user_…
sql postgresql indexing greatest-n-per-group postgresql-performanceI need to create a ranking of similar strings in a table. I have the following table create table names ( …
sql postgresql text similarity postgresql-performanceI am not very familiar with looking at EXPLAIN ANALYZE results, I have a huge problem with my queries being …
performance postgresql database-design postgresql-performanceI have a strange problem with PostgreSQL performance for a query, using PostgreSQL 8.4.9. This query is selecting a set of …
database performance postgresql sql-execution-plan postgresql-performanceI have a simple query to join two tables that's being really slow. I found out that the query plan …
sql postgresql postgresql-performance database-indexesWe need to count the number of rows in a PostgreSQL table. In our case, no conditions need to be …
sql postgresql count postgresql-performance