Re: Index scan startup time - Mailing list pgsql-performance

From Peter Eisentraut
Subject Re: Index scan startup time
Date
Msg-id 200603301716.13840.peter_e@gmx.net
Whole thread Raw
In response to Re: Index scan startup time  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: Index scan startup time  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-performance
Tom Lane wrote:
> The problem here appears to be a non-random correlation between state
> and activity, such that the desired state values are not randomly
> scattered in the activity sequence.  The planner doesn't know about
> that correlation and hence can't predict the poor startup time.

So from when to when is the startup time (the "x" in "x..y") actually
measured?  When does the clock start ticking and when does it stop?
That is what's confusing me.

--
Peter Eisentraut
http://developer.postgresql.org/~petere/

pgsql-performance by date:

Previous
From: "Dave Dutcher"
Date:
Subject: Re: [Solved] Slow performance on Windows .NET and OleDb
Next
From: Tom Lane
Date:
Subject: Re: CREATE INDEX rather sluggish