User Tools

Site Tools


how_to:database_size

Differences

This shows you the differences between two versions of the page.

Link to this comparison view

Both sides previous revisionPrevious revision
Next revision
Previous revision
Next revisionBoth sides next revision
how_to:database_size [2013/08/30 13:21] – [VPOP3 Database Size] paulhow_to:database_size [2017/04/26 12:07] – [Diagnostics logs] paul
Line 23: Line 23:
 Some of the tables which are commonly large are: Some of the tables which are commonly large are:
  
-  * messages.msgdata - this contains message data in mailboxes, including recently deleted messages+  * messages.msgdata - this contains message data in mailboxes, including recently deleted messages in VPOP3 Enterprise.
   * archive.archivemain - this contains the main index for archived messages   * archive.archivemain - this contains the main index for archived messages
   * logdb.* - these tables contain data for the 'historical logging & reporting' facility in VPOP3   * logdb.* - these tables contain data for the 'historical logging & reporting' facility in VPOP3
Line 31: Line 31:
   * outqueue.outmessages - this contains messages which are currently in, or have recently been in, the VPOP3 outqueue.   * outqueue.outmessages - this contains messages which are currently in, or have recently been in, the VPOP3 outqueue.
  
 +(Also, see [[http://wiki.postgresql.org/wiki/Disk_Usage]] )
 =====Diagnostics logs===== =====Diagnostics logs=====
-The PostgreSQL database stores diagnostics logs in the VPOP3\pgsql\data\pg_log folder. PostgreSQL does not manage these logs, so more and more logs will appear over time. Usually these logs are small, so do not take up much space. It is safe to delete the files from this folder, but **not** from any other folder in the VPOP3\pgsql\data folder tree.+The PostgreSQL database stores diagnostics logs in the VPOP3\pgsql\data\pg_log folder. VPOP3 v6+ manages these log files, but PostgreSQL does not, so in older versions of VPOP3, more and more logs will appear over time. Usually these logs are small, so do not take up much space (eg on one of our busy servers, a year's worth of logs takes up about 36MB). It is safe to delete the files from this folder, but **not** from any other folder in the VPOP3\pgsql\data folder tree.
  
how_to/database_size.txt · Last modified: 2018/11/14 10:45 by 127.0.0.1