Tom Lane wrote:
Maxim Boguk [EMAIL PROTECTED] writes:
[ ndistinct estimates way off ]
Estimating the number of distinct values in a distribution with a long
tail is just a really hard problem :-(
If I have a table where I know it has this property, is there
any way I can tell autovacuum's
Some time ago i found one simple sql over large table eat whole ram+swap and
almost killed server (postgresql 8.3.3 on 4gb freebsd server):
After some exploring i found what happens:
Query was over simple table:
profiles=# \d+ counter_vis
Table counter_vis
Column| Type |
Maxim Boguk [EMAIL PROTECTED] writes:
[ ndistinct estimates way off ]
Estimating the number of distinct values in a distribution with a long
tail is just a really hard problem :-(
regards, tom lane
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)