One question is what does the explain (without analyze) plan look like for
the above and are the row estimates valid in the case of one of the hash
plans.
pointspp=# explain select trid, count(*) from pptran group by trid
having count(*) > 1;
QUERY PLAN
--------------------------------------------------------------------------
HashAggregate (cost=1311899.28..1311902.78 rows=200 width=18)
Filter: (count(*) > 1)
-> Seq Scan on pptran (cost=0.00..1039731.02 rows=36289102 width=18)
(3 rows)
Failing that, how many rows should the above return?
That is exactly what I am trying to find out. I can only guess that, but
it should not be more than a couple of 10k rows.
---------------------------(end of broadcast)---------------------------
TIP 4: Have you searched our list archives?
http://archives.postgresql.org
