At 02:36 AM 5/4/00 -0300, The Hermit Hacker wrote:
>One thing that would be nice (who wrote these stats?) would be some way to
>be able to determine a suitable setting for -S from this ... someway to
>know that an ORDER BY needed to swap to disk because it needed 32Meg when
>only 16Meg was allocated for it ... would help give an indication where
>performance could be improved by either just raising -S (in Mitch's case,
>where lots of RAM is available) or more RAM should be added ...
It would also be nice to be able to get at these via SQL, ala Oracle.
Then toolkits like OpenACS could easily generate administration pages
that present the stats nicely to webmasters, including perhaps
putting up links to help page. If sorting is going to disk,
a link to a short pages dicussing raising -S could be put up.
ACS Classic, the Oracle version, has admin pages (without help,
it points you to a bookshelf of Oracle DBA books instead) which
display stats, etc and it is very useful.
A lot of folks using toolkits like this will simply customize
look and feel of the web pages and at first, at least, won't
know much or anything about SQL or Postgres and need all the
help we can give them.
- Don Baccus, Portland OR <dhogaza@pacifier.com> Nature photos, on-line guides, Pacific Northwest Rare Bird Alert
Serviceand other goodies at http://donb.photo.net.