Search Postgresql Archives

Re: turn WAL off.

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

 



tom lane writes:
> To be blunt, you don't want Postgres.  Consider Berkeley DB or tinysql
> or (holds nose) MySQL.  What you're after isn't
> within the design goals for this project, either
> as to disk footprint or disinterest in power
> failure behavior.

Or, put the WAL files on a RAM disk (/tmp under Solaris, dunno for Linux). Soft links would do the trick nicely. Make sure that you understand that shutting down the machine, even cleanly, will likely destroy your Pg installation.

I have actually done this temporarily during emergency Oracle recovery, when it was important to minimuze reload time. If the machine crashed during the reload, I didn't really lose that much.


---------------------------(end of broadcast)--------------------------- TIP 7: 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