Re: [BUGS] BUG #8130: Hashjoin still gives issues

2013-05-01 Thread Tom Lane
ste...@konink.de writes: > By setting "set enable_hashjoin = off;" performance in our entire > application increased 30 fold in throughput, which was a bit unexpected but > highly appreciated. The result of the last query: At least in this example, the query appears to be fully cached and so you w

[BUGS] BUG #8130: Hashjoin still gives issues

2013-05-01 Thread stefan
The following bug has been logged on the website: Bug reference: 8130 Logged by: Stefan de Konink Email address: ste...@konink.de PostgreSQL version: 9.2.4 Operating system: Linux Description: We figured out that two very close query give a massive difference performa