[PERFORM] Memory Allocation

2008-11-26 Thread Ryan Hansen
Hey all, This may be more of a Linux question than a PG question, but I'm wondering if any of you have successfully allocated more than 8 GB of memory to PG before. I have a fairly robust server running Ubuntu Hardy Heron, 24 GB of memory, and I've tried to commit half the memory to PG's sh

Re: [PERFORM] Improve COPY performance for large data sets

2008-09-10 Thread Ryan Hansen
NEVERMIND!! I found it. Turns out there was still a constraint on the table. Once I dropped that, the time went down to 44 minutes. Maybe I am an idiot after all. :) -Ryan --- Begin Message --- Greetings, I'm relatively new to PostgreSQL but I've been in the IT applications industry for

[PERFORM] Improve COPY performance for large data sets

2008-09-10 Thread Ryan Hansen
Greetings, I'm relatively new to PostgreSQL but I've been in the IT applications industry for a long time, mostly in the LAMP world. One thing I'm experiencing some trouble with is running a COPY of a large file (20+ million records) into a table in a reasonable amount of time. Currently it