This shows you the differences between two versions of the page.
Next revision | Previous revisionNext revisionBoth sides next revision | ||
how_to:delete_outqueue_messages_directly_from_the_database [2014/01/03 09:23] – created paul | how_to:delete_outqueue_messages_directly_from_the_database [2014/06/10 11:30] – external edit 127.0.0.1 | ||
---|---|---|---|
Line 21: | Line 21: | ||
The three most common causes of unwanted messages in the OutQueue are: | The three most common causes of unwanted messages in the OutQueue are: | ||
- | | + | |
- | | + | |
- | | + | |
====To delete the messages==== | ====To delete the messages==== | ||
Line 38: | Line 38: | ||
etc. | etc. | ||
- | After deleting the messages, you may want to shrink the disk file, otherwise there will be a lot of wasted disk space. To do this, at the psql prompt, do: | + | After deleting the messages, you may want to shrink the disk file, otherwise there may be a lot of wasted disk space if you have deleted an extremely large number of messages. To do this, at the psql prompt, do: |
'' | '' | ||
CLUSTER VERBOSE outqueue.outrecipients;'' | CLUSTER VERBOSE outqueue.outrecipients;'' | ||