From: | Scott Marlowe <scott(dot)marlowe(at)gmail(dot)com> |
---|---|
To: | erobles <erobles(at)sensacd(dot)com(dot)mx> |
Cc: | pgsql-general <pgsql-general(at)postgresql(dot)org> |
Subject: | Re: Weird trouble with select |
Date: | 2010-06-29 16:53:48 |
Message-ID: | AANLkTim5Mp4DVQKrtYW0RG36CEnuRnSmpyT3T8dJLQyR@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
On Tue, Jun 29, 2010 at 9:44 AM, erobles <erobles(at)sensacd(dot)com(dot)mx> wrote:
> 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.
How long does
select count(*) from (select * from detail where id=72);
take? I.e. no transfer of data, just the count.
From | Date | Subject | |
---|---|---|---|
Next Message | MD | 2010-06-29 19:28:33 | Looking for multithreaded build of libpq for Windows |
Previous Message | erobles | 2010-06-29 15:36:50 | Re: Fwd: Re: Weird trouble with select |