Re: add_path optimization

From: "Kevin Grittner" <Kevin(dot)Grittner(at)wicourts(dot)gov>
To: "Robert Haas" <robertmhaas(at)gmail(dot)com>, "Tom Lane" <tgl(at)sss(dot)pgh(dot)pa(dot)us>, "Kevin Grittner" <Kgrittn(dot)CCAP(dot)Courts(at)wicourts(dot)gov>
Cc: "pgsql-hackers(at)postgresql(dot)org" <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: add_path optimization
Date: 2009-02-03 16:39:54
Message-ID: 49881EFA.EE98.0025.0@wicourts.gov
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

>>> "Kevin Grittner" <Kevin(dot)Grittner(at)wicourts(dot)gov> wrote:
> Attached is EXPLAIN
> ANALYZE output from the 8.3.5 database I dumped from for my 8.4devel
> tests.

Actually, that one is from the sibling machine which is in production.

Attached is the one on standby where I've been running the rest of
this. Apparently, differences in the random samples lead to different
plans, so maybe having both will be of some use.

Apologies, but I'm having to work this in among other work.

-Kevin

Attachment Content-Type Size
explain-analyze2-8.3.5.txt text/plain 15.8 KB

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Andrew Dunstan 2009-02-03 16:40:15 Re: LIMIT NULL
Previous Message David E. Wheeler 2009-02-03 16:29:06 Re: LIMIT NULL