Re: Too many range table entries error

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: Too many range table entries error
Дата
Msg-id 21974.1529973478@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: Too many range table entries error  (Andres Freund <andres@anarazel.de>)
Ответы Re: Too many range table entries error
Список pgsql-general
Andres Freund <andres@anarazel.de> writes:
> On 2018-06-25 13:46:06 +0530, Akshaya Acharya wrote:
>> Our entire application-all our business logic-is built as layers of views
>> inside the database. The ref counts sort of multiple at each layer, hence
>> the large number.

> That still doesn't explain how you realistically get to 40k references,
> and how that's a reasonable design.

The short answer here is that even if the system accepted queries with
that many tables, it's really unlikely to perform acceptably --- in fact,
I'm a bit astonished that you even found a way to reach this error without
having waited a few hours beforehand.  And we are *not* going to promise
to fix all the performance issues you will hit with a schema design like
this.  Redesign.  Please.

            regards, tom lane


В списке pgsql-general по дате отправления:

Предыдущее
От: Data Ace
Дата:
Сообщение: Re: PostgreSQL Volume Question
Следующее
От: Michael Paquier
Дата:
Сообщение: Re: using pg_basebackup for point in time recovery