]
Steven Hawkins commented on TEIID-3796:
---------------------------------------
Is there any update on the details here? If not we'll resolve as incomplete
description for now.
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: Bug
Reporter: Xian Liu
Assignee: Steven Hawkins
There is a table about 1000K+ record
Postgresql Version: server 9.2.7
Postgresql DB 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.