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

Re: [BUGS] BUG #8128: pg_dump (>= 9.1) failed while dumping a scheme named "old" from PostgreSQL 8.4

2013-05-01 Thread Adrian.Vondendriesch
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Am 01.05.2013 01:53, schrieb Tom Lane: > adrian.vondendrie...@credativ.de writes: >> [ recent pg_dump fails against an 8.4 server if "old" is used as >> a name ] > > Yeah. The reason for this is that "old" was considered a reserved > word in 8.4 and