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

Re: Hash join on int takes 8..114 seconds

From: Tomas Vondra <tv(at)fuzzy(dot)cz>
To:
Cc: pgsql-performance(at)postgresql(dot)org
Subject: Re: Hash join on int takes 8..114 seconds
Date: 2008-11-23 18:47:15
Message-ID: 4929A533.5030203@fuzzy.cz (view raw or flat)
Thread:
Lists: pgsql-performance
> Risky to try in prod server. Requires creating  randomly distributed
> product_id testcase to measure
> difference.
> 
> What should I do next?

I guess you have backups - take them, restore the database on a 
different machine (preferably with the same / similar hw config) and 
tune the queries on it.

After restoring all the tables / indexes will be 'clean' (not bloated), 
so you'll see if performing VACUUM FULL / CLUSTER is the right solution 
or if you have to change the application internals.

Sure, the times will be slightly different but the performance problems 
should remain the same.

regards
Tomas

In response to

Responses

pgsql-performance by date

Next:From: AndrusDate: 2008-11-23 20:52:54
Subject: limit clause produces wrong query plan
Previous:From: AndrusDate: 2008-11-23 14:39:37
Subject: Re: Hash join on int takes 8..114 seconds

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