Skip site navigation (1)
Skip section navigation (2)
Peripheral Links
Header And Logo
|
Site Navigation
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: Tue, 25 Apr 2006 16:18:11 -0400
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
- 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: Having problems with a 25 million row table on 8.1.3
- Next by Date: Re: Having problems with a 25 million row table on 8.1.3
- Previous by thread: Re: Having problems with a 25 million row table on 8.1.3
- Next by thread: Re: Having problems with a 25 million row table on 8.1.3
- Indexes: