Two questions: - Does the order of WHERE clauses make a difference? I was trying to make some of my code faster and tried switching two clauses that should have effected the query, but there was no speed difference.
- I have a query: SELECT stamp FROM table WHERE timestamp > now() - INTERVAL '1 0:00' This query takes 13 seconds to run. If I were to run another query such as: WHERE sid > 1000 it would return almost instantly. There are indexes on both columns. Is dealing with timestamps that slow? Is there any way to speed it up? Thanks all, - Brandon ---------------------------------------------------------------------------- c: 646-456-5455 h: 201-798-4983 b. palmer, [EMAIL PROTECTED] pgp:crimelabs.net/bpalmer.pgp5 ---------------------------(end of broadcast)--------------------------- TIP 6: Have you searched our list archives? http://archives.postgresql.org
