-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1
On 10/18/06 08:03, Merlin Moncure wrote:
> On 10/18/06, Martijn van Oosterhout <kleptog@svana.org> 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-----