Re: invalid memory alloc request size 576460752438159360 - Mailing list pgsql-general

From Ibrahim Edib Kokdemir
Subject Re: invalid memory alloc request size 576460752438159360
Date
Msg-id CABnTom+xJ6CcTEosxjGNEh-VLCDGa90mq-HG28REQW62ZOEmpA@mail.gmail.com
Whole thread Raw
In response to Re: invalid memory alloc request size 576460752438159360  (Peter Geoghegan <pg@bowt.ie>)
Responses Re: invalid memory alloc request size 576460752438159360  (Ibrahim Edib Kokdemir <kokdemir@gmail.com>)
List pgsql-general
> As I mentioned earlier, if this takes too long, you could only do
> heapallindexed checking once per table (not once per index) by giving
> "indisprimary" as the heapallindexed argument. That way, only primary
> keys would be verified against the heap, which is potentially a lot
> faster.

Oh, and I think that you should remove the "ORDER BY c.relpages DESC
LIMIT 10", too.

My db is not big enough right now. Queries did not take too long. I definitely did all the things you said. And I got only long lists without errors. That is actually a good thing for me. 
Thanks a lot.  

pgsql-general by date:

Previous
From: Peter Geoghegan
Date:
Subject: Re: invalid memory alloc request size 576460752438159360
Next
From: Rob Sargent
Date:
Subject: is single row update improved with function