Postgres Pro
Downloads
Home   >   mailing lists

Re: Simple join optimized badly? - Mailing list pgsql-performance

From Bruce Momjian
Subject Re: Simple join optimized badly?
Date
Msg-id 200610111453.k9BErUR22114@momjian.us
Whole thread Raw
In response to Re: Simple join optimized badly?  (Heikki Linnakangas <heikki@enterprisedb.com>)
List pgsql-performance
Tree view 
Heikki Linnakangas wrote:
> BTW, in DB2 you can declare a table as volatile, which means that the
> cardinality of the table varies greatly. The planner favors index scans
> on volatile tables.

Now that seems like a valuable idea.

--
  Bruce Momjian   bruce@momjian.us
  EnterpriseDB    http://www.enterprisedb.com

  + If your life is a hard drive, Christ can be your backup. +

pgsql-performance by date:

Previous
From: Heikki Linnakangas
Date:
Subject: Re: Simple join optimized badly?
Next
From: Mark Lewis
Date:
Subject: Re: Simple join optimized badly?