bricklen wrote: > On Tue, Mar 15, 2011 at 9:08 AM, Robert Brewer <fuman...@aminus.org> > wrote: > > I'm working on a hypercube implementation in Postgres using > contrib/cube > > > > and need to insert 80,000 rows in one go from Python. Doing so with > > INSERT, even multiple statements in one call, is pretty slow. I've > been > > investigating if using COPY is faster. > > When you say "multiple statements", do you mean > > INSERT INTO foo (coords) VALUES > (cube(ARRAY[1, 'nan', 3]::float[])), > (cube(ARRAY[2, 'nan', 4]::float[])), > (cube(ARRAY[3, 'nan', 5]::float[])), > (cube(ARRAY[4, 'nan', 6]::float[])); > > I was going to suggest trying that method, but if you already have > then please ignore me!
Yes, I'm using the above now. Looking for something faster. I'll probably settle on using -Inf for the short term so I can use COPY. Bob -- Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-bugs
