Re: Performance Issues

> # EXPLAIN SELECT ln, count(1) FROM data_table GROUP BY ln;
>
> NOTICE: QUERY PLAN:
>
> Aggregate (cost=19538149.27..19864263.69 rows=6522288 width=19)
>
> -> Group (cost=19538149.27..19701206.48 rows=65222884 width=19)
>
> -> Sort (cost=19538149.27..19538149.27 rows=65222884 width=19)
>
> -> Seq Scan on data_table (cost=0.00..2324610.84 rows=65222884 width=19)
>
>
>
> The last name (ln) and the year of birth (yb) is indexed, but that
> shouldn't matter because it's doing a sequential scan, correct? Am I
> running into the limitations of Postgres? We'd like to eventually get

I didn't see anything about your settings in postgresql.conf, but
increasing the sort_mem parameter may help that really expensive sort
step. I think the desired fix for this would probably be the TODO entry
on hash based aggregates but that's still in the future...