Re: [PERFORM] Array types and loading

2004-08-18 Thread Aaron Birkland
You got it.. 7.3 (should have mentioned that). We're planning to upgrade to 8.0 anyway in the future, so it's good to know. Thanks! -Aaron On Wed, 18 Aug 2004 17:39:21 -0400, Tom Lane <[EMAIL PROTECTED]> wrote: > Aaron Birkland <[EMAIL PROTECTED]> writes: > > In a nutshell, it looks like wh

Re: [PERFORM] Array types and loading

2004-08-18 Thread Tom Lane
Aaron Birkland <[EMAIL PROTECTED]> writes: > In a nutshell, it looks like whenever COPY is invoked, and when a user > defined type is used in an array, then stat64() will be called for > each row accessed on the shared library relevant for the user defined > type. Let me guess ... PG 7.3 or older?

[PERFORM] Array types and loading

2004-08-18 Thread Aaron Birkland
Hi, I noticed an interesting phenomenon when loding (COPY) some tables from a file. For some reason, one load was taking longer than I assumed it would. As it turns out, one of the columns was an array containing elements that were of a user defined type. Using strace (on linux) and truss (on