Martha Stewart called it a Good Thing [EMAIL PROTECTED] (Josh Berkus)wrote: > Shridhar, >> Unfortunately he can not use copy due to some constraints.
> Why not use COPY to load the table, and then apply the constraints > by query afterwords? It might not be faster, but then again it > might. If you can transform the information into COPYable form, that's certainly a good thing. Whether it will be workable or not is another question. > ... but that's based on inadequate experimentation, just a few tests > on Bonnie++ on a Netra running Solaris 8. As far as the filesystem issues are concerned, you're probably using an "old, standard" version of UFS. The "high performance" option on Solaris involves using third-party Veritas software. The persistence of this is somewhat surprising; I'd somewhat have expected Sun to have bought out Veritas or some such thing, as it's a pretty vital technology that _isn't_ totally under their control. Actually, an entertaining option would be for them to buy out SGI, as that would get them control of XFS and a number of other interesting technologies. My expectations of a Netra wouldn't be terribly high, either; they seem to exist as a product so that people that need a cheap Sun box have an option. They are mostly running IDE disk, and the latest IA-32 hardware is likely to have newer faster interface options. -- (format nil "[EMAIL PROTECTED]" "cbbrowne" "ntlug.org") http://cbbrowne.com/info/advocacy.html "Windows NT was designed to be administered by an idiot and usually is..." -- Chris Adams" <[EMAIL PROTECTED]> ---------------------------(end of broadcast)--------------------------- TIP 8: explain analyze is your friend
