Re: BUG #13633: ERROR: invalid memory alloc request size - Mailing list pgsql-bugs

andreas-postgresql@creative-memory.de writes:
> SELECT G.MarkerID,G.Allel1,G.Allel2, count (G.TierLIDint) as nH
>   FROM GenotypHD as G, TiereInSets as TS, Marker as M
>     WHERE TS.TierSetID='HD.09.15' and TS.TierLIDint=G.TierLIDint and
> M.Version='3' and M.MarkerID=G.MarkerID and G.Allel1<>G.Allel2
>     GROUP BY G.MarkerID,G.Allel1,G.Allel2;

> ERROR:  invalid memory alloc request size 1073741824

FWIW, I could not reproduce this on the basis of the supplied information,
ie just creating the tables and running this query does not do anything
surprising.  It looks like possibly a corrupt-data issue --- can you do
"select * from" each table without problems?

            regards, tom lane