Re: bad performances using hashjoin

From: David Brown <time(at)bigpond(dot)net(dot)au>
To: Gaetano Mendola <pgsql-performance(at)postgresql(dot)org>
Subject: Re: bad performances using hashjoin
Date: 2005-02-21 14:03:03
Message-ID: 4219EA17.8090906@bigpond.net.au
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

Gaetano Mendola wrote:

>I think is due the fact that first queries were performed in peakhours.
>
>
A memory intensive operation takes 7.5 times longer during heavy loads.
Doesn't this suggest that swapping of working memory is occurring?

In response to

Browse pgsql-performance by date

  From Date Subject
Next Message Merlin Moncure 2005-02-21 14:03:20 Re: seq scan cache vs. index cache smackdown
Previous Message Gaetano Mendola 2005-02-21 11:23:15 Re: Effects of IDLE processes