Re: Is it necessary to have index for child table in following case?

From: Joe Conway <mail(at)joeconway(dot)com>
To: Yan Cheng Cheok <yccheok(at)yahoo(dot)com>
Cc: Alban Hertroys <dalroi(at)solfertje(dot)student(dot)utwente(dot)nl>, pgsql-general(at)postgresql(dot)org
Subject: Re: Is it necessary to have index for child table in following case?
Date: 2010-02-04 01:08:07
Message-ID: 4B6A1DF7.8090506@joeconway.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On 02/03/2010 05:02 PM, Yan Cheng Cheok wrote:
>>
>> Are you using INSERT or COPY to insert your data? COPY tends to be
>> a lot faster than separate INSERTs, especially if you don't wrap
>> the INSERTs in a transaction block and COMMIT them in batches.
>
> But I do not use File or Stdio. The data is coming in row by row
> real-time. I need to insert the data programmatic real-time into the
> database. That's why I use INSERT. But maybe I miss out something on
> the usage of COPY, please advice :)

I already answered that about a month ago but you ignored it:
http://archives.postgresql.org/pgsql-general/2010-01/msg00287.php

Joe

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Yan Cheng Cheok 2010-02-04 01:20:51 Shall I apply normalization in the following case?
Previous Message John R Pierce 2010-02-04 01:02:49 Re: Need to Remove Constraint, but Don't Know How - Previous attempts failed