[teiid-issues] [JBoss JIRA] (TEIID-3796) It is much more slow to get the table record through TEIID from postgresql DB

[Xian Liu (JIRA)]

     [ https://issues.jboss.org/browse/TEIID-3796?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Xian Liu updated TEIID-3796:
----------------------------
    Description: 
There is a table about 1000K+ record
Postgresql Version: server 9.2.7
JDBC Driver Version: postgresql-9.3-1103.jdbc4.jar
The table definition:
{code}
 |            Type             |                         Modifiers                          
------------+-----------------------------+------------------------------------------------------------
| integer                     | not null
| integer                     | 
| integer                     | not null
| timestamp without time zone | not null
| integer                     | not null
| text                        | 
| text                        | 
| bigint                      | 
| bigint                      | not null 
| integer                     | 

{code}
I set driver connection parameter to disableLocalTxn=true;FetchSize=10,
1. When I make this table available in Mysql, and select * from it in Teiid, It will quickly get the data stream after around 30s.
2. But when I make this table in Postgresql DB, and query through Teiid, it is so slow and will get about 8min+ client can not get the data stream, 
 when I try to directly connect this table in Postgresql table, it is much more faster, I do not know the reason.

  was:
There is a table about 1000K+ record
The table definition:
{code}
 |            Type             |                         Modifiers                          
------------+-----------------------------+------------------------------------------------------------
| integer                     | not null
| integer                     | 
| integer                     | not null
| timestamp without time zone | not null
| integer                     | not null
| text                        | 
| text                        | 
| bigint                      | 
| bigint                      | not null 
| integer                     | 

{code}
When I make it available in Teiid, and set driver connection parameter to disableLocalTxn=true;FetchSize=10; It will quickly get the data stream.
But when I make this in Postgresql DB, and query through Teiid, it is so slow and will get about 8min+, the client can not get the data stream, what's reason, when I try to directly connect postgresql, it is much more faster.



> It is much more slow to get the table record through TEIID from postgresql DB
> -----------------------------------------------------------------------------
>
>                 Key: TEIID-3796
>                 URL: https://issues.jboss.org/browse/TEIID-3796
>             Project: Teiid
>          Issue Type: Feature Request
>            Reporter: Xian Liu
>            Assignee: Steven Hawkins
>
> There is a table about 1000K+ record
> Postgresql Version: server 9.2.7
> JDBC Driver Version: postgresql-9.3-1103.jdbc4.jar
> The table definition:
> {code}
>  |            Type             |                         Modifiers                          
> ------------+-----------------------------+------------------------------------------------------------
> | integer                     | not null
> | integer                     | 
> | integer                     | not null
> | timestamp without time zone | not null
> | integer                     | not null
> | text                        | 
> | text                        | 
> | bigint                      | 
> | bigint                      | not null 
> | integer                     | 
> {code}
> I set driver connection parameter to disableLocalTxn=true;FetchSize=10,
> 1. When I make this table available in Mysql, and select * from it in Teiid, It will quickly get the data stream after around 30s.
> 2. But when I make this table in Postgresql DB, and query through Teiid, it is so slow and will get about 8min+ client can not get the data stream, 
>  when I try to directly connect this table in Postgresql table, it is much more faster, I do not know the reason.



--
This message was sent by Atlassian JIRA
(v6.4.11#64026)