Re: [DOCS] vacuum and routine maintenance docs

2006-06-07 Thread Bruce Momjian
Any progress on this? --- Scott Marlowe wrote: > After the most recent post on the general mailing list by someone who > was a bit confused by postgresql's vacuuming and use of the free space > map, I've been reviewing the p

Re: [DOCS] vacuum and routine maintenance docs

2006-03-13 Thread Scott Marlowe
Sorry for the long delay. 1: We've been busy as a one legged man in a butt kicking contest at work and 2: My laptop, which I use for all this kind of stuff, died and I just got it back a week ago. I will work on it this week, promise. On Thu, 2006-03-02 at 15:42, Bruce Momjian wrote: > Any upd

Re: [DOCS] vacuum and routine maintenance docs

2006-03-02 Thread Bruce Momjian
Any update on this effort? --- Scott Marlowe wrote: > After the most recent post on the general mailing list by someone who > was a bit confused by postgresql's vacuuming and use of the free space > map, I've been reviewing

Re: [DOCS] vacuum and routine maintenance docs

2006-01-19 Thread Tom Lane
Scott Marlowe <[EMAIL PROTECTED]> writes: > Yeah, I keep thinking more and more we need a LOT of linkable resources > for this, much like the ones we have for all the standard command > reference stuff. I'm leaning towards having the main page of each of > these things be somewhat closer to an exe

Re: [DOCS] vacuum and routine maintenance docs

2006-01-19 Thread Jim C. Nasby
On Thu, Jan 19, 2006 at 10:15:19AM -0600, Scott Marlowe wrote: > I agree completely. We don't probably need it in sgml just yet. From a Actually, I was looking for how to get the view out of the existing SGML ;) In any case, I think admin is probably broad enough that there won't be much overlap

Re: [DOCS] vacuum and routine maintenance docs

2006-01-19 Thread Jim C. Nasby
On Thu, Jan 19, 2006 at 06:00:36PM +0100, Peter Eisentraut wrote: > Am Donnerstag, 19. Januar 2006 02:31 schrieb Jim C. Nasby: > > Is there an easy way to get a 2-level outline out of the sgml? > > How would you define the TOC that we currently produce? Sorry, I guess what I was actually thinking

Re: [DOCS] vacuum and routine maintenance docs

2006-01-19 Thread Scott Marlowe
On Thu, 2006-01-19 at 16:00, Jim C. Nasby wrote: > On Thu, Jan 19, 2006 at 10:15:19AM -0600, Scott Marlowe wrote: > > I agree completely. We don't probably need it in sgml just yet. From a > > Actually, I was looking for how to get the view out of the existing SGML > ;) In any case, I think admi

Re: [DOCS] vacuum and routine maintenance docs

2006-01-19 Thread Peter Eisentraut
Am Donnerstag, 19. Januar 2006 02:31 schrieb Jim C. Nasby: > Is there an easy way to get a 2-level outline out of the sgml? How would you define the TOC that we currently produce? -- Peter Eisentraut http://developer.postgresql.org/~petere/ ---(end of broadcast)-

Re: [DOCS] vacuum and routine maintenance docs

2006-01-19 Thread Scott Marlowe
On Wed, 2006-01-18 at 19:31, Jim C. Nasby wrote: > On Wed, Jan 18, 2006 at 08:19:16PM -0500, Tom Lane wrote: > > "Jim C. Nasby" <[EMAIL PROTECTED]> writes: > > > I'm wondering if people feel this is an issue with the docs in general > > > and isn't limited to just the admin stuff? > > > > Probably

Re: [DOCS] vacuum and routine maintenance docs

2006-01-19 Thread Neil Conway
On Wed, 2006-01-18 at 17:24 -0800, Joshua D. Drake wrote: > Why is Managing Database and Routine Database Management separate? I assume you mean the "Managing Databases" and "Routine Database Maintenance Tasks" chapters. I think these chapters are separate because they address fairly different sub

Re: [DOCS] vacuum and routine maintenance docs

2006-01-18 Thread Jim C. Nasby
On Wed, Jan 18, 2006 at 08:19:16PM -0500, Tom Lane wrote: > "Jim C. Nasby" <[EMAIL PROTECTED]> writes: > > I'm wondering if people feel this is an issue with the docs in general > > and isn't limited to just the admin stuff? > > Probably, but the admin stuff seems to suffer worst. In any case, Sc

Re: [DOCS] vacuum and routine maintenance docs

2006-01-18 Thread Joshua D. Drake
I know I certainly have trouble finding things... I generally look for stuff by going to the appropriate page in the SQL syntax section and seeing what it links too, but of course there's a lot of things that aren't (and shouldn't be) linked to from there... I find that it is generally difficu

Re: [DOCS] vacuum and routine maintenance docs

2006-01-18 Thread Tom Lane
"Jim C. Nasby" <[EMAIL PROTECTED]> writes: > I'm wondering if people feel this is an issue with the docs in general > and isn't limited to just the admin stuff? Probably, but the admin stuff seems to suffer worst. In any case, Scott volunteered to look at redoing that part, and I'm not going to r

Re: [DOCS] vacuum and routine maintenance docs

2006-01-18 Thread Jim C. Nasby
On Wed, Jan 18, 2006 at 07:55:07PM -0500, Tom Lane wrote: > Scott Marlowe <[EMAIL PROTECTED]> writes: > > Well, I'm kind of tempted to rewrite the whole section. I'd like to > > come up with some objectives of what we're trying to cover there, and > > basically start over with all the information

Re: [DOCS] vacuum and routine maintenance docs

2006-01-18 Thread Tom Lane
Scott Marlowe <[EMAIL PROTECTED]> writes: > Well, I'm kind of tempted to rewrite the whole section. I'd like to > come up with some objectives of what we're trying to cover there, and > basically start over with all the information that's there plus the > other stuff on fsm and mvcc as it applies

Re: [DOCS] vacuum and routine maintenance docs

2006-01-18 Thread Jeff Frost
On Wed, 18 Jan 2006, Scott Marlowe wrote: Well, I'm kind of tempted to rewrite the whole section. I'd like to come up with some objectives of what we're trying to cover there, and basically start over with all the information that's there plus the other stuff on fsm and mvcc as it applies to va

Re: [DOCS] vacuum and routine maintenance docs

2006-01-18 Thread Scott Marlowe
On Wed, 2006-01-18 at 16:19, Jim C. Nasby wrote: > On Tue, Jan 17, 2006 at 04:59:29PM -0600, Scott Marlowe wrote: > > Thanks. Yeah, I'm thinking more of a very brief mention of what the FSM > > is, with a link to the other part of the docs that discuss it. And then > > having a link (possibly in

Re: [DOCS] vacuum and routine maintenance docs

2006-01-18 Thread Jim C. Nasby
On Tue, Jan 17, 2006 at 04:59:29PM -0600, Scott Marlowe wrote: > Thanks. Yeah, I'm thinking more of a very brief mention of what the FSM > is, with a link to the other part of the docs that discuss it. And then > having a link (possibly in both places) or two to more in depth articles > on fsm an

Re: [DOCS] vacuum and routine maintenance docs

2006-01-17 Thread Jim C. Nasby
Sounds good. The articles are part of a Pervasive newsletter, hosted on pervasive-postgres.com, but they can get posted else where with proper attribution. On Tue, Jan 17, 2006 at 04:59:29PM -0600, Scott Marlowe wrote: > Thanks. Yeah, I'm thinking more of a very brief mention of what the FSM > is

Re: [DOCS] vacuum and routine maintenance docs

2006-01-17 Thread Scott Marlowe
Thanks. Yeah, I'm thinking more of a very brief mention of what the FSM is, with a link to the other part of the docs that discuss it. And then having a link (possibly in both places) or two to more in depth articles on fsm and fsm tuning. On Tue, 2006-01-17 at 16:49, Jim C. Nasby wrote: > Befor

Re: [DOCS] vacuum and routine maintenance docs

2006-01-17 Thread Jim C. Nasby
Before you 'put pen to paper', I have two articles that you should look at. One is on FSM, the other is more about MVCC from the standpoint of why we use it and why it means needing to vacuum. I don't have the URL's handy here, but I can post them tomorrow. On Tue, Jan 17, 2006 at 11:14:09AM -0600

Re: [DOCS] vacuum and routine maintenance docs

2006-01-17 Thread Alvaro Herrera
Scott Marlowe wrote: > 1: Is there already a newer version in CVS? Should I check out the > docs/src directory from there to start? Or can I just go on what's in > the 8.1 release? I suggest you look at http://developer.postgresql.org/cvsweb.cgi/pgsql/doc/ Those are the latest versions of t

[DOCS] vacuum and routine maintenance docs

2006-01-17 Thread Scott Marlowe
After the most recent post on the general mailing list by someone who was a bit confused by postgresql's vacuuming and use of the free space map, I've been reviewing the page on routine maintenance. It's pretty obvious that this page was originally written for an older version of PostgreSQL and ha