On 01/09/12 5:21 PM, Ron Somaraju wrote:
Once again, pros and cons should be left to users discretion because one may have latest and greatest hardware and network resources. For example a SSD on a fiber channel on a high speed network.
as I said before, when the checkpoint timeout goes off, a partially written WAL log will be archived. this file is still the full size, its not 'short', its just empty.
too big of a file will mean a LOT Of waste data is being copied and archived.
what is your checkpoint_timeout ? how many WAL files per that timeout interval are you generating now? (like, if the timeout is 5 minutes, and you're generating 36 files per hour, that would be about 3 WAL files per timeout interval...)
-- john r pierce N 37, W 122 santa cruz ca mid-left coast -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
