Re: Please comment on pgsql speed at handling 550,000 records

Srinivas Iyyer <srini_iyyer_bio(at)yahoo(dot)com> writes:
> Sorry Tom, for the confusion.
> seq_id is not equal to go_id

> seq_id = NM_000033
> go_is = GO:049934

So how do you know which ones are related? If there's a table showing
the relationship, joining against that is the way to go. You might also
want to rethink your choice of data keys --- if there isn't a simple way
to join related rows in different tables, you've chosen a poor data
representation.

A small tip is that integer or bigint keys are likely to perform better
than strings ... but this is definitely a second-order effect, and I
don't think you've yet got the first-order representational decisions
correct.

regards, tom lane