This shows you the differences between two versions of the page.
Both sides previous revisionPrevious revisionNext revision | Previous revisionNext revisionBoth sides next revision | ||
how_to:database_size [2013/08/30 13:21] – [VPOP3 Database Size] paul | how_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 |
* 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 ' | * logdb.* - these tables contain data for the ' | ||
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:// | ||
=====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. |