[prev in list] [next in list] [prev in thread] [next in thread] 

List:       postgresql-sql
Subject:    [SQL] faster and faster!!
From:       bpalmer <bpalmer () crimelabs ! net>
Date:       2001-09-28 14:02:32
[Download RAW message or body]

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@crimelabs.net           pgp:crimelabs.net/bpalmer.pgp5


---------------------------(end of broadcast)---------------------------
TIP 6: Have you searched our list archives?

http://archives.postgresql.org

[prev in list] [next in list] [prev in thread] [next in thread]