In database session when doing replication

More
4 years 11 months ago #12489 by kaoru
kaoru created the topic: 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

Please Log in or Create an account to join the conversation.

More
4 years 11 months ago #12510 by Moderator
Moderator replied the topic: Re: In database session when doing replication
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".

Please Log in or Create an account to join the conversation.

More
4 years 11 months ago #12518 by kaoru
kaoru replied the topic: Re: In database session when doing replication
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

Please Log in or Create an account to join the conversation.

Time to create page: 0.053 seconds
Powered by Kunena Forum