| 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 |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers pgsql-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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | David Fetter | 2007-02-16 00:59:15 | Re: patch adding new regexp functions |
| Previous Message | Tom Lane | 2007-02-16 00:35:46 | Re: patch adding new regexp functions |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tom Lane | 2007-02-16 00:54:20 | Re: remove dbname arg from bootstrap mode |
| Previous Message | Tom Lane | 2007-02-16 00:35:46 | Re: patch adding new regexp functions |