Re: Having problems with a 25 million row table on 8.1.3

From: "hubert depesz lubaczewski" <depesz(at)gmail(dot)com>
To: "Tony Caduto" <tony_caduto(at)amsoftwaredesign(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Having problems with a 25 million row table on 8.1.3
Date: 2006-04-28 07:51:31
Message-ID: 9e4684ce0604280051v246f9888x614f7de85433cacd@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On 4/25/06, Tony Caduto <tony_caduto(at)amsoftwaredesign(dot)com> wrote:
>
> So far it has worked great, but today someone wanted to get all the tax
> codes(there are lot's of dupes) from the table.
>

others already suggested group by approach.
i would like to also suggest use of triggers to maintain tax codes list in
separate table.
it would greatly speedup every future query that will need this list.

depesz

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Terry Lee Tucker 2006-04-28 07:54:46 Re: For vim users: Syntax highlighting for PostgreSQL
Previous Message Magnus Hagander 2006-04-28 07:36:44 Re: Installing PostgreSQL on Win 2003 R2 64-bit