pg.ddx.io pgsql-docs@postgresql.org mailing list archive
help / color / mirror / Atom feedExample is too wide
4+ messages / 2 participants
[nested] [flat]
* Example is too wide
@ 2001-11-05 20:04 Peter Eisentraut <peter_e@gmx.net>
2001-11-05 23:15 ` Re: Example is too wide Tom Lane <tgl@sss.pgh.pa.us>
0 siblings, 1 reply; 4+ messages in thread
From: Peter Eisentraut @ 2001-11-05 20:04 UTC (permalink / raw)
To: pgsql-docs
Could someone pick a different example for the pg_stats values in UG
section 11.2, especially one that is significantly narrower than 396
columns?
If possible, format verbatim environments to be at most 80 characters wide
so they look nicely in print output. It's possible to scale the fonts
down automatically so they fit, but that obviously only works within
reason.
--
Peter Eisentraut peter_e@gmx.net http://funkturm.homeip.net/~peter
^ permalink raw reply [nested|flat] 4+ messages in thread
* Re: Example is too wide
2001-11-05 20:04 Example is too wide Peter Eisentraut <peter_e@gmx.net>
@ 2001-11-05 23:15 ` Tom Lane <tgl@sss.pgh.pa.us>
2001-11-07 17:27 ` Re: Example is too wide Peter Eisentraut <peter_e@gmx.net>
0 siblings, 1 reply; 4+ messages in thread
From: Tom Lane @ 2001-11-05 23:15 UTC (permalink / raw)
To: Peter Eisentraut <peter_e@gmx.net>; +Cc: pgsql-docs
Peter Eisentraut <peter_e@gmx.net> writes:
> Could someone pick a different example for the pg_stats values in UG
> section 11.2, especially one that is significantly narrower than 396
> columns?
> If possible, format verbatim environments to be at most 80 characters wide
> so they look nicely in print output.
It's going to be difficult to produce any 80-col-wide examples of any
of the interesting columns in pg_stats. How do you feel about
artificially line-breaking the printout?
regards, tom lane
^ permalink raw reply [nested|flat] 4+ messages in thread
* Re: Example is too wide
2001-11-05 20:04 Example is too wide Peter Eisentraut <peter_e@gmx.net>
2001-11-05 23:15 ` Re: Example is too wide Tom Lane <tgl@sss.pgh.pa.us>
@ 2001-11-07 17:27 ` Peter Eisentraut <peter_e@gmx.net>
2001-11-07 17:48 ` Re: Example is too wide Tom Lane <tgl@sss.pgh.pa.us>
0 siblings, 1 reply; 4+ messages in thread
From: Peter Eisentraut @ 2001-11-07 17:27 UTC (permalink / raw)
To: Tom Lane <tgl@sss.pgh.pa.us>; +Cc: pgsql-docs
Tom Lane writes:
> It's going to be difficult to produce any 80-col-wide examples of any
> of the interesting columns in pg_stats. How do you feel about
> artificially line-breaking the printout?
I tried the example query on the tenk1 table and got a pretty good output.
Not only is it only 120 columns, which makes it fit really well into the
HTML browser window (mine anyway), it also contains more diverse rows
which can serve the example, e.g., output for unique columns, and a few
interesting n_distinct values. I'm tempted to use that one instead.
--
Peter Eisentraut peter_e@gmx.net
^ permalink raw reply [nested|flat] 4+ messages in thread
* Re: Example is too wide
2001-11-05 20:04 Example is too wide Peter Eisentraut <peter_e@gmx.net>
2001-11-05 23:15 ` Re: Example is too wide Tom Lane <tgl@sss.pgh.pa.us>
2001-11-07 17:27 ` Re: Example is too wide Peter Eisentraut <peter_e@gmx.net>
@ 2001-11-07 17:48 ` Tom Lane <tgl@sss.pgh.pa.us>
0 siblings, 0 replies; 4+ messages in thread
From: Tom Lane @ 2001-11-07 17:48 UTC (permalink / raw)
To: Peter Eisentraut <peter_e@gmx.net>; +Cc: pgsql-docs
Peter Eisentraut <peter_e@gmx.net> writes:
> Tom Lane writes:
>> It's going to be difficult to produce any 80-col-wide examples of any
>> of the interesting columns in pg_stats. How do you feel about
>> artificially line-breaking the printout?
> I tried the example query on the tenk1 table and got a pretty good output.
> Not only is it only 120 columns, which makes it fit really well into the
> HTML browser window (mine anyway), it also contains more diverse rows
> which can serve the example, e.g., output for unique columns, and a few
> interesting n_distinct values. I'm tempted to use that one instead.
Well, the thing is that tenk1 is completely artificial data, so the
stats it produces are a tad on the meaningless/uninteresting side.
AFAICT the "road" table is the only realistic sample data we have in
the distribution.
However, I won't argue the point too hard. If the tenk1 example works
from a formatting point of view, go with it.
regards, tom lane
^ permalink raw reply [nested|flat] 4+ messages in thread
end of thread, other threads:[~2001-11-07 17:48 UTC | newest]
Thread overview: 4+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2001-11-05 20:04 Example is too wide Peter Eisentraut <peter_e@gmx.net>
2001-11-05 23:15 ` Tom Lane <tgl@sss.pgh.pa.us>
2001-11-07 17:27 ` Peter Eisentraut <peter_e@gmx.net>
2001-11-07 17:48 ` Tom Lane <tgl@sss.pgh.pa.us>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox