On Wed, 22 Sep 2004, Gaetano Mendola wrote:
> Now my question is why the 7.4 choose the hash join ? :-(
It looks to me that the marge join is faster because there wasn't really
anything to merge, it resulted in 0 rows. Maybe the hash join that is
choosen in 7.4 would have been faster had there
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Hi all,
I'm having performance degradation with a view upgrading from
7.3 to 7.4, the view is a not so complex, one of his field
is the result from a function.
If I remove the function ( or I use a void function ) the 7.4
out perform the 7.3:
On 7.4 I g
Nope. It's been running like a champ for while now.
Patrick Hatcher
Macys.Com
Legacy Integration Developer
415-422-1610 office
HatcherPT - AIM
Josh Berkus
Patrick,
> Sorry. I wrote PG 7.4.2 and then I erased it to write something else and
> then forgot to add it back.
Odd. You shouldn't be having to re-vacuum on 7.4.
> And thanks for the Page info. I was getting frustrated and looked in the
> wrong place.
>
> So it's probably best to drop and r
Sorry. I wrote PG 7.4.2 and then I erased it to write something else and
then forgot to add it back.
And thanks for the Page info. I was getting frustrated and looked in the
wrong place.
So it's probably best to drop and readd the indexes then?
- Original Message -
From: "Robert Trea
Hi all,
I searched list archives, but did not found anything about HT of Pentium
4/Xeon processors. I wonder if hyperthreading can boost or decrease
performance. AFAIK for other commercial servers (msssql, oracle) official
documents state something like "faster, but not always, so probably slow
