[BUGS] Huge speed penalty using <>TRUE instead of =FALSE

I overlooking something? This was verified on PostgreSQL 8.3.7, both on Windows Xp and Ubuntu 8.10. Some relevant details from the table definition: CREATE TABLE alarmlogg ( id serial NOT NULL, alarm_status character varying(1) DEFAULT ''::character varying, logg_avsluttet boolea

Re: [BUGS] Huge speed penalty using <>TRUE instead of =FALSE

Jan-Ivar Mellingen skrev: > One of our customers discovered that by replacing <>TRUE with =FALSE in > a query of a table containing 750.000 records reduced the query time > from about 12 seconds to about 60 milliseconds! > > The problematic query looks like this: > SELEC

Re: [BUGS] BUG #5346: PostgresSQL ODBC 64 bits download

Maximiliano Salazar skrev: The following bug has been logged online: Bug reference: 5346 Logged by: Maximiliano Salazar Email address: maxisala...@hotmail.com PostgreSQL version: 8.2 Operating system: Windows 7 Ultimate 64 Bits Description:PostgresSQL ODBC 64 bits do