Re: code question: storing INTO relation - Mailing list pgsql-hackers

From Greg Stark
Subject Re: code question: storing INTO relation
Date
Msg-id 87fz46wcun.fsf@stark.xeocode.com
Whole thread Raw
In response to Re: code question: storing INTO relation  (Simon Riggs <simon@2ndquadrant.com>)
Responses Re: code question: storing INTO relation
Re: code question: storing INTO relation
List pgsql-hackers
Simon Riggs <simon@2ndquadrant.com> writes:

> I agree, hence why this should be a user option. The usage of this is
> restricted to particular classes of database usage: data warehousing or
> very large database applications. This isn't intended for use in OLTP or
> web-site databases.

Well a lot of users also just don't use online backups. For these users
there's no downside to CREATE INDEX/REINDEX/CREATE TABLE AS not logging. 

The logging is not needed for a regular recovery, only for restoring from
and a backup older than the table/index creation.

-- 
greg



pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: Re: check over the tar files ...
Next
From: Dennis Bjorklund
Date:
Subject: Re: timestamp with time zone a la sql99