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

Re: Tuning planner cost estimates

From: Josh Berkus <josh(at)agliodbs(dot)com>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: "Jim C(dot) Nasby" <decibel(at)decibel(dot)org>,pgsql-performance(at)postgresql(dot)org
Subject: Re: Tuning planner cost estimates
Date: 2005-05-19 17:21:05
Message-ID: (view raw, whole thread or download thread mbox)
Lists: pgsql-performance

> 	for rec in explain analyze ... loop
> 		insert into table values(rec."QUERY PLAN");
> 	end loop;

I need to go further than that and parse the results as well.  And preserve 
relationships and nesting levels.   

Hmmmm ... what's the indenting formula for nesting levels?

Josh Berkus
Aglio Database Solutions
San Francisco

In response to

pgsql-performance by date

Next:From: Anjan DaveDate: 2005-05-19 18:12:29
Subject: Re: PostgreSQL strugling during high load
Previous:From: Tom LaneDate: 2005-05-19 17:16:21
Subject: Re: Tuning planner cost estimates

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