Skip site navigation (1)
Skip section navigation (2)
On 4/25/06, Tony Caduto <tony_caduto(at)amsoftwaredesign(dot)com> wrote:
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
Peripheral Links
Header And Logo
|
Site Navigation
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: Fri, 28 Apr 2006 09:51:31 +0200
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
- References:
- Having problems with a 25 million row table on 8.1.3
- From: Tony Caduto
- Having problems with a 25 million row table on 8.1.3
- Prev by Date: Re: Installing PostgreSQL on Win 2003 R2 64-bit
- Next by Date: Re: For vim users: Syntax highlighting for PostgreSQL
- Previous by thread: Re: Having problems with a 25 million row table on 8.1.3
- Next by thread: Please comment on the following OpenFTS/tsearch2 issues!
- Indexes: