PostgreSQL query very slow with limit 1

by

You can avoid this issue by adding an unneeded ORDER BY clause to the query.

SELECT * FROM object_values WHERE (objectID = 53708) ORDER BY timestamp, objectID DESC limit 1;

More Related Contents:

  1. PostgreSQL LIKE query performance variations
  2. Postgres query optimization (forcing an index scan)
  3. Optimize Postgres query on timestamp range
  4. Insert, on duplicate update in PostgreSQL?
  5. invalid byte sequence for encoding “UTF8”
  6. Postgresql: Conditionally unique constraint
  7. How to make “case-insensitive” query in Postgresql?
  8. Rownum in postgresql
  9. dynamic sql query in postgres
  10. Cannot create a database table named ‘user’ in PostgreSQL
  11. Is there a timeout for idle PostgreSQL connections?
  12. How to make connection to Postgres via Node.js
  13. Postgresql Truncation speed
  14. How can I speed up a MySQL query with a large offset in the LIMIT clause?
  15. Buffers (Circle) in PostGIS
  16. How to get function parameter lists (so I can drop a function)
  17. Unable to connect PostgreSQL to remote database using pgAdmin
  18. How to convert a postgres database to sqlite
  19. How does PostgreSQL perform ORDER BY with a b-tree index on the field?
  20. Error when setting n_distinct using a plpgsql variable
  21. Docker wait for postgresql to be running
  22. Function to loop through and select data from multiple tables
  23. Switch role after connecting to database
  24. SQL Sub queries in check constraint
  25. When do Postgres column or table names need quotes and when don’t they?
  26. How can I get a list of all functions stored in the database of a particular schema in PostgreSQL?
  27. Composite PRIMARY KEY enforces NOT NULL constraints on involved columns
  28. PostgreSQL how to concat interval value ‘2 days’
  29. Displaying image in Ireports using PostgreSql
  30. Spring Docker container cannot access Postgres Docker container

Leave a Comment