Re: [PERFORM] Help specifying new web server/database machine

2005-06-09 Thread Oliver Elphick
uggest that Opterons work very well even in a 32 bit > environment. You can treat the machine as a 32bit machine and install the i386 version of Debian; it will run rather slower than with 64 bit software. Oliver Elphick ---(end of broadcast)--- TIP 7: don't forget to increase your free space map settings

Re: [PERFORM] Stuck using Sequential Scan

2004-09-10 Thread Oliver Elphick
EGER, whereas the column is BIGINT; there is no automatic conversion in this case, so the planner does not realise the index is usable for this query (I think 8.0 solves this). Try: select * from tsyslog where tsyslog_id=431650835::BIGINT; -- Oliver Elphick

Re: [PERFORM] Select-Insert-Query

2004-03-02 Thread Oliver Elphick
_id between a_minid and a_maxid ORDER BY date DESC LIMIT 99; -- Oliver Elphick <[EMAIL PROTECTED]> LFIX Ltd ---(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