Skip site navigation (1) Skip section navigation (2)

Re: SELECT '(1, nan, 3)'::cube;

From: bricklen <bricklen(at)gmail(dot)com>
To: Robert Brewer <fumanchu(at)aminus(dot)org>
Cc: pgsql-bugs(at)postgresql(dot)org
Subject: Re: SELECT '(1, nan, 3)'::cube;
Date: 2011-03-16 16:18:02
Message-ID: AANLkTikobQLQUmS4+=qieC05Cw7MwnsWZ6uWNriyf=FG@mail.gmail.com (view raw or flat)
Thread:
Lists: pgsql-bugs
On Tue, Mar 15, 2011 at 9:08 AM, Robert Brewer <fumanchu(at)aminus(dot)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!

In response to

Responses

pgsql-bugs by date

Next:From: Robert BrewerDate: 2011-03-16 18:14:31
Subject: Re: SELECT '(1, nan, 3)'::cube;
Previous:From: Frederic JunodDate: 2011-03-16 15:25:21
Subject: BUG #5934: postgresql.conf: optional equal sign

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group