On Tue, Dec 10, 2013 at 01:53:54PM -0800, salah jubeh wrote:
> Thanks for the link, I find it very useful, unfortunatly I am using 9.1.11
> version.
>
> After digging a little bit, I find out that the gettimeofday is indeed a
> little
> bit slower on this particular machine than other machines,
>>>On Thu, Dec 5, 2013 at 09:22:14AM -0500, Tom Lane wrote:
>>> salah jubeh writes:
>>> When I excute a query,�the exection time is about 1 minute;
however, when I execute the query with explain analyze the excution time
jumps to 10 minutes.
>>
>> This isn't exactly unheard of, although it
On Thu, Dec 5, 2013 at 09:22:14AM -0500, Tom Lane wrote:
> salah jubeh writes:
> > When I excute a query,� the exection time is about 1 minute; however, when
> > I execute the query with explain analyze the excution time jumps to 10
> > minutes.
>
> This isn't exactly unheard of, although it
salah jubeh wrote:
> The hardware is pretty good, I have 8 cpus of Intel(R) Core(TM)
> i7, 2.4 GH , and 16 Gib of RAM. Is there any configuration
> parameter that can lead to this issue.
What OS?
--
Kevin Grittner
EDB: http://www.enterprisedb.com
The Enterprise PostgreSQL Company
--
Sent via
Hello Tom,
The hardware is pretty good, I have 8 cpus of Intel(R) Core(TM) i7, 2.4 GH ,
and 16 Gib of RAM. Is there any configuration parameter that can lead to this
issue.
Regards
On Thursday, December 5, 2013 3:23 PM, vincent elschot wrote:
On 05-12-13 15:09, salah jubeh wrote:
>
salah jubeh writes:
> When I excute a query, the exection time is about 1 minute; however, when I
> execute the query with explain analyze the excution time jumps to 10 minutes.
This isn't exactly unheard of, although it sounds like you have a
particularly bad case. Cheap commodity PCs tend t
On 05-12-13 15:09, salah jubeh wrote:
Hello guys,
When I excute a query, the exection time is about 1 minute; however,
when I execute the query with explain analyze the excution time jumps
to 10 minutes.
I have tried this for several queries, where I need to optimize; and
using explain an
Hello guys,
When I excute a query, the exection time is about 1 minute; however, when I
execute the query with explain analyze the excution time jumps to 10 minutes.
I have tried this for several queries, where I need to optimize; and using
explain analyze leads alway to a huge time ove
