In database session when doing replication

Hi,

I'm currently debugging my SSIS replication from Source system to Greenplum.
A few days ago I have timeout issue, some of the packages get timeout error.
My last setting is COMMAND_TIMEOUT=1200, now I have to set COMMAND_TIMEOUT=12000.

When I looked into the session tracker, I found something strange repeated queries :
- select count(*)::float4
- select avg(pg_column_size(Ta.description))::float4
it seems that it looped all the column and start doing those count and avg ...

My question is :
- is that code normal ?
- will that impacted on query performance ?

Thank u

Probably not. The OLEDB provider does not generate the queries. Try to change some replication parameters, and see if the queries are no longer issued.

Also, consider using PGNP Optimizer to change queries "on-the-fly".

Hi,
Last time we experienced an database error.. so that count query popped up.
Confirmed now we're not having it again, and the performance is going back to normal.

thank u