Re: [GENERAL] explain plan visibility

2012-11-12 Thread Albe Laurenz
高健 wrote: Please let me dig it a little more: I think that when a session is accessing a postgersql table. It will be influenced by the followings: Really old data (needed to be vacuumed, eg: old image at one day ago). Recent data (committed and uncommitted), because they are

Re: [GENERAL] explain plan visibility

2012-11-11 Thread 高健
Hi Laurenz: Thank you for your kind reply. Please let me dig it a little more: I think that when a session is accessing a postgersql table. It will be influenced by the followings: Really old data (needed to be vacuumed, eg: old image at one day ago). Recent data (committed and

[GENERAL] explain plan visibility

2012-11-09 Thread 高健
Hi all: I have one question about the visibility of explain plan. Firstly , I was inserting into data to a table. I use : [ insert into ptest select * from test02; ] And test02 table has 10,000,000 records. And ptest is a parent table, which has two distribution child table ---

Re: [GENERAL] explain plan visibility

2012-11-09 Thread Albe Laurenz
高健 wrote: I have one question about the visibility of explain plan. Firstly , I was inserting into data to a table. I use : [ insert into ptest select * from test02; ] And test02 table has 10,000,000 records. And ptest is a parent table, which has two distribution child