On Tue, Jun 29, 2010 at 9:44 AM, erobles 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
On 06/29/2010 10:19 AM, Adrian Klaver wrote:
On Tuesday 29 June 2010 7:47:32 am erobles wrote:
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 a
On Tuesday 29 June 2010 7:47:32 am erobles wrote:
>
> 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'; psq
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 :
On Tuesday 29 June 2010 7:22:56 am erobles wrote:
> Original Message
> Subject: Re: [GENERAL] Weird trouble with select
> Date: Tue, 29 Jun 2010 09:13:14 -0500
> From: erobles
> Organization: SENSA Control Digital
> To: Joshua To
Original Message
Subject:Re: [GENERAL] Weird trouble with select
Date: Tue, 29 Jun 2010 09:13:14 -0500
From: erobles
Organization: SENSA Control Digital
To: Joshua Tolley
On 06/29/2010 08:59 AM, Joshua Tolley wrote:
On Tue, Jun 29, 2010 at 08:44:35AM
On Tue, Jun 29, 2010 at 08:44:35AM -0500, erobles wrote:
> 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.
> if i made the next query on 'B' or 'C' : "
