Home > mailing lists

Re: Having problems with a 25 million row table on 8.1.3 - Mailing list pgsql-general

From	Aaron Evans
Subject	Re: Having problems with a 25 million row table on 8.1.3
Date	April 27, 2006 13:27:47
Msg-id	A074CAB0-0FF2-43AE-B75A-B66DE4BDD3AC@aarone.org Whole thread Raw
In response to	Having problems with a 25 million row table on 8.1.3 (Tony Caduto <tony_caduto@amsoftwaredesign.com>)
List	pgsql-general

Tree view

try:

select tax_code from warehouse.sec_trans group by tax_code

there was a discussion about this on the pgsql-performance a while back:

http://archives.postgresql.org/pgsql-performance/2004-10/msg00053.php

-ae

On Apr 25, 2006, at 4:10 PM, Tony Caduto wrote:

> select DISTINCT tax_code from warehouse.sec_trans We let this run
> for 1/2 hour or so and canceled it.
>
> Then I tried select DISTINCT ON (tax_code) tax_code from
> warehouse.sec_trans

pgsql-general by date:

From: "IvoD"
Date: 27 April 2006, 13:06:40
Subject: Re: Database Selection

From: "mlartz@gmail.com"
Date: 27 April 2006, 13:27:48
Subject: Disk failure scenarios

Re: Having problems with a 25 million row table on 8.1.3 - Mailing list pgsql-general

Previous

Next