Re: question about efficiency - Mailing list pgsql-general

From Tom Lane
Subject Re: question about efficiency
Date
Msg-id 18664.1037053662@sss.pgh.pa.us
Whole thread Raw
In response to Re: question about efficiency  (<dev@archonet.com>)
List pgsql-general
<dev@archonet.com> writes:
> Would it be possible to have some sort of configurable limit on this:

> max_result_set_size = 10,000,000
> max_result_set_action = ignore | debug | warn | error

> The planner knows how many rows it's expecting to return,

Personally, I would never trust the planner's estimate far enough
to use it as the basis for triggering an error ;-)

            regards, tom lane

pgsql-general by date:

Previous
From: Jean-Luc Lachance
Date:
Subject: Re: Win2K Questions
Next
From: "QUINN, JAY (SBCSI)"
Date:
Subject: Linux PostgreSQL - Data Mart & Small Data Warehousing