On 2005-03-19, Stephan Szabo <[EMAIL PROTECTED]> wrote:
> On Fri, 18 Mar 2005, Tom Lane wrote:
>> Hm. One thing we could do is to throw in some default values when we
>> see the table has exactly zero pages --- perhaps ye olde traditional
>> 1000/10, or possibly something else, but anyway not exac
On Fri, 18 Mar 2005, Tom Lane wrote:
> Andrew - Supernews <[EMAIL PROTECTED]> writes:
> > It turns out that the scenario above is trivial to hit in 8.0 using
> > referential constraints; RI triggers cache their plans, and on 8.0 the RI
> > query is planned as a seqscan if the tables are freshly cr
Andrew - Supernews <[EMAIL PROTECTED]> writes:
> It turns out that the scenario above is trivial to hit in 8.0 using
> referential constraints; RI triggers cache their plans, and on 8.0 the RI
> query is planned as a seqscan if the tables are freshly created. (On 7.4
> the plan is an index scan, th
On 2005-03-14, Tom Lane <[EMAIL PROTECTED]> wrote:
> The 8.0 planner is intentionally sensitive to the current actual
> physical sizes of tables. It sounds like you've managed to get it to
> plan something on the assumption that the tables are tiny and keep
> using that plan after they aren't tiny
On Mar 14, 2005, at 12:13 AM, Tom Lane wrote:
"John Engelhart" <[EMAIL PROTECTED]> writes:
Since I'm developing an SQL based application, I routinely "start from
scratch" with a script that deletes all the tables in my database and
rebuilds them. A problem started when I upgraded from 7.4.7 to 8.0
"John Engelhart" <[EMAIL PROTECTED]> writes:
> Since I'm developing an SQL based application, I routinely "start from
> scratch" with a script that deletes all the tables in my database and
> rebuilds them. A problem started when I upgraded from 7.4.7 to 8.0.1 in
> that the first run after the cle
The following bug has been logged online:
Bug reference: 1541
Logged by: John Engelhart
Email address: [EMAIL PROTECTED]
PostgreSQL version: 8.0.1
Operating system: FreeBSD 5.3-p5
Description:Unusually long INSERT times after fresh clean/CREATE
TABLES
Details:
Recen
