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

[Ashutosh B. <ash...@en...>]

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. If they start querying coordinators, there will be performance drop
since coordinators directly handle the clients.

Any other thoughts?

> regard,
>
> ---------
> NTT Software Corporation
> Tomonari Katsumata
>
> (2013/06/04 13:10), Ashutosh Bapat wrote:
>
>> Hi Tomonari,
>>
>> Thanks for the bug report.
>>
>> I am curious to know, what's the purpose of using EXECUTE DIRECT? We
>> discourage using Execute Direct in the applications. It's only for
>> debugging purposes.
>>
>>
>> On Tue, Jun 4, 2013 at 7:28 AM, Koichi Suzuki <koi...@gm...>
>> **wrote:
>>
>>  Thank you Katsumata-san for the report.
>>>
>>> Could you provide CREATE TABLE statement for each table involved with
>>> some
>>> of the data?
>>>
>>> I will ad this to the bug tracker after I recreate the issue.
>>>
>>> Best Regards;
>>>
>>> ----------
>>> Koichi Suzuki
>>>
>>>
>>> 2013/6/4 Tomonari Katsumata <katsumata.tomonari@po.ntts.**co.jp<kat...@po...>
>>> >
>>>
>>>  Hi, I have a problem with query executing.
>>>>
>>>> I cant't have any response when I execute a query.
>>>> This problem occurs when some conditions are met.
>>>>
>>>> The conditions are below.
>>>> ------------------------------**------------------------------**
>>>> ---------
>>>> 1. Issuing "EXECUTE DIRECT" to Datanode(ofcourse, via Coordinator).
>>>>
>>>> 2. The Query Executing on Datanode has subquery on its FROM-clause.
>>>>
>>>> 3. In the subquery, it has a JOIN clause.
>>>>
>>>> 4. The Join clause is consisted with another subquery.
>>>> ------------------------------**------------------------------**
>>>> ---------
>>>>
>>>>
>>>> Simple example query is below.
>>>> ------------------------------**------------------------------**---
>>>> EXECUTE DIRECT ON (data1) $$
>>>> SELECT
>>>> count(*)
>>>> FROM
>>>> (SELECT * FROM pg_locks l LEFT JOIN
>>>> (SELECT * FROM pg_stat_activity) s ON l.database = s.datid) a
>>>> $$
>>>> ------------------------------**------------------------------**---
>>>>
>>>> FYI:
>>>> This query works fine with Postgres-XC 1.0.3.
>>>> Is this already known bug ?
>>>>
>>>>
>>>> How can I avoid this problem ?
>>>> And what kind of info do you need to investigate it ?
>>>>
>>>> ----------
>>>> NTT Software Corporation
>>>> Tomonari Katsumata
>>>>
>>>>
>>>>
>>>>
>>>> ------------------------------**------------------------------**
>>>> ------------------
>>>> 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<http://p.sf.net/sfu/servicenow-d2d-j>
>>>> ______________________________**_________________
>>>> Postgres-xc-developers mailing list
>>>> Postgres-xc-developers@lists.**sourceforge.net<Pos...@li...>
>>>> https://lists.sourceforge.net/**lists/listinfo/postgres-xc-**developers<https://lists.sourceforge.net/lists/listinfo/postgres-xc-developers>
>>>>
>>>>
>>>
>>> ------------------------------**------------------------------**
>>> ------------------
>>> 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<http://p.sf.net/sfu/servicenow-d2d-j>
>>> ______________________________**_________________
>>> Postgres-xc-developers mailing list
>>> Postgres-xc-developers@lists.**sourceforge.net<Pos...@li...>
>>> https://lists.sourceforge.net/**lists/listinfo/postgres-xc-**developers<https://lists.sourceforge.net/lists/listinfo/postgres-xc-developers>
>>>
>>>
>>>
>>
>
> --
> ------------------------------**--------------
> NTTソフトウェア株式会社
>   技術開発センター OSS基盤技術部門
>   勝俣 智成
> TEL：045-212-7665
> FAX：045-662-7856
> E-Mail: kat...@po....**jp<kat...@po...>
> ------------------------------**--------------
>
>
>


-- 
Best Wishes,
Ashutosh Bapat
EntepriseDB Corporation
The Postgres Database Company