Speeding up Postgres INSERTsby punkish (Priest)
|on Jun 18, 2010 at 05:17 UTC||Need Help??|
punkish has asked for the
wisdom of the Perl Monks concerning the following question:
I have an array of arrays that I am INSERTing into a Pg table (pseudo-code ahead) —
I'd like to speed up the INSERTs by possibly using the COPY table FROM STDIN WITH DELIMITER AS ',' command. Is there a way I can do that? Is there some other way I can speed up the INSERTs?
Update: I should have added, right now the INSERTs are rather slow; several seconds for every 100K INSERTs.
Update2: I finally got a result back from one set of INSERTs. I am getting ~3300 insertions per second. I would consider that fairly slow.
when small people start casting long shadows, it is time to go to bed