summaryrefslogtreecommitdiffstats
path: root/FAQ
diff options
context:
space:
mode:
authorMark Wong <markwkm@gmail.com>2013-04-19 20:04:17 -0700
committerMark Wong <markwkm@gmail.com>2013-04-19 20:04:17 -0700
commit2f50bc2ffdd48fb4aff79b3c66051fe020837696 (patch)
treed11abf3d7ef38ce41e3fe50e037d97e92ebfd009 /FAQ
parentfb92cdd1c70b527ccb6091f327e0e75a0b194eea (diff)
Update docs and man pages
Diffstat (limited to 'FAQ')
-rw-r--r--FAQ218
1 files changed, 21 insertions, 197 deletions
diff --git a/FAQ b/FAQ
index 32583bc..c9093a7 100644
--- a/FAQ
+++ b/FAQ
@@ -1,9 +1,8 @@
- pg_top
- Version 3.7.0
+ pg_top
+ Version 3.7.0
- Mark Wong
- Frequently Asked Questions and their Answers
+ Frequently Asked Questions and their Answers
@@ -11,8 +10,8 @@
1. What is pg_top?
- pg_top is 'top' for PostgreSQL. It is derived from Unix Top. Similar to top,
- pg_top allows you to monitor PostgreSQL processes. It also allows you to:
+ pg_top is 'top' for PostgreSQL. It is derived from Unix Top. Similar to top,
+ pg_top allows you to monitor PostgreSQL processes. It also allows you to:
* View currently running SQL statement of a process.
* View query plan of a currently running SELECT statement.
@@ -22,39 +21,31 @@
2. Where do I get the latest version of pg_top?
- If you have mercurial, you can download the latest version from
- SourceForge:
-
- hg clone http://ptop.sourceforge.net/cgi-bin/hgwebdir.cgi/pg_top
+ If you have git, you can checkout the latest at:
+
+ git clone git://git.postgresql.org/git/pg_top.git
3. Is there a web page for pg_top?
- http://ptop.projects.postgresql.org/
+ http://ptop.projects.postgresql.org/
4. Is there a mailing list or on-line bulletin board for pg_top?
- Subscribe or browse the archives of ptop-hackers at:
+ Subscribe or browse the archives of ptop-hackers at:
- http://lists.pgfoundry.org/mailman/listinfo/ptop-hackers
+ http://lists.pgfoundry.org/mailman/listinfo/ptop-hackers
5. What about Y2K/Year 2038 compliance?
- A full statement concerning top and the year 2000 can be found in the file
- "Y2K" included with the distribution.
+ A full statement concerning top and the year 2000 can be found in the file
+ "Y2K" included with the distribution.
6. Will there be another major release of pg_top? Will there be a pg_top
version 4?
We hope so! Depends on how much fun we have. :)
- 7. Is top under CVS control? Can I access the sources via SourceForge
- CVS or Subversion?
-
- I maintain top using mercurial, not CVS. See FAQ #2.
-
- COMPILING
-
- 8. We just upgraded our operating system to a new version and pg_top broke.
+ 7. We just upgraded our operating system to a new version and pg_top broke.
What should we do?
Recompile it. pg_top is very sensitive to changes in internal kernel
@@ -64,7 +55,7 @@
RUNNING
-10. I just finished compiling top and it works fine for root, but when I
+ 8. I just finished compiling top and it works fine for root, but when I
try to run it as a regular user it either complains about files it
can't open or it doesn't display all the information it should. Did I
do something wrong?
@@ -77,193 +68,26 @@
However, you have to *install* it first. Do this with the command
"make install".
-11. pg_top is (not) displaying idle processes and I don't (do) want it to.
+ 9. pg_top is (not) displaying idle processes and I don't (do) want it to.
This default has only changed about a dozen times, and I finally got
tired of people whining about it. Go read the manual page for the
current version and pay special attention to the description of the
"PG_TOP" environment variable.
-12. We have so much memory in our machine that the memory status display
- (the fourth line) ends up being longer than 80 characters. This
- completely messes up top's output. Is there a patch?
-
- Most modules have been changed to use new memory formatting functions
- which will display large values in terms of megabytes instead of
- kilobytes. This should fix all occurences of this problem. Also note
- that newer versions of top can use columns beyond 79, and understand
- window resizes. So you can always make your window wider.
-
-13. I tried to compile top with gcc and it doesn't work. I get
- compilation errors in the include files, or I get an executable that
- dumps core, or top displays incorrect numbers in some of the
- displays. What's wrong?
-
- Gnu CC likes very much to use its own include files. Not being a gcc
- expert, I can't explain why it does this. But I can tell you that if
- you upgrade your operating system (say from Solaris 2.6 to Solaris
- 2.7) after installing gcc, then the include files that gcc uses will
- be incorrect, especially those found in the "sys" directory. Your
- choices are: (1) rebuild and reinstall the "standard" include files
- for gcc (look for scripts in the distribution called "fixincludes"
- and "fixinc.svr4"), (2) compile machine.c with
- "CFLAGS=-I/usr/include" then make the rest of the object files
- normally, or (3) use a different compiler.
-
-14. The cpu state percentages are all wrong, indicating that my machine
+10. The cpu state percentages are all wrong, indicating that my machine
is using 95% system time when it is clearly idle. What's wrong?
This can happen if you compiled with gcc using the wrong include
files. See the previous question.
- SUNOS PROBLEMS
-
-15. I tried compiling top under SunOS version 4.1.x and it got compile
- time errors or run time errors. Is there a patch?
-
- If you try compiling top in a "System V environment" under SunOS
- (that is, /usr/5bin is before /usr/bin on your path) then the
- compilation may fail. This is mostly due to the fact that top thinks
- its being compiled on a System V machine when it really isn't. The
- only solution is to put /usr/bin and /usr/ucb before /usr/5bin on
- your path and try again.
-
-
- SOLARIS PROBLEMS
-
-
- NOTE: the most common source of problems with top under Solaris is
- the result of compiling it with the wrong front end. Make sure that
- /usr/ucb is not on your path before attempting to compile top under
- Solaris.
-
-16. Is there somewhere I can get a pre-compiled package?
-
- Yes. Although I don't provide pre-compiled binaries, you can get a
- Sun-style package from www.sunfreeware.com.
-
-17. Under Solaris 2, when I type "make", the system says "language
- optional software package not installed." What's going on?
-
- You tried to compile with /usr/ucb/cc. Make sure /usr/ucb is not on
- your path. Furthermore, you do not have a Sun compiler installed on
- your system. You need a compiler to make top. Either Sun's C compiler
- or the Gnu C compiler will work fine.
-
-18. Under Solaris 2, when I run top as root it only shows root processes,
- or it only shows processes with a PID less than 1000. It refuses to
- show anything else. What do I do?
-
- You probably compiled it with /usr/ucb/cc instead of the real C
- compiler. /usr/ucb/cc is a cc front end that compiles programs in BSD
- source-level compatability mode. You do not want that. Make sure that
- /usr/ucb is not on your path and try compiling top again.
-
-19. Under Solaris 2, I compiled top using what I am sure is the correct
- compiler but when I try to run it it complains about missing dynamic
- libraries. What is wrong?
-
- Check to see if you have LD_LIBRARY_PATH defined in your shell. If
- you do, make sure that /usr/ucblib is not on the path anywhere. Then
- try compiling top again.
-
-20. Under Solaris 2, when I try to run top it complains that it can't
- open the library "libucb.so.1". So I changed the LIBS line in
- m_sunos5.c to include -R/usr/ucblib to make sure that the dynamic
- linker will look there when top runs. I figured this was just an
- oversight. Was I right?
-
- No, you were not right. As distributed, top requires no alterations
- for successful compilation and operations under any release of
- Solaris 2. You probably compiled top with /usr/ucb/cc instead of the
- real C compiler. See FAQ 22 for more details.
-
-21. On my 64-bit system some processes show up with incorrect information
- (such as zero memory).
-
- If you are running a 64-bit system, then you will want to make a
- 64-bit top binary. pg_top's configure script attempts to detect 64-bit
- systems, and will adjust the compilation options accordingly. If you
- configure and make a binary on a 32-bit system it will still run on a
- 64-bit system, but may not produce the correct results. The same will
- happen if you configure your distribution on a 32-bit system then
- compile with that configuration on a 64-bit system. You must
- configure and compile on the same system.
-
-22. Can I install both 32-bit and 64-bit binaries on a central file
- server and have machines which mount it automatically use the correct
- one?
-
- Yes. First, compile a 32-bit version and name it top32. Then compile
- a 64-bit version (see FAQ #22) and name it top64. Make sure each
- binary has the correct ownership and mode. Choose your bin directory
- (we will refer to that as $BIN). In $BIN make sure there are
- subdirectories named "sparcv7" and "sparcv9". If they don't exist
- then create them. Copy "top32" to "$BIN/sparcv7/top" and "top64" to
- "$BIN/sparcv9/top". Finally copy (do not link) the binary
- /usr/lib/isaexec to "$BIN/top". When a user runs "top" she will
- actually be running a copy of isaexec. This tool will automatically
- determine the kernel type and run the top "binary" out of the correct
- subdirectory.
-
-23. This version of top show less available swap space than previous
- versions. Why does it no longer match the output of the swap summary
- produced with "swap -s"?
-
- Starting with version 3.6 of top, the amount of swap space reported
- by top has been changed to reflect only disk-based swap space. The
- swap summary produced with "swap -s" also include memory-based swap
- space. This changed was mae for several reasons. It makes the display
- under Solaris more like those of other operating systems. The display
- is more what users expect (except those used to previous versions of
- top). Most importantly, "swap -s" gets its data via an undocumented
- system interface. Now that top no longer displays that data it can
- use publically documented and maintained system interfaces to
- retrieve its data.
-
-
- SVR4-DERIVED PROBLEMS
-
-24. When I run top on my SVR4-derived operating system, it displays all
- the system information at the top but does not display any process
- information (or only displays process information for my own
- processes). Yet when I run it as root, everything works fine. What's
- wrong?
-
- Your system probably uses the pseudo file system "/proc", which is by
- default only accessible by root. pg_top needs to be installed setuid
- root on such systems if it is going to function correctly for normal
- users.
-
-
- SVR42 PROBLEMS
-
-25. The memory display doesn't work right. Why?
-
- This is a known bug with the svr42 module. The problem has been
- traced down to a potential bug in the "mem" driver. The author of the
- svr42 module is working on a fix.
-
-
STILL STUCK
-26. I'm still stuck. To whom do I report problems with top?
-
- The most common problems are caused by top's sensitivity to internal
- kernel data structures. So make sure that you are using the right
- include files, and make sure that you test out top on the same
- machine where you compiled it. Sun's BSD Source Compatability Mode is
- also a common culprit. Make sure you aren't using either /usr/ucb/cc
- or any of the libraries in /usr/ucblib. Finally, make sure you are
- using the correct module. If there does not appear to be one
- appropriate for your computer, then top probably will not work on
- your system.
+11. I'm still stuck. To whom do I report problems with top?
If after reading all of this file and checking everything you can you
- are still stuck, then please use SourceForge to submit a support
- request or a bug. pg_top is supported by the SourceForge project named
- "unixtop". On SourceForge you will find defect tracking, a mailing
- list, and on-line forums. You can also contact the author through
- SourceForge.
+ are still stuck, then please refer to the mailing to ask further
+ questions:
+ http://lists.pgfoundry.org/mailman/listinfo/ptop-hackers