pg noob writes:
> I'm looking at this query plan, an excerpt of which is shown here, and I am
> just wondering how the estimated cost for the Nested Loop is calculated?
http://www.postgresql.org/docs/9.2/static/using-explain.html
There's a nestloop example about a third of the way down the page
Hi all,
I'm looking at this query plan, an excerpt of which is shown here, and I am
just wondering how the estimated cost for the Nested Loop is calculated?
-> Nested Loop (*cost=0.00..2888.16* rows=240 width=16) (actual
time=0.034..2.180 rows=91 loops=1)
Output: public.mg.lctime, public.
On Monday, March 25, 2013, Colin Currie wrote:
> Hi,
>
> I recently upgraded PostgreSQL from 9.0.12 to 9.2.3 on a test server to
> compare performance. I'm using pgbench to measure which results in around a
> 60% reduction.
>
> The non-default configuration remains identical between versions excep
