Re: Bad n_distinct estimation; hacks suggested? - Mailing list pgsql-performance

From Dave Held
Subject Re: Bad n_distinct estimation; hacks suggested?
Date
Msg-id 49E94D0CFCD4DB43AFBA928DDD20C8F9026184BC@asg002.asg.local
Whole thread Raw
In response to Bad n_distinct estimation; hacks suggested?  (Josh Berkus <josh@agliodbs.com>)
List pgsql-performance
> -----Original Message-----
> From: Josh Berkus [mailto:josh@agliodbs.com]
> Sent: Tuesday, April 19, 2005 2:09 PM
> To: pgsql-perform
> Subject: [PERFORM] Bad n_distinct estimation; hacks suggested?
>
> [...]
> (BTW, increasing the stats to 1000 only doubles n_distinct,
> and doesn't solve the problem)

Speaking of which, is there a reason why statistics are limited
to 1000?  Performance?

__
David B. Held
Software Engineer/Array Services Group
200 14th Ave. East,  Sartell, MN 56377
320.534.3637 320.253.7800 800.752.8129

pgsql-performance by date:

Previous
From: Josh Berkus
Date:
Subject: Bad n_distinct estimation; hacks suggested?
Next
From: Tom Lane
Date:
Subject: Re: Bad n_distinct estimation; hacks suggested?