Skip site navigation (1) Skip section navigation (2)

Re: Wishlist for 7.4: Plan stability

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Greg Stark <gsstark(at)mit(dot)edu>
Cc: pgsql-hackers(at)postgresql(dot)org
Subject: Re: Wishlist for 7.4: Plan stability
Date: 2002-12-01 04:28:47
Message-ID: 15348.1038716927@sss.pgh.pa.us (view raw or flat)
Thread:
Lists: pgsql-hackers
Greg Stark <gsstark(at)mit(dot)edu> writes:
> Ok, someone else posted their data warehousing wishlist, I want to post my
> single item OLP wishlist: Plan stability.

That seems to me to translate to "I want the system to fail to react to
changes in data statistics and all other variables relevant to query
planning".

You can pretty much get that by never doing [VACUUM] ANALYZE, but I'm
quite lost as to why it's really a good idea.

			regards, tom lane

In response to

Responses

pgsql-hackers by date

Next:From: Paul RamseyDate: 2002-12-01 04:45:28
Subject: Re: 7.4 To Do
Previous:From: David WheelerDate: 2002-12-01 04:24:17
Subject: Re: 7.4 Wishlist

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group