FAQ
Hi all,

I have a simple problem, but don't know any simple solution for it.

I have a list of (millions) of couple (url1, url2), where url1 and url2 are
strings. I have imported this list in a table "urls" by COPY FROM.

In the same time, I have a table "idurl" (id integer, url string) that gives
me a correspondence between an url and an identifier (also millions of
different urls).
I would like to create a new table (id1, id2), each row of this table being
the couple of identifiers corresponding to a couple of urls from the table
"urls".

I have tried OUTER JOIN:

CREATE tmp1 (id integer);
INSERT INTO tmp1 (id) SELECT idurl.id FROM urls LEFT OUTER JOIN idurl
ON (url.url1 = idurl.url);

and I have done the same thing with another table tmp2.
But this takes a while, and I have the problem of combining the resulting
tables tmp1 and tmp2.

Another solution that I have tried, is to create a index on url in the table
idurl, but this take lots of space in memory.


I know that there is no miracle solution, but if someone has a better
solution...

Thanks !

-Vincent

Search Discussions

Related Discussions

Discussion Navigation
viewthread | post
Discussion Overview
grouppgsql-novice @
categoriespostgresql
postedJun 30, '11 at 4:47p
activeJun 30, '11 at 4:47p
posts1
users1
websitepostgresql.org
irc#postgresql

1 user in discussion

Vincent Michel: 1 post

People

Translate

site design / logo © 2022 Grokbase