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

Re: [OT] Very strange postgresql behaviour

From: Carlos Moreno <moreno_pg(at)mochima(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 19:47:46
Message-ID: 45BE4F62.50007@mochima.com (view raw or flat)
Thread:
Lists: pgsql-performance
Arnau wrote:

> Hi Bill,
>
>> 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;
>>

Just wild guessing:  is there any chance that there may be some form of
"implicit" limit modifier for the select statements on this table?  Does 
the
behaviour change if you add "limit 2" at the end of the query?  Does it
change if you use customer_app_config_id in (5929, 11527) instead?

Another wild guess:  if the data is somewhat corrupt, maybe a vacuum
analyze would detect it?  Or perhaps try pg_dumping, to see if pg_dump
at some point complains about mssing or corrupt data?

HTH,

Carlos
--


In response to

pgsql-performance by date

Next:From: Saranya SivakumarDate: 2007-01-29 20:51:17
Subject: Thanks All!
Previous:From: Cosimo StrepponeDate: 2007-01-29 16:44:13
Subject: Re: int4 vs varchar to store ip addr

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