Re: Slow self-join on a 100 million record table

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: mdavies(at)ilstu(dot)edu (Mark Davies)
Cc: pgsql-sql(at)postgresql(dot)org
Subject: Re: Slow self-join on a 100 million record table
Date: 2003-01-02 06:06:49
Message-ID: 17853.1041487609@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

mdavies(at)ilstu(dot)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

In response to

Browse pgsql-sql by date

  From Date Subject
Next Message Tom Lane 2003-01-02 06:16:23 Re: bug?
Previous Message Tom Lane 2003-01-02 06:04:57 Re: empty arrays