Thread: Will analyze run on a database affect writes?

Will analyze run on a database affect writes?

From
Rajagopalan Ramanujam
Date:

At a particular time, when an analyse is run on a database, we are uploading a bulk data from excel sheet. Will the analyse slows down the writes performed at that time?

 

Regards

Rajagopalan. RR

Rajagopalan Ramanujam
DB Admin

Phone +91 80 3981 8000
Mobile +91 9916934734
Fax +91 80 3981 8018
Email rajagopalan.r@repucom.net

Repucom Media Analysis India Pvt Ltd
104, 1st Floor, Prestige Omega,
EPIP Zone, Whitefield, Bangalore – 560 066
India 

repucom.net

Registered Office: 104, 1st Floor, Prestige Omega, EPIP Zone, Whitefield, Bangalore – 560 066 India. Registered in India
AMSTERDAM | BANGALORE | BARCELONA | BRUSSELS | BUENOS AIRES | CHARLOTTE | COLOGNE | COLUMBIA | DUBAI | JOHANNESBURG | KANSAS CITY | KARLSRUHE | LONDON | MELBOURNE | MILAN | NEW YORK | PARIS | SAO PAULO | SINGAPORE | SYDNEY | TOKYO | VANCOUVER

Follow us on:

 

This e-mail may contain confidential and/or privileged information. If you are not the intended recipient (or have received this e-mail in error) please notify the sender immediately and destroy this e-mail.


Attachment

Re: Will analyze run on a database affect writes?

From
Pavan Deolasee
Date:
On Wed, Aug 28, 2013 at 8:19 PM, Rajagopalan Ramanujam <Rajagopalan.R@repucom.net> wrote:

At a particular time, when an analyse is run on a database, we are uploading a bulk data from excel sheet. Will the analyse slows down the writes performed at that time?

 


I don't think it will considerably slow down bulk uploads. Analyze reads sample data from the table being analyzed to build statistics for planner to use. So there is definitely some read IO that will occur. But the extent of the reads will depend on the size of the table and statistics gathering settings.

AFAIK overhead of analyze can also be controlled by appropriate settings of vacuum cost parameter.

Thanks,
Pavan
  
--
Pavan Deolasee
http://www.linkedin.com/in/pavandeolasee