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

From: Aaron Evans <aaron(at)aarone(dot)org>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: Having problems with a 25 million row table on 8.1.3
Date: 2006-04-25 20:18:11
Message-ID: A074CAB0-0FF2-43AE-B75A-B66DE4BDD3AC@aarone.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Joshua D. Drake 2006-04-25 20:43:15 Re: Having problems with a 25 million row table on 8.1.3
Previous Message Martijn van Oosterhout 2006-04-25 20:15:54 Re: Having problems with a 25 million row table on 8.1.3