Search Postgresql Archives

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

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



On 4/25/06, Tony Caduto <tony_caduto@xxxxxxxxxxxxxxxxxxxx> 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

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux