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.
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? |