| From: | Bruce Momjian <bruce(at)momjian(dot)us> |
|---|---|
| To: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
| Cc: | Aidan Van Dyk <aidan(at)highrise(dot)ca>, Greg Smith <gsmith(at)gregsmith(dot)com>, Kyle Cordes <kyle(at)kylecordes(dot)com>, PostgreSQL-development <pgsql-hackers(at)postgresql(dot)org> |
| Subject: | Re: Improving compressibility of WAL files |
| Date: | 2009-01-09 14:31:32 |
| Message-ID: | 200901091431.n09EVW210201@momjian.us |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general pgsql-hackers |
Tom Lane wrote:
> Bruce Momjian <bruce(at)momjian(dot)us> writes:
> > Tom Lane wrote:
> >> Isn't this redundant given the existence of pglesslog?
>
> > It does the same as pglesslog, but is simpler to use because it is
> > automatic.
>
> Which also means that everyone pays the performance penalty whether
> they get any benefit or not. The point of the external solution
> is to do the work only in installations that get some benefit.
> We've been over this ground before...
If there is a performance penalty, you are right, but if the zeroing is
done as part of the archiving, it seems near zero cost enough to do it
all the time, no?
--
Bruce Momjian <bruce(at)momjian(dot)us> http://momjian.us
EnterpriseDB http://enterprisedb.com
+ If your life is a hard drive, Christ can be your backup. +
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Bruce Momjian | 2009-01-09 14:31:59 | Re: Where do I find crypto installer for Mac platform |
| Previous Message | Andrew | 2009-01-09 13:14:42 | Re: Adding Arabic dictionary for TSearch2.. to_tsvector('arabic'...) doesn't work.. |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Andrew Dunstan | 2009-01-09 14:34:14 | parallel restore |
| Previous Message | Bruce Momjian | 2009-01-09 14:28:49 | Re: Including kerberos realm |