[PERFORM] Query gets slow when where clause increases

2004-07-01 Thread James Antill
::bigint)) AND ((status 9::smallint) OR (modified = 1086875491::bigint))) Total runtime: 218123.24 msec -- James Antill -- [EMAIL PROTECTED] Need an efficient and powerful string library for C? http://www.and.org/vstr/ ---(end of broadcast)--- TIP 6

Re: [PERFORM] finding a max value

2004-07-08 Thread James Antill
-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 choose an index scan if your joining column's datatypes do not match