Re: Fwd: Re: Weird trouble with select

>
>>>> Hi!
>>>>
>>>> I have 3 pc's:
>>>> pc 'A' with postgres 7.2 running
>>>> pc 'B' and 'C' connected to 'A'
>>>>
>>> You should upgrade as quickly as possible. 7.2 is ancient. Even 8.1 will
>>> hit end-of-life soon.
>>>
>> We are testing postgres 8.3.11 to detect any problem when we migrate
>> from 7.2 :-)
>>
>>
>>>> if i made the next query on 'B' or 'C' : "select * from detail with
>>>> id=72"; takes too long time to return the data, near of 10 minutes
>>>> more or less.
>>>> if i made the next query on 'B' or 'C' : "select * from detail with
>>>> id=71", or whatever value in id , the data are returned immediatly.
>>>>
>>>> if i made the next query on 'A' (postgres server): "select * from
>>>> detail with id=72", the data are returned immediatly.
>>>>
>>> I wonder if you're just hitting caching effects, and the different
>>> client hosts are confusing the issue.
>>> If you issue the query from one machine
>>> multiple times, does it reliably take forever the first time, and go
>>> quickly afterward?
>>>
>> no, doesn't.
>> This only works fine with a pc diferent to 'B' or 'C'
>> if the query is executed many times only on 'B' the query always fail
>> for id=72 with another value works fine.
>>
>
Hi!, thanks for your answer
> How many results are being returned for id=72 vs other ids?
>
the tuples returned for id=72 are 91 (is too short :-( ), for id=71
are 94 for id=10 are 44.
> How are 'B' and 'C' connecting to 'A'; psql,JDBC,ODBC ?
>
the connection is realized by psql.
> Are you sure the clients are all connecting to the same database?
>

Yes i sure. Even check the PGUSER, PGDATABASE and PGHOST and those
varables are well setting.