Re: [HACKERS] pgstat documentation tables

2012-02-27 Thread Magnus Hagander
On Mon, Feb 27, 2012 at 04:44, Robert Haas robertmh...@gmail.com wrote: On Sat, Feb 25, 2012 at 9:33 AM, Magnus Hagander mag...@hagander.net wrote: On Mon, Jan 16, 2012 at 02:03, Greg Smith g...@2ndquadrant.com wrote: On 01/15/2012 12:20 PM, Tom Lane wrote: Please follow the style already

Re: [HACKERS] pgstat documentation tables

2012-02-27 Thread Robert Haas
On Mon, Feb 27, 2012 at 5:22 AM, Magnus Hagander mag...@hagander.net wrote: The problem with a separate column is that it makes the table very wide (some of those functions have very long name). Yeah, that's one thing I don't like about what you actually did, either - it made some of the tables

Re: [HACKERS] pgstat documentation tables

2012-02-27 Thread Magnus Hagander
On Mon, Feb 27, 2012 at 14:36, Robert Haas robertmh...@gmail.com wrote: On Mon, Feb 27, 2012 at 5:22 AM, Magnus Hagander mag...@hagander.net wrote: The problem with a separate column is that it makes the table very wide (some of those functions have very long name). Yeah, that's one thing I

Re: [HACKERS] pgstat documentation tables

2012-02-27 Thread Robert Haas
On Mon, Feb 27, 2012 at 11:32 AM, Magnus Hagander mag...@hagander.net wrote: On Mon, Feb 27, 2012 at 14:36, Robert Haas robertmh...@gmail.com wrote: On Mon, Feb 27, 2012 at 5:22 AM, Magnus Hagander mag...@hagander.net wrote: The problem with a separate column is that it makes the table very

Re: [HACKERS] pgstat documentation tables

2012-02-27 Thread Tom Lane
Robert Haas robertmh...@gmail.com writes: On Mon, Feb 27, 2012 at 11:32 AM, Magnus Hagander mag...@hagander.net wrote: On Mon, Feb 27, 2012 at 14:36, Robert Haas robertmh...@gmail.com wrote: Yeah, that's one thing I don't like about what you actually did, either - it made some of the tables

Re: [HACKERS] pgstat documentation tables

2012-02-27 Thread Magnus Hagander
On Mon, Feb 27, 2012 at 18:00, Tom Lane t...@sss.pgh.pa.us wrote: Robert Haas robertmh...@gmail.com writes: On Mon, Feb 27, 2012 at 11:32 AM, Magnus Hagander mag...@hagander.net wrote: On Mon, Feb 27, 2012 at 14:36, Robert Haas robertmh...@gmail.com wrote: Yeah, that's one thing I don't like

Re: [HACKERS] pgstat documentation tables

2012-02-27 Thread Tom Lane
Magnus Hagander mag...@hagander.net writes: On Mon, Feb 27, 2012 at 18:00, Tom Lane t...@sss.pgh.pa.us wrote: Something else to keep in mind is that PDF-format docs are not terribly forgiving of wide tables --- have you looked at what these look like in PDF? I have not, and I can't seem to

Re: [HACKERS] pgstat documentation tables

2012-02-27 Thread Magnus Hagander
On Mon, Feb 27, 2012 at 18:22, Tom Lane t...@sss.pgh.pa.us wrote: Magnus Hagander mag...@hagander.net writes: On Mon, Feb 27, 2012 at 18:00, Tom Lane t...@sss.pgh.pa.us wrote: Something else to keep in mind is that PDF-format docs are not terribly forgiving of wide tables --- have you looked

Re: [HACKERS] pgstat documentation tables

2012-02-27 Thread Tom Lane
Magnus Hagander mag...@hagander.net writes: On Mon, Feb 27, 2012 at 18:22, Tom Lane t...@sss.pgh.pa.us wrote: FWIW, I built all the back-branch versions in both US and A4 formats last week on Fedora 16.  Don't recall trying HEAD though. I only tried HEAD. Trying 9.1 now, and I get the same

Re: [HACKERS] pgstat documentation tables

2012-02-27 Thread Magnus Hagander
On Mon, Feb 27, 2012 at 18:28, Magnus Hagander mag...@hagander.net wrote: On Mon, Feb 27, 2012 at 18:22, Tom Lane t...@sss.pgh.pa.us wrote: Magnus Hagander mag...@hagander.net writes: On Mon, Feb 27, 2012 at 18:00, Tom Lane t...@sss.pgh.pa.us wrote: Something else to keep in mind is that

Re: [HACKERS] pgstat documentation tables

2012-02-27 Thread Greg Smith
On 02/27/2012 12:22 PM, Tom Lane wrote: FWIW, all the recent reports of this seem to be on Ubuntu or Debian. Don't know if that means few of us use Fedora or if it means Fedora has fixed this. I just tried building postgres-US.pdf on a RHEL-derived system, Scientific Linux 6 using

Re: [HACKERS] pgstat documentation tables (pdf OK on centos)

2012-02-27 Thread Erik Rijkers
On Mon, February 27, 2012 18:30, Magnus Hagander wrote: does that work for others, or did we break something globally in it? FWIW: I build A4 pdf's for HEAD often (say, weekly), on centos 5; it has always worked this last year or so (I did tweak tex (?) parameters, long ago). I built the A4

Re: [HACKERS] pgstat documentation tables

2012-02-27 Thread Tom Lane
Greg Smith g...@2ndquadrant.com writes: I just tried building postgres-US.pdf on a RHEL-derived system, Scientific Linux 6 using openjade-1.3.2-36.el6. That gave me lots of Overfull hbox errors, then died like this: ! pdfTeX error (ext4): \pdfendlink ended up in different nesting level

Re: [HACKERS] pgstat documentation tables

2012-02-27 Thread Tom Lane
Greg Smith g...@2ndquadrant.com writes: Here are some Debian/Ubuntu platforms that all run into the other problem: Ubuntu 9.04, openjade 1.4devel1-19: flow error Debian Squeeze, openjade 1.4devel1-19 : flow error I always assumed that the reason this didn't work, but the Fedoras did, was

Re: [HACKERS] pgstat documentation tables

2012-02-27 Thread Greg Smith
On 02/27/2012 03:39 PM, Tom Lane wrote: Greg Smithg...@2ndquadrant.com writes: Here are some Debian/Ubuntu platforms that all run into the other problem: Ubuntu 9.04, openjade 1.4devel1-19: flow error Debian Squeeze, openjade 1.4devel1-19 : flow error I always assumed that the reason this

Re: [HACKERS] pgstat documentation tables

2012-02-26 Thread Robert Haas
On Sat, Feb 25, 2012 at 9:33 AM, Magnus Hagander mag...@hagander.net wrote: On Mon, Jan 16, 2012 at 02:03, Greg Smith g...@2ndquadrant.com wrote: On 01/15/2012 12:20 PM, Tom Lane wrote: Please follow the style already used for system catalogs; ie I think there should be a summary table with

Re: [HACKERS] pgstat documentation tables

2012-02-25 Thread Magnus Hagander
On Mon, Jan 16, 2012 at 02:03, Greg Smith g...@2ndquadrant.com wrote: On 01/15/2012 12:20 PM, Tom Lane wrote: Please follow the style already used for system catalogs; ie I think there should be a summary table with one entry per view, and then a separate description and table-of-columns for

Re: [HACKERS] pgstat documentation tables

2012-02-08 Thread Bruce Momjian
On Tue, Feb 07, 2012 at 11:29:12PM -0500, Tom Lane wrote: Bruce Momjian br...@momjian.us writes: How do people feel about pulling text out of the SGML docs and loading it into the database as table and column comments? I'm not thrilled by that proposal. The length limits on comments are

Re: [HACKERS] pgstat documentation tables

2012-02-08 Thread Magnus Hagander
On Wed, Feb 8, 2012 at 17:13, Bruce Momjian br...@momjian.us wrote: On Tue, Feb 07, 2012 at 11:29:12PM -0500, Tom Lane wrote: Bruce Momjian br...@momjian.us writes: How do people feel about pulling text out of the SGML docs and loading it into the database as table and column comments? I'm

Re: [HACKERS] pgstat documentation tables

2012-02-07 Thread Bruce Momjian
On Mon, Jan 16, 2012 at 01:01:50PM -0300, Alvaro Herrera wrote: Bruce had a patch to turn SGML descriptions of system view into comments via some Perl program or something. He posted it many moons ago and I haven't seen an updated version. Bruce, do you have something to say on this

Re: [HACKERS] pgstat documentation tables

2012-02-07 Thread Tom Lane
Bruce Momjian br...@momjian.us writes: How do people feel about pulling text out of the SGML docs and loading it into the database as table and column comments? I'm not thrilled by that proposal. The length limits on comments are very much shorter than what is sensible to use in catalogs.sgml

Re: [HACKERS] pgstat documentation tables

2012-02-07 Thread Magnus Hagander
On Feb 8, 2012 5:32 AM, Tom Lane t...@sss.pgh.pa.us wrote: Bruce Momjian br...@momjian.us writes: How do people feel about pulling text out of the SGML docs and loading it into the database as table and column comments? I'm not thrilled by that proposal. The length limits on comments are

Re: [HACKERS] pgstat documentation tables

2012-01-16 Thread Alvaro Herrera
Bruce had a patch to turn SGML descriptions of system view into comments via some Perl program or something. He posted it many moons ago and I haven't seen an updated version. Bruce, do you have something to say on this topic? -- Álvaro Herrera alvhe...@commandprompt.com The PostgreSQL

Re: [HACKERS] pgstat documentation tables

2012-01-16 Thread Peter Eisentraut
On sön, 2012-01-15 at 12:20 -0500, Tom Lane wrote: Magnus Hagander mag...@hagander.net writes: Right now we have a single table on http://www.postgresql.org/docs/devel/static/monitoring-stats.html#MONITORING-STATS-VIEWS that lists all our statistics views ... I'd like to turn that into

Re: [HACKERS] pgstat documentation tables

2012-01-16 Thread Magnus Hagander
On Mon, Jan 16, 2012 at 19:41, Peter Eisentraut pete...@gmx.net wrote: On sön, 2012-01-15 at 12:20 -0500, Tom Lane wrote: Magnus Hagander mag...@hagander.net writes: Right now we have a single table on http://www.postgresql.org/docs/devel/static/monitoring-stats.html#MONITORING-STATS-VIEWS

Re: [HACKERS] pgstat documentation tables

2012-01-15 Thread Greg Smith
On 01/15/2012 03:51 AM, Magnus Hagander wrote: I'd like to turn that into one table for each view, with two columns, one being the name the other one being the description. That'll also make it possible to expand on the descriptions without making it completley unreadable, should we want to.

Re: [HACKERS] pgstat documentation tables

2012-01-15 Thread Magnus Hagander
On Sun, Jan 15, 2012 at 10:35, Greg Smith g...@2ndquadrant.com wrote: On 01/15/2012 03:51 AM, Magnus Hagander wrote: I'd like to turn that into one table for each view, with two columns, one being the name the other one being the description. That'll also make it possible to expand on the

Re: [HACKERS] pgstat documentation tables

2012-01-15 Thread Tom Lane
Magnus Hagander mag...@hagander.net writes: Right now we have a single table on http://www.postgresql.org/docs/devel/static/monitoring-stats.html#MONITORING-STATS-VIEWS that lists all our statistics views ... I'd like to turn that into one table for each view, Please follow the style already

Re: [HACKERS] pgstat documentation tables

2012-01-15 Thread Greg Smith
On 01/15/2012 12:20 PM, Tom Lane wrote: Please follow the style already used for system catalogs; ie I think there should be a summary table with one entry per view, and then a separate description and table-of-columns for each view. Yes, that's a perfect precedent. I think the easiest path