Search Postgresql Archives

Re: I don't want to back up index files

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

 



Tom Lane wrote:
Glen Parker <glenebob@xxxxxxxxxx> writes:
Tom Lane wrote:
... AFAICS what
Glen is proposing is to not WAL-log index changes, and with that any
crash no matter how minor would have to invalidate indexes.

Nooo...!  This has nothing to do with WAL logging index changes.

How so?  In any PITR-based situation it seems to me you need to worry
about the WAL bulk a lot more than the bulk of the base backup.


It isn't the bulk so much as the amount of time, and the impact to the running system during that time, that it takes to execute the base backup.

I haven't noticed any real impact related to compressing and exporting WAL files.

Anyway, more to the point, I'm not knowingly proposing anything that should cause reduced system reliability in the event of a crash.

-Glen


--
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general

[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