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: 4C29F8C3.50605@sensacd.com.mx
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hi!

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.

Responses

Browse pgsql-general by date

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