Re: Performance and WAL on big inserts/updates - Mailing list pgsql-hackers

From Marty Scholes
Subject Re: Performance and WAL on big inserts/updates
Date
Msg-id 40511AB5.8060106@outputservices.com
Whole thread Raw
In response to Performance and WAL on big inserts/updates  (Marty Scholes <marty@outputservices.com>)
Responses Re: Performance and WAL on big inserts/updates  (Rod Taylor <pg@rbt.ca>)
List 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();
> 
> 




pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: Re: Log rotation
Next
From: Rod Taylor
Date:
Subject: Re: Performance and WAL on big inserts/updates