Robert Treat
[EMAIL PROTECTED], [EMAIL PROTECTED]
Subject
Re: [PERFORM] vacuum full
max_fsm_pages question
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
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
Treat [EMAIL PROTECTED]
To: Patrick Hatcher [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]
Sent: Monday, September 20, 2004 11:12 PM
Subject: Re: [PERFORM] vacuum full max_fsm_pages question
On Tuesday 21 September 2004 00:01, Patrick Hatcher wrote:
Hello.
Couple of questions:
- Q1: Today I decided
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
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 itagain. I noticed that after each run the values in my
indexes and estimate row versionchanged. What really got me
wondering