On Tuesday 21 September 2004 00:01, Patrick Hatcher wrote:
Hello.
Couple of questions:
- Q1: Today I decided to do a vacuum full verbose analyze on a large table
that has been giving me slow performance. And then I did it again. I
noticed that after each run the values in my indexes and
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
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
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 readd
-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