Re: invalid memory alloc request size 576460752438159360

Поиск
Список
Период
Сортировка
От Ibrahim Edib Kokdemir
Тема Re: invalid memory alloc request size 576460752438159360
Дата
Msg-id CABnTom+xJ6CcTEosxjGNEh-VLCDGa90mq-HG28REQW62ZOEmpA@mail.gmail.com
обсуждение исходный текст
Ответ на Re: invalid memory alloc request size 576460752438159360  (Peter Geoghegan <pg@bowt.ie>)
Ответы Re: invalid memory alloc request size 576460752438159360  (Ibrahim Edib Kokdemir <kokdemir@gmail.com>)
Список 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 по дате отправления:

Предыдущее
От: Peter Geoghegan
Дата:
Сообщение: Re: invalid memory alloc request size 576460752438159360
Следующее
От: Rob Sargent
Дата:
Сообщение: is single row update improved with function