Re: [Postgres-xc-developers] Query Planning bug ?

[鈴木 幸市 <ko...@in...>]

Thanks Michael for the input.   This is what I remembered.
---
Koichi Suzuki



On 2013/06/05, at 14:03, Michael Paquier <mic...@gm...> wrote:

> 
> 
> 
> On Wed, Jun 5, 2013 at 1:39 PM, Ashutosh Bapat <ash...@en...> wrote:
> 
> 
> 
> On Wed, Jun 5, 2013 at 9:57 AM, Tomonari Katsumata <kat...@po...> wrote:
> Hi Suzuki-san, Ashutosh,
> 
> >Suzuki-san
> I don't make any user tables.
> As the simple example I sent before, I use only system-catalogs.
> 
> >Ashtosh
> I'm developing database monitor tool and
> I use "EXECUTE DIRECT" to get database statistics data from
> particular coordinator/datanode.
> 
> :) huh 
> 
> I think, monitoring tools should directly query the datanodes or coordinators. You will get snapshot warning, but that can be ignored I guess.
> Worth mentioning that it is not the case for 1.1:
> https://github.com/postgres-xc/postgres-xc/commit/fe9985c168d85738e5d88ed9407b840449f31b75 
> You get a clean snapshot for read queries run directly from Datanodes.
> 
> If they start querying coordinators, there will be performance drop since coordinators directly handle the clients.
> Yep.
> -- 
> Michael
> ------------------------------------------------------------------------------
> How ServiceNow helps IT people transform IT departments:
> 1. A cloud service to automate IT design, transition and operations
> 2. Dashboards that offer high-level views of enterprise services
> 3. A single system of record for all IT processes
> http://p.sf.net/sfu/servicenow-d2d-j_______________________________________________
> Postgres-xc-developers mailing list
> Pos...@li...
> https://lists.sourceforge.net/lists/listinfo/postgres-xc-developers