Search Postgresql Archives

Re: WAL archiving idle database

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



Simon Riggs <simon@xxxxxxxxxxxxxxx> writes:
> We *could* force it to perform a log switch whether or not new WAL has
> been written.

That would be a truly awful idea.

I think the right answer for Kevin's situation really is to be doing a
dummy transaction every few minutes as one component of his system
monitoring.  That way he gets the behavior he wants, and it needn't
preclude us from fixing the default behavior to be less wasteful.

			regards, tom lane

---------------------------(end of broadcast)---------------------------
TIP 5: don't forget to increase your free space map settings

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux