Skip site navigation (1) Skip section navigation (2)

Re: [OT] Very strange postgresql behaviour

From: Bill Moran <wmoran(at)collaborativefusion(dot)com>
To: arnaulist(at)andromeiberica(dot)com
Cc: PostgreSQL Performance <pgsql-performance(at)postgresql(dot)org>
Subject: Re: [OT] Very strange postgresql behaviour
Date: 2007-01-29 13:27:06
Message-ID: 20070129082706.0ef2df3b.wmoran@collaborativefusion.com (view raw or flat)
Thread:
Lists: pgsql-performance
In response to Arnau <arnaulist(at)andromeiberica(dot)com>:
> 
>    I have postgresql 7.4.2 running on debian and I have the oddest
> postgresql behaviour I've ever seen.
> 
> I do the following queries:
> 
> 
> espsm_asme=# select customer_app_config_id, customer_app_config_name
> from customer_app_config where customer_app_config_id = 5929 or
> customer_app_config_id = 11527 order by customer_app_config_id;
> 
> 
>   customer_app_config_id | customer_app_config_name
> ------------------------+--------------------------
>                     5929 | INFO
> (1 row)
> 
> 
>    I do the same query but changing the order of the or conditions:
> 
> 
> espsm_asme=# select customer_app_config_id, customer_app_config_name
> from customer_app_config where customer_app_config_id = 11527 or
> customer_app_config_id = 5929 order by customer_app_config_id;
> 
> 
>   customer_app_config_id | customer_app_config_name
> ------------------------+--------------------------
>                    11527 | MOVIDOSERENA TONI 5523
> (1 row)
> 
> 
> 
>    As you can see, the configuration 5929 and 11527 both exists, but
> when I do the queries they don't appear.

[snip]

Just a guess, but perhaps your index is damaged.  Have you tried
REINDEXing?

-- 
Bill Moran
Collaborative Fusion Inc.

In response to

Responses

pgsql-performance by date

Next:From: Heikki LinnakangasDate: 2007-01-29 13:35:41
Subject: Re: [OT] Very strange postgresql behaviour
Previous:From: ArnauDate: 2007-01-29 12:21:56
Subject: [OT] Very strange postgresql behaviour

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group