[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] [SQL] using explain output within pgsql

2011-07-10 Thread Adrian Klaver
On Sunday, July 10, 2011 11:54:10 am Uwe Bartels wrote: > 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 d

Re: [ADMIN] [SQL] using explain output within pgsql

2011-07-10 Thread Pavel Stehule
Hello 2011/7/10 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 t

Re: [ADMIN] [SQL] using explain output within pgsql

2011-07-10 Thread Uwe Bartels
Hi Adrian, yes. but this is not the cause for the syntax error. thanks, Uwe On 10 July 2011 21:20, Adrian Klaver wrote: > On Sunday, July 10, 2011 11:54:10 am Uwe Bartels wrote: > > Hi, > > > > I'm starting up a datawarehouse with patitioning. > > my etl processes write directly into the co

Re: [ADMIN] [SQL] using explain output within pgsql

2011-07-10 Thread Uwe Bartels
Hi Pavel, I don't believe it. the second answer on sunday evening within half an hour. and it works. excellent!!! best regards, Uwe On 10 July 2011 21:20, Pavel Stehule wrote: > Hello > > > > 2011/7/10 Uwe Bartels : > > Hi, > > > > I'm starting up a datawarehouse with patitioning. > > my etl

Re: [ADMIN] [SQL] using explain output within pgsql

2011-07-10 Thread Uwe Bartels
Hi Pavel, is it posible to get this running even with dynamic sql? I didn't write that. I'm using execute to run this create table best regards, Uwe On 10 July 2011 21:20, Pavel Stehule wrote: > Hello > > > > 2011/7/10 Uwe Bartels : > > Hi, > > > > I'm starting up a datawarehouse with pat

Re: [ADMIN] [SQL] using explain output within pgsql

2011-07-10 Thread Pavel Stehule
2011/7/10 Uwe Bartels : > Hi Pavel, > > is it posible to get this running even with dynamic sql? > I didn't write that. I'm using execute to run this create table > probably yes postgres=# do $$ declare x text; begin execute e'explain(format yaml) select * from data where value = \'a\'' int