Re: question about efficiency

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: dev(at)archonet(dot)com
Cc: sszabo(at)megazone23(dot)bigpanda(dot)com, SJohnson6(at)bcbsm(dot)com, pgsql-general(at)postgresql(dot)org
Subject: Re: question about efficiency
Date: 2002-11-11 22:27:42
Message-ID: 18664.1037053662@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

<dev(at)archonet(dot)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

In response to

Browse pgsql-general by date

  From Date Subject
Next Message QUINN, JAY (SBCSI) 2002-11-11 22:35:24 Linux PostgreSQL - Data Mart & Small Data Warehousing
Previous Message Jean-Luc Lachance 2002-11-11 19:50:05 Re: Win2K Questions