Postgres Pro
Downloads
Home   >   mailing lists

Re: WAL logging of SELECT ... INTO command - Mailing list pgsql-performance

From Simon Riggs
Subject Re: WAL logging of SELECT ... INTO command
Date
Msg-id 1143032914.24487.632.camel@localhost.localdomain
Whole thread Raw
In response to Re: WAL logging of SELECT ... INTO command  ("Jim C. Nasby" <jnasby@pervasive.com>)
Responses Re: WAL logging of SELECT ... INTO command
List pgsql-performance
Tree view 
On Wed, 2006-03-22 at 06:47 -0600, Jim C. Nasby wrote:

> Also, why do we log rows for CTAS/SELECT INTO when PITR is in use for
> simple SELECTs (ones that don't call non-deterministic functions)? The
> data should alread be available AFAICS...

Not sure what you're asking... SELECTs don't produce WAL.

PITR wants all changes. Without PITR we can optimise certain logging
actions.

Best Regards, Simon Riggs

pgsql-performance by date:

Previous
From: "Jim C. Nasby"
Date:
Subject: Re: Migration study, step 1: bulk write performanceoptimization
Next
From: "Mikael Carneholm"
Date:
Subject: Re: Migration study, step 1: bulk write performanceoptimization