additionally - might be worth giving the specs of the machine you are doing this on.
(I seem to recall trying this with Pg 7.2 a while ago without this issue, mind you - think I had ~1G of Ram and used the scale fact 1 dataset, i.e 1G)
regards
Mark
Shalu Gupta wrote:
Hello,
We are trying to import the TPC-H data into postgresql using the COPY command and for the larger files we get an error due to insufficient memory space.
We are using a linux system with Postgresql-7.3.4
Is it that Postgresql cannot handle such large files or is there some other possible reason.
Thanks Shalu Gupta NC State University.
---------------------------(end of broadcast)--------------------------- TIP 5: Have you checked our extensive FAQ?
http://www.postgresql.org/docs/faqs/FAQ.html
---------------------------(end of broadcast)--------------------------- TIP 9: the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match
