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

From Kris Jurka
Subject Re: WAL logging of SELECT ... INTO command
Date
Msg-id Pine.BSO.4.63.0603221432320.4790@leary.csoft.net
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

On Wed, 22 Mar 2006, Jim C. Nasby wrote:

> Ok, I saw disk activity on the base directory and assumed it was pg_xlog
> stuff. Turns out that both SELECT INTO and CREATE TABLE AS ignore
> default_tablepsace and create the new tables in the base directory. I'm
> guessing that's a bug... (this is on 8.1.2, btw).

This has been fixed in CVS HEAD as part of a patch to allow additional
options to CREATE TABLE AS.

http://archives.postgresql.org/pgsql-patches/2006-02/msg00211.php

Kris Jurka


pgsql-performance by date:

Previous
From: "Luke Lonergan"
Date:
Subject: Re: Intel C/C++ Compiler Tests
Next
From: "Qingqing Zhou"
Date:
Subject: Re: WAL logging of SELECT ... INTO command