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