Re: [PERFORM] vacuum full & max_fsm_pages question

2004-09-23 Thread Patrick Hatcher
lt;[EMAIL PROTECTED]> cc "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 ba

Re: [PERFORM] vacuum full & max_fsm_pages question

2004-09-21 Thread Patrick Hatcher
<[EMAIL PROTECTED]> 09/21/2004 10:49 Subject AMRe: [PERFORM] vacuum full &

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 r

Re: [PERFORM] vacuum full & max_fsm_pages question

2004-09-21 Thread Patrick Hatcher
uot;Robert 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 wr

Re: [PERFORM] vacuum full & max_fsm_pages question

2004-09-20 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 an

[PERFORM] vacuum full & max_fsm_pages question

2004-09-20 Thread Patrick Hatcher
  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 estimate row version changed.  What really got me wond