From: | "FERREIRA William (COFRAMI)" <william(dot)ferreira(at)airbus(dot)com> |
---|---|
To: | "'pgsql-general(at)postgresql(dot)org'" <pgsql-general(at)postgresql(dot)org> |
Subject: | postgresql max memory (pl/Perl) |
Date: | 2005-03-23 16:43:11 |
Message-ID: | 1904E3EB39448246A7ECB76DF34A70B00143B4AA@TOCOMEXC03 |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
hi
in my application i select data from my database and i store it into a
pl/perl variable $myClob.
the quantity of data is very big (around 250Mo, growing to 800Mo). and next
i write this data into a file.
with Oracle, it works, but with Oracle i get an exception saying that
postgresql use a memory adress which is not allowed (or not in write mode).
my database is install on windows2000NT, with PIV 2.8Ghz and 1Go RAM.
does this error comes from the configuration of my database, the limits of
postgresql, or does i must write the file in several times ?
an other question is that the application will run on others plateform :
does i will get an error with a SUN station : biprocessor, 4Go RAM and
solaris 2.8 ?
regards
Will
From | Date | Subject | |
---|---|---|---|
Next Message | Richard Huxton | 2005-03-23 16:49:49 | Re: Delay INSERT |
Previous Message | Vernon | 2005-03-23 16:42:55 | Command Prompt on Window version |