Index: doc/src/sgml/diskusage.sgml
===================================================================
RCS file: /cvsroot/pgsql/doc/src/sgml/diskusage.sgml,v
retrieving revision 1.1
diff -c -r1.1 diskusage.sgml
*** doc/src/sgml/diskusage.sgml 13 Jun 2002 05:15:22 -0000 1.1
--- doc/src/sgml/diskusage.sgml 21 Jun 2002 19:06:03 -0000
***************
*** 22,31 ****
! You can monitor disk space from two places; from inside
! psql> and from the command line using
! contrib/oid2name>. Using psql> you can
! issue queries to see the disk usage for any table:
play=# SELECT relfilenode, relpages
play-# FROM pg_class
--- 22,33 ----
! You can monitor disk space from three places: from
! psql> using VACUUM> information, from
! psql> using contrib/dbsize>, and from
! the command line using contrib/oid2name>. Using
! psql> on a recently vacuumed (or analyzed) database,
! you can issue queries to see the disk usage of any table:
play=# SELECT relfilenode, relpages
play-# FROM pg_class
***************
*** 38,47 ****
! Each page is typically 8 kilobytes. relpages> is only
! updated by VACUUM> and ANALYZE>. To show the
! space used by TOAST> tables, use a query based on the heap
! relfilenode:
play=# SELECT relname, relpages
play-# FROM pg_class
--- 40,49 ----
! Each page is typically 8 kilobytes. (Remember, relpages>
! is only updated by VACUUM> and ANALYZE>.) To
! show the space used by TOAST> tables, use a query based on
! the heap relfilenode shown above:
play=# SELECT relname, relpages
play-# FROM pg_class
Index: doc/src/sgml/indices.sgml
===================================================================
RCS file: /cvsroot/pgsql/doc/src/sgml/indices.sgml,v
retrieving revision 1.33
diff -c -r1.33 indices.sgml
*** doc/src/sgml/indices.sgml 21 Jun 2002 16:52:00 -0000 1.33
--- doc/src/sgml/indices.sgml 21 Jun 2002 19:06:04 -0000
***************
*** 181,190 ****
! Testing has shown hash indexes to be similar or slower than btree
! indexes, and the index size and build time for hash indexes is much
! worse. Hash indexes also suffer poor performance under high
! concurrency. For these reasons, hash index use is discouraged.
--- 181,191 ----
! Testing has shown PostgreSQL's hash indexes to be similar or slower
! than btree indexes, and the index size and build time for hash
! indexes is much worse. Hash indexes also suffer poor performance
! under high concurrency. For these reasons, hash index use is
! discouraged.
Index: doc/src/sgml/ref/create_index.sgml
===================================================================
RCS file: /cvsroot/pgsql/doc/src/sgml/ref/create_index.sgml,v
retrieving revision 1.33
diff -c -r1.33 create_index.sgml
*** doc/src/sgml/ref/create_index.sgml 21 Jun 2002 16:52:00 -0000 1.33
--- doc/src/sgml/ref/create_index.sgml 21 Jun 2002 19:06:05 -0000
***************
*** 330,339 ****
the = operator.
! Testing has shown hash indexes to be similar or slower than btree
! indexes, and the index size and build time for hash indexes is much
! worse. Hash indexes also suffer poor performance under high
! concurrency. For these reasons, hash index use is discouraged.
--- 330,340 ----
the = operator.
! Testing has shown PostgreSQL's hash indexes to be similar or slower
! than btree indexes, and the index size and build time for hash
! indexes is much worse. Hash indexes also suffer poor performance
! under high concurrency. For these reasons, hash index use is
! discouraged.