Re: invalid memory alloc request size 576460752438159360

From: Ibrahim Edib Kokdemir <kokdemir(at)gmail(dot)com>
To: Peter Geoghegan <pg(at)bowt(dot)ie>
Cc: pgsql-general General <pgsql-general(at)postgresql(dot)org>
Subject: Re: invalid memory alloc request size 576460752438159360
Date: 2017-12-31 22:20:21
Message-ID: CABnTom+xJ6CcTEosxjGNEh-VLCDGa90mq-HG28REQW62ZOEmpA@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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.

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Rob Sargent 2017-12-31 23:06:30 is single row update improved with function
Previous Message Peter Geoghegan 2017-12-31 21:53:49 Re: invalid memory alloc request size 576460752438159360