Postgres Pro
Downloads
Home   >   mailing lists

Re: Slow self-join on a 100 million record table - Mailing list pgsql-sql

From Tom Lane
Subject Re: Slow self-join on a 100 million record table
Date
Msg-id 17853.1041487609@sss.pgh.pa.us
Whole thread Raw
In response to Slow self-join on a 100 million record table  (mdavies@ilstu.edu (Mark Davies))
List pgsql-sql
Tree view 
mdavies@ilstu.edu (Mark Davies) writes:
> The problem is, the self-join solution is extremely slow.  I have a
> SQL Server 7.0 database with a clustered index on TheWord (sequential
> words) and a normal index on TheID.

Kindly do not pester Postgres mailing lists with SQL Server questions.
        regards, tom lane

pgsql-sql by date:

Previous
From: Tom Lane
Date:
Subject: Re: empty arrays
Next
From: Tom Lane
Date:
Subject: Re: bug?