Skip site navigation (1) Skip section navigation (2)

Re: WIP patch - INSERT-able log statements

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: "FAST PostgreSQL" <fastpgs(at)fast(dot)fujitsu(dot)com(dot)au>
Cc: pgsql-patches(at)postgresql(dot)org
Subject: Re: WIP patch - INSERT-able log statements
Date: 2007-02-16 00:50:26
Message-ID: 5371.1171587026@sss.pgh.pa.us (view raw or flat)
Thread:
Lists: pgsql-hackerspgsql-patches
"FAST PostgreSQL" <fastpgs(at)fast(dot)fujitsu(dot)com(dot)au> writes:
> The second variable is of interest. We need to specify a table in the insert command. My preferred option is for the user to give one and he can create it if and when he wants to. The alternative is we decide the table name and make initdb to create one.  

Why not output the data in COPY format instead?  That (a) eliminates the
problem of needing to predetermine a destination table name, and (b)
should be considerably faster to load than thousands of INSERT statements.

			regards, tom lane

In response to

Responses

pgsql-hackers by date

Next:From: David FetterDate: 2007-02-16 00:59:15
Subject: Re: patch adding new regexp functions
Previous:From: Tom LaneDate: 2007-02-16 00:35:46
Subject: Re: patch adding new regexp functions

pgsql-patches by date

Next:From: Tom LaneDate: 2007-02-16 00:54:20
Subject: Re: remove dbname arg from bootstrap mode
Previous:From: Tom LaneDate: 2007-02-16 00:35:46
Subject: Re: patch adding new regexp functions

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group