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 |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
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.
From | Date | Subject | |
---|---|---|---|
Next Message | Heikki Linnakangas | 2007-01-29 13:35:41 | Re: [OT] Very strange postgresql behaviour |
Previous Message | Arnau | 2007-01-29 12:21:56 | [OT] Very strange postgresql behaviour |