Re: [HACKERS] Big IN() clauses etc : feature proposal

From: Markus Schaber <schabi(at)logix-tt(dot)com>
To: pgsql-performance(at)postgresql(dot)org
Cc: pgsql-hackers(at)postgresql(dot)org
Subject: Re: [HACKERS] Big IN() clauses etc : feature proposal
Date: 2006-05-10 15:59:26
Message-ID: 44620DDE.1080500@logix-tt.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers pgsql-performance

Hi, Nils,

Nis Jorgensen wrote:

> It will probably be quite common for the number to depend on the number
> of rows in other tables. Even if this is fairly constant within one db
> (some assumption), it is likely to be different in others using the same
> function definition. Perhaps a better solution would be to cache the
> result of the estimator function.

Sophisticated estimator functions are free to use the pg_statistics
views for their row count estimation.

HTH,
Markus
--
Markus Schaber | Logical Tracking&Tracing International AG
Dipl. Inf. | Software Development GIS

Fight against software patents in EU! www.ffii.org www.nosoftwarepatents.org

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Gurjeet Singh 2006-05-10 16:10:57 Re: BEGIN inside transaction should be an error
Previous Message Fabien COELHO 2006-05-10 15:41:30 Re: bug? non working casts for domain

Browse pgsql-performance by date

  From Date Subject
Next Message Bruno Wolff III 2006-05-10 18:10:51 Re: UNSUBSCRIBE
Previous Message me 2006-05-10 15:45:37 Re: in memory views