-----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-----
