Re: [GENERAL] batch insertion

On 08/24/2013 05:15 PM, Korisk wrote: Hi! I want quick insert into db a lot of data (in form of triplets). Data is formed dynamical so "COPY" is not suitable. I tried batch insert like this: insert into triplets values (1,1,1); insert into triplets values (1,1,1), (3,2,5), (4,5,5); ... insert i

Re: [GENERAL] batch insertion

On Aug 24, 2013, at 5:15 PM, Korisk wrote: > Hi! > I want quick insert into db a lot of data (in form of triplets). Data is > formed dynamical so "COPY" is not suitable. COPY works just fine for dynamically generated data, and it's probably the right thing to use if you're bulk loading data (

Re: [GENERAL] batch insertion

On Sun, Aug 25, 2013 at 3:15 AM, Korisk wrote: > Hi! > I want quick insert into db a lot of data (in form of triplets). Data is > formed dynamical so "COPY" is not suitable. > I tried batch insert like this: > > insert into triplets values (1,1,1); > insert into triplets values (1,1,1), (3,2,5),

[GENERAL] batch insertion

Hi! I want quick insert into db a lot of data (in form of triplets). Data is formed dynamical so "COPY" is not suitable. I tried batch insert like this: insert into triplets values (1,1,1); insert into triplets values (1,1,1), (3,2,5), (4,5,5); ... insert into triplets values (1,1,1), (3,2,5), (4

Re: [GENERAL] earthdistance

On Tue, Aug 20, 2013 at 20:38:51 +0200, Olivier Chaussavoine wrote: I also look at cube extension, but the built in type box - a couple of points - does not require any extension and has a GIST index. It can be used to represent a rectangle on the domain [-PI/2,+PI/2[*[-PI,PI[. If the extensio

[GENERAL] Call for translations

In anticipation of the release of PostgreSQL 9.3, it is once again time to update the message translations. We are now in a string freeze, which has traditionally been associated with the first release candidate, so it's a good time to do this work now. If you want to help, see