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 |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
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
From | Date | Subject | |
---|---|---|---|
Next Message | Sean Davis | 2006-03-28 02:31:07 | Re: Time consuming process ...3 million records please help |
Previous Message | Sean Davis | 2006-03-28 01:35:34 | Re: Time consuming process ...3 million records please help |