X-Original-To: pgsql-sql-postgresql.org@localhost.postgresql.org Received: from localhost (neptune.hub.org [200.46.204.2]) by svr1.postgresql.org (Postfix) with ESMTP id 4154ED1B487 for ; Tue, 9 Dec 2003 21:34:50 +0000 (GMT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (neptune.hub.org [200.46.204.2]) (amavisd-new, port 10024) with ESMTP id 25847-01 for ; Tue, 9 Dec 2003 17:34:21 -0400 (AST) Received: from srv02.shieldhost.com (srv02.shieldhost.com [66.98.168.13]) by svr1.postgresql.org (Postfix) with ESMTP id 2E19BD1B448 for ; Tue, 9 Dec 2003 17:34:15 -0400 (AST) X-ClientAddr: 67.123.247.142 Received: from DellLaptopDG (adsl-67-123-247-142.dsl.pltn13.pacbell.net [67.123.247.142]) (authenticated (0 bits)) by srv02.shieldhost.com (8.11.6/8.11.6) with ESMTP id hB9MZBg32005 for ; Tue, 9 Dec 2003 16:35:12 -0600 From: "David B" To: Subject: Faster performance when using where cust_id = '123' vs cust_id = 123. Does 7.4 fix this?? Date: Tue, 9 Dec 2003 13:35:24 -0800 Message-ID: MIME-Version: 1.0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: 7bit X-Priority: 3 (Normal) X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook IMO, Build 9.0.2416 (9.0.2911.0) Importance: Normal X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1165 X-MailScanner-Information: Please contact the ISP for more information X-MailScanner: Found to be clean X-MailScanner-SpamCheck: not spam, SpamAssassin (score=-8.8, required 5, BAYES_20, MSGID_GOOD_EXCHANGE) X-Virus-Scanned: by amavisd-new at postgresql.org X-Archive-Number: 200312/73 X-Sequence-Number: 16239 We have got used to the problem that queries of the format: select * from customer where cust_id = '123' are much much faster than select * from customer where cust_id = 123 (where cust_id is defined as bigint). a. Why is this. b. Will moving to v7.4 change this so we can avoid the whole '123' casting thing. Tx folks, D