Mark Fletcher <markf@xxxxxxxxxxxxxx> writes: > Thanks for the response. I did restart the postmaster yesterday. Earlier > this morning, a query that normally completes fine started to error out > with 'invalid memory alloc request size 18446744073709551613'. Needless to > say our database isn't quite that size. This query was against a table in a > different database than the one that had the corruption warning yesterday. > Restarting the postmaster again fixed the problem. For good measure I > restarted the machine as well. Um. At that point I'd agree with your concern about developing hardware problems. Both of these symptoms could be easily explained by dropped bits in PG's shared memory area. Do you happen to know if the server has ECC RAM? regards, tom lane
