Postgres Pro
Downloads
Home   >   mailing lists

HashAggregate row estimate = 200 - Mailing list pgsql-hackers

From Christophe Pettus
Subject HashAggregate row estimate = 200
Date
Msg-id 6307FB83-03AF-4ABE-9126-06790BC498EF@thebuild.com
Whole thread Raw
Responses Re: HashAggregate row estimate = 200  (David Rowley <david.rowley@2ndquadrant.com>)
List pgsql-hackers
Tree view 
Something I've noticed frequently is that HashAggregate will, especially if the children are Append with one of the
nodesa non-seqscan, estimate 200 rows rather than a calculated vlaue.  Where is that value coming from?  The statistics
target,a hardwired constant, or something else? 
--
-- Christophe Pettus  xof@thebuild.com

pgsql-hackers by date:

Previous
From: Andres Freund
Date:
Subject: Re: Perf Benchmarking and regression.
Next
From: Bruce Momjian
Date:
Subject: Re: Prepared statements and generic plans