Received: from magus.postgresql.org (magus.postgresql.org [87.238.57.229]) by mail.postgresql.org (Postfix) with ESMTP id B1D91CE6EB for ; Fri, 15 Jun 2012 03:34:34 -0300 (ADT) Received: from archon2012.plus.com ([80.229.41.160] helo=mail.archonet.com) by magus.postgresql.org with esmtp (Exim 4.72) (envelope-from ) id 1SfQ76-000627-1n for pgsql-sql@postgresql.org; Fri, 15 Jun 2012 06:34:33 +0000 Received: from [192.168.1.13] (ariel.office.archonet.com [192.168.1.13]) by mail.archonet.com (Postfix) with ESMTP id 28E3B2C4730; Fri, 15 Jun 2012 07:34:17 +0100 (BST) Message-ID: <4FDAD768.4040409@archonet.com> Date: Fri, 15 Jun 2012 07:34:16 +0100 From: Richard Huxton User-Agent: Mozilla/5.0 (X11; Linux x86_64; rv:10.0.4) Gecko/20120510 Icedove/10.0.4 MIME-Version: 1.0 To: Achilleas Mantzios CC: pgsql-sql@postgresql.org Subject: Re: Insane behaviour in 8.3.3 References: <201206141139.35601.achill@matrix.gatewaynet.com> In-Reply-To: <201206141139.35601.achill@matrix.gatewaynet.com> Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit X-Pg-Spam-Score: -1.9 (-) X-Archive-Number: 201206/36 X-Sequence-Number: 36690 On 14/06/12 09:39, Achilleas Mantzios wrote: > dynacom=# SELECT id from items_tmp WHERE id=1261319 AND xid=61972; > id > --------- > 1261319 > (1 row) > dynacom=# -- ok this is how it should be > dynacom=# SELECT id from items_tmp WHERE id=1261319 AND xid=currval('xadmin_xid_seq'); > id > ---- > (0 rows) > dynacom=# -- THIS IS INSANE Perhaps just do an EXPLAIN ANALYSE on both of those. If for some reason one is using the index and the other isn't then it could be down to a corrupted index. Seems unlikely though. -- Richard Huxton Archonet Ltd