faster and faster!!

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, bpalmer(at)crimelabs(dot)net pgp:crimelabs.net/bpalmer.pgp5