Re: Bad performance with hashjoin - Mailing list pgsql-performance

From Tom Lane
Subject Re: Bad performance with hashjoin
Date
Msg-id 10706.1094916524@sss.pgh.pa.us
Whole thread Raw
In response to Bad performance with hashjoin  (Vitaly Belman <vitalyb@gmail.com>)
List pgsql-performance
Vitaly Belman <vitalyb@gmail.com> writes:
> What am I to do?

Reduce random_page_cost and/or increase effective_cache_size.

            regards, tom lane

pgsql-performance by date:

Previous
From: Vitaly Belman
Date:
Subject: Bad performance with hashjoin
Next
From: Mark Cotner
Date:
Subject: Data Warehouse Reevaluation - MySQL vs Postgres