Re: Please comment on pgsql speed at handling 550,000 records - Mailing list pgsql-novice

From Tom Lane
Subject Re: Please comment on pgsql speed at handling 550,000 records
Date
Msg-id 27709.1139337977@sss.pgh.pa.us
Whole thread Raw
In response to Re: Please comment on pgsql speed at handling 550,000 records  (Srinivas Iyyer <srini_iyyer_bio@yahoo.com>)
List pgsql-novice
Srinivas Iyyer <srini_iyyer_bio@yahoo.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

pgsql-novice by date:

Previous
From: Srinivas Iyyer
Date:
Subject: Re: Please comment on pgsql speed at handling 550,000 records
Next
From: Sean Davis
Date:
Subject: Re: Please comment on pgsql speed at handling 550,000