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

Re: Time consuming process ...3 million records please help

From: Srinivas Iyyer <srini_iyyer_bio(at)yahoo(dot)com>
To: Sean Davis <sdavis2(at)mail(dot)nih(dot)gov>
Cc: pgsql-novice(at)postgresql(dot)org
Subject: Re: Time consuming process ...3 million records please help
Date: 2006-03-28 02:17:16
Message-ID: 20060328021716.44814.qmail@web38105.mail.mud.yahoo.com (view raw or flat)
Thread:
Lists: pgsql-novice
Hi Sean, 
thanks for your reply. in my temp table,
temp_refseq_id column cannot be indexed due to
duplicate values. will that effect drastically. 
I havent tested it yet. on top of that i killed 8 hrs
process running previously on tab_update() function.
:-)

thanks
sri


> Hi, Sri.
> 
> I would do this differently.  You don't need the
> function I don't 
> think.  I would do something like this (untested):
> 
> insert into spontanno (seq_id, spontanno_imageid,
> spontanno_genbankacc)
> select seqdump.seq_id, referrer_keys.temp_imageid,
>     referrer_keys.temp.genbankacc from
> referrer_keys, seqdump
>     where
> referrer_keys.temp_refseq_id=seqdump.seq_acc;
> 
> Make sure there is an index on seq_acc and
> temp_refseq_id.  This should 
> be done in seconds to minutes, not hours.
> 
> Sean

-



<snip>



__________________________________________________
Do You Yahoo!?
Tired of spam?  Yahoo! Mail has the best spam protection around 
http://mail.yahoo.com 

In response to

Responses

pgsql-novice by date

Next:From: Sean DavisDate: 2006-03-28 02:31:07
Subject: Re: Time consuming process ...3 million records please help
Previous:From: Sean DavisDate: 2006-03-28 01:35:34
Subject: Re: Time consuming process ...3 million records please help

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