Re: AW: AW: User functions and AIX

Thus spake Zeugswetter Andreas SB
> > Bingo! I can't believe that IBM has been wrestling with this for a week.
> > Part of the reason we are thinking of going with IBM is for the support.
>
> Shared libs are obviously not their strong side :-)
Tell me about it.

> Basically we are very happy with their RS6000's and AIX though.

With PostgreSQL? See below.

> > Here is my Makefile now. I'm not sure about that -lc there
> > as I get duplicate symbol warnings but it appears to work fine.
>
> they don't matter
>
> > CFLAGS = -g -O0 -pipe -ansi -Wall -Wshadow -Wpointer-arith
>
> gcc and not xlc :-) actually xlc produces faster code, but I don't think that makes a
> noticeable difference.

Hmm. Should I get rid of gcc and build PostgreSQL with xlc do you think?
Some people have told me that gcc is actually faster.

> > .o.so:
> > ld -G -o $@ $< -L ${PGLIBDIR} -bI:/usr/local/pgsql/lib/postgres.imp \
> > -bexpall -bnoentry -lc
>
> Always use the compiler for linking instead of ld:
> gcc -Wl,-H512 -Wl,-bM:SRE -o $@ $< -L ${PGLIBDIR} -bI:/usr/local/pgsql/lib/postgres.imp \
> -bexpall -bnoentry

I'll do that. Thanks.

> You are not allowed to leave anything unresolved, thus do not use -G, or you won't notice
> unresolved externals (-G includes -berok which you don't want at all).

I wasn't sure if I needed that. I will remove it.

OK, so I built it and loaded my database. I tried to load a very big
table (383969 rows) and the copy failed because it was too big. I split
the input into smaller chunks but when I ran it I got the following error.

ERROR: copy: line 1, Memory exhausted in AllocSetAlloc(858864139)

There is no way that I could have used that much memory in the first row.
I dropped the table and recreated it and the load worked. Although it
works now I still feel a little uneasy.

Thanks for your help.

--
D'Arcy J.M. Cain <darcy(at){druid|vex}.net> | Democracy is three wolves
http://www.druid.net/darcy/ | and a sheep voting on
+1 416 425 1212 (DoD#0082) (eNTP) | what's for dinner.