Re: Performance and WAL on big inserts/updates

From: Marty Scholes <marty(at)outputservices(dot)com>
To: Rod Taylor <pg(at)rbt(dot)ca>
Cc: PostgreSQL Development <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: Performance and WAL on big inserts/updates
Date: 2004-03-12 02:04:37
Message-ID: 40511AB5.8060106@outputservices.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

I can see that and considered it.

The seed state would need to be saved, or any particular command that is
not reproducible would need to be exempted from this sort of logging.

Again, this would apply only to situations where a small SQL command
created huge changes.

Marty

Rod Taylor wrote:
>>If a transaction will do large updates or inserts, why don't we just log
>>the parsed statements in the WAL instead of the individual data blocks
>
>
> UPDATE table SET col = random();
>
>

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Rod Taylor 2004-03-12 02:12:12 Re: Performance and WAL on big inserts/updates
Previous Message Tom Lane 2004-03-12 01:23:46 Re: Log rotation