On Tue, Oct 8, 2013 at 1:23 AM, Atri Sharma <[email protected]> wrote: >>> Consider the aspects associated with open addressing.Open addressing >>> can quickly lead to growth in the main table.Also, chaining is a much >>> cleaner way of collision resolution,IMHO. >> >> What do you mean by "growth in the main table"? > > Sorry, I should have been more verbose. > > AFAIK, Open addressing can be slower with a load factor approaching 1 > as compared to chaining. Also, I feel that implementation of open > addressing can be more complicated as we have to deal with deletes > etc.
Deletes for a hash aggregate? -- Sent via pgsql-hackers mailing list ([email protected]) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers
