[ADMIN] using explain output within pgsql

2011-07-10 Thread Uwe Bartels
Hi, I'm starting up a datawarehouse with patitioning. my etl processes write directly into the corresponding partitions instead of using triggers. The reports I run in the datawarehouse are stored in a cache within the same database. Now I'd like to store besides the results the dependencies to t

Re: [ADMIN] Using Explain

2007-07-25 Thread Steve Holdoway
On Wed, 25 Jul 2007 12:38:31 + "Vishal Arora" <[EMAIL PROTECTED]> wrote: > > > > >From: "Milen A. Radev" <[EMAIL PROTECTED]> > >To: pgsql-admin@postgresql.org > >Subject: Re: [ADMIN] Using Explain > >Date: Wed, 25 Jul 2007 14

Re: [ADMIN] Using Explain

2007-07-25 Thread Vishal Arora
From: "Milen A. Radev" <[EMAIL PROTECTED]> To: pgsql-admin@postgresql.org Subject: Re: [ADMIN] Using Explain Date: Wed, 25 Jul 2007 14:26:57 +0300 Vishal Arora написа: > > Hi All, > > I was looking for extensive tutorial for Explain, Plan-reading.

Re: [ADMIN] Using Explain

2007-07-25 Thread Milen A. Radev
Vishal Arora написа: > > Hi All, > > I was looking for extensive tutorial for Explain, Plan-reading. The > postgres manual is not exhaustive enough. > > It would be great if somone has a link to some documentation which gives > some more in depth information about EXPLAIN / Plan Reading > http

[ADMIN] Using Explain

2007-07-25 Thread Vishal Arora
Hi All, I was looking for extensive tutorial for Explain, Plan-reading. The postgres manual is not exhaustive enough. It would be great if somone has a link to some documentation which gives some more in depth information about EXPLAIN / Plan Reading Thanks Vishal ___