This shows you the differences between two versions of the page.
Next revision | Previous revisionNext revisionBoth sides next revision | ||
how_to:database_size [2013/08/30 13:20] – created paul | how_to:database_size [2017/04/26 12:07] – [Diagnostics logs] paul | ||
---|---|---|---|
Line 3: | Line 3: | ||
If you are concerned about the size of the VPOP3 database, there are several factors which may make the database larger than you would expect: | If you are concerned about the size of the VPOP3 database, there are several factors which may make the database larger than you would expect: | ||
- | * The VPOP3 database contains a lot more information than just messages in mailboxes. | + | * The VPOP3 database contains a lot more information than just messages in mailboxes. |
* The database has many indexes to speed up access to data, these take up extra space | * The database has many indexes to speed up access to data, these take up extra space | ||
* As with most database systems, when an entry is deleted, the free space is not returned to Windows, but is simply marked as free, and will be reused | * As with most database systems, when an entry is deleted, the free space is not returned to Windows, but is simply marked as free, and will be reused | ||
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. |