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

Weird trouble with select

From: erobles <erobles(at)sensacd(dot)com(dot)mx>
To: pgsql-general <pgsql-general(at)postgresql(dot)org>
Subject: Weird trouble with select
Date: 2010-06-29 13:44:35
Message-ID: (view raw, whole thread or download thread mbox)
Lists: pgsql-general

I have  3  pc's:
pc 'A'  with postgres 7.2 running
pc 'B' and 'C'  connected to  'A'

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 tried to recreate de database ( drop and create), but i got the same 
result on  'B' and 'C' pc's.

But when  i made the query on another scenary ( 'D'  and 'E' with 'F' 
like postgres server)  with the same database  the works fine.

So i am   intrigued,  i checked the  network connection but looks fine, 
if you can  help me with this, i will  thankfull with you!

Regards, e-ddie.


pgsql-general by date

Next:From: Sim ZacksDate: 2010-06-29 13:45:50
Subject: Re: alter table schema, default sequences stay the same
Previous:From: Joshua TolleyDate: 2010-06-29 13:37:36
Subject: Re: No PL/PHP ? Any reason?

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