Re: [PERFORM] COPY with high # of clients, partitioned table locking issues?

2011-03-31 Thread Emanuel Calvo
Your message was dropped into my Spam lable :S 2011/3/30 Strange, John W john.w.stra...@jpmchase.com: Just some information on our setup: - HP DL585 G6 - 4 x AMD Opteron 8435 (24 cores) - 256GB RAM - 2 FusionIO 640GB PCI-SSD (RAID0) - dual 10GB ethernet. - we have several tables that we

Re: [PERFORM] COPY with high # of clients, partitioned table locking issues?

2011-03-31 Thread Maciek Sakrejda
But you are using stdin for COPY! The best way is use files. I've never heard this before, and I don't see how reading from files could possibly help. Can you clarify? --- Maciek Sakrejda | System Architect | Truviso 1065 E. Hillsdale Blvd., Suite 215 Foster City, CA 94404 (650) 242-3500 Main

[PERFORM] COPY with high # of clients, partitioned table locking issues?

2011-03-30 Thread Strange, John W
Just some information on our setup: - HP DL585 G6 - 4 x AMD Opteron 8435 (24 cores) - 256GB RAM - 2 FusionIO 640GB PCI-SSD (RAID0) - dual 10GB ethernet. - we have several tables that we store calculated values in. - these are inserted by a compute farm that calculates the results and stores

Re: [PERFORM] COPY with high # of clients, partitioned table locking issues?

2011-03-30 Thread Bob Lunney
...@jpmchase.com Subject: [PERFORM] COPY with high # of clients, partitioned table locking issues? To: pgsql-performance@postgresql.org pgsql-performance@postgresql.org Date: Wednesday, March 30, 2011, 4:56 PM Just some information on our setup: - HP DL585 G6 - 4 x AMD Opteron 8435 (24 cores