Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-performance by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group