Re: What's the fastest way to do this?

From: Orion <o2(at)trustcommerce(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: What's the fastest way to do this?
Date: 2001-11-08 22:57:56
Message-ID: 9sf2d4$1jhv$1@news.tht.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Andrew Gould wrote:

> Are you updating directly from the flat file? Or are
> you copying the new data into an indexed table that is
> emptied and vacuumed after daily updates, and
> updating/inserting from there?
>
> Andrew Gould

Well to be honest I'll do it any way I can to make this go faster.

Right now I am updating directly from said file. For each line I read from
the file I need to insert or update the exsisting table depending on
weather or not the record is already there.

Orion

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Jason Earl 2001-11-08 23:27:41 Re: Hardware performance tuning
Previous Message Douglas Bates 2001-11-08 22:50:12 Hardware performance tuning