Search Postgresql Archives

Re: COPY FROM STDIN instead of INSERT

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

On 10/18/06 08:03, Merlin Moncure wrote:
> On 10/18/06, Martijn van Oosterhout <kleptog@xxxxxxxxx> wrote:
>> Binary may be slightly faster because the datum parsing can be
>> partially skipped, but that's hardly much benefit over a text copy.
> 
> I tested binary quite a bit and only found it to be a win if moving
> blobs in and out of the database.  On 'normal' tables of mixed fields
> types of small size, it can actually be slower.  Binary is a bit
> faster for native types and bytea, and slower for character types.

"native types"?

- --
Ron Johnson, Jr.
Jefferson LA  USA

Is "common sense" really valid?
For example, it is "common sense" to white-power racists that
whites are superior to blacks, and that those with brown skins
are mud people.
However, that "common sense" is obviously wrong.
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.5 (GNU/Linux)

iD8DBQFFNjVcS9HxQb37XmcRAvuIAJ4jHzT3dqwTCs6jrQMrPabz6yDo3gCZAaRz
smE6g1Yig973CLUhUX8CEc8=
=lFRM
-----END PGP SIGNATURE-----


[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux