Re: [PERFORM] finding a max value

2004-07-08 Thread James Antill
in postgresql, see... http://archives.postgresql.org/pgsql-performance/2003-12/msg00283.php -- # James Antill -- [EMAIL PROTECTED] :0: * ^From: [EMAIL PROTECTED] /dev/null ---(end of broadcast)--- TIP 9: the planner will ignore your desire to choos

[PERFORM] Query gets slow when where clause increases

2004-07-01 Thread James Antill
;.tid) Filter: ((performed_on <= 1088480270::bigint) AND (userid = 1540)) -> Seq Scan on tickets t (cost=0.00..4538.35 rows=18823 width=12) (actual time=0.16..83.53 rows=6020 loops=2420) Filter: (((status <> 4::smallin