Re: Access 2003 reports queries taking very long - Mailing list pgsql-novice

From Luca Ferrari
Subject Re: Access 2003 reports queries taking very long
Date
Msg-id CAKoxK+6tBJbX61Zd9dL-FNrPHHFsZ=wWh0dbZVN-CPPfxX4CDg@mail.gmail.com
Whole thread Raw
In response to Access 2003 reports queries taking very long  (Andrew Puschak <apuschak@gmail.com>)
Responses Re: Access 2003 reports queries taking very long  (Andrew Puschak <apuschak@gmail.com>)
List pgsql-novice
On Wed, Feb 12, 2014 at 3:53 PM, Andrew Puschak <apuschak@gmail.com> wrote:
> 2014-02-12 09:14:00 EST [18238]: [16-1] user=ourcompany,db=ourcompany LOG:  duration: 6231.878 ms  statement: SELECT
"savedt","clid_name" ,"hrs" ,"purpose" ,"howlong"  FROM "public"."ourtable" 

> 2014-02-12 09:14:22 EST [18238]: [17-1] user=ourcompany,db=ourcompany LOG:  duration: 18596.817 ms  statement: SELECT
"savedt","jobid" ,"emid" ,"clid_name" ,"hrs" ,"jname" ,"lname" ,"purpose" ,"howlong" ,"clid" ,"w_min" ,"m1"  FROM
"public"."ourtable"


The only difference I see is in the number of columns, but it is quite
strange that having the two queries ran at such a small time the data
is not cached. Is there anything that happened on the cluster (even
outside outable) in the meantime?


Luca


pgsql-novice by date:

Previous
From: Andrew Puschak
Date:
Subject: Access 2003 reports queries taking very long
Next
From: avpro avpro
Date:
Subject: