Re: What is WAL used for?

From: Jonathan Bartlett <johnnyb(at)eskimo(dot)com>
To: holger(at)wizards(dot)de
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: What is WAL used for?
Date: 2003-12-01 21:01:11
Message-ID: Pine.GSU.4.44.0312011259320.11016-100000@eskimo.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

> WAL with ext3's data journaling is quite unnecessary because the WAL
> sort of IS the database's journal.

I believe you are mistaken. ext3 data journalling only does the
filesystem. It has no concept of the structure of the database itself.
WAL is still necessary to keep consistency on the table itself.

>
> Holger
> --
> A: Maybe because some people are too annoyed by top-posting.
> Q: Why do I not get an answer to my question(s)?
> A: Because it messes up the order in which people normally read text.
> Q: Why is top-posting such a bad thing?
>
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 5: Have you checked our extensive FAQ?
>
> http://www.postgresql.org/docs/faqs/FAQ.html
>

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Oleg Lebedev 2003-12-01 21:01:41 Re: Storing passwords
Previous Message Ruth Hsieh 2003-12-01 20:56:40 pg_dump on one user not whole database