Re: [PERFORM] vacuum full max_fsm_pages question

2004-09-21 Thread Robert Treat
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

[PERFORM] Hyper threading?

2004-09-21 Thread Mariusz Czuada
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

Re: [PERFORM] vacuum full max_fsm_pages question

2004-09-21 Thread Patrick Hatcher
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

Re: [PERFORM] vacuum full max_fsm_pages question

2004-09-21 Thread 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 readd

[PERFORM] 7.4 vs 7.3 ( hash join issue )

2004-09-21 Thread Gaetano Mendola
-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