| From: | Pavan Deolasee <pavan(dot)deolasee(at)gmail(dot)com> |
|---|---|
| To: | Rajagopalan Ramanujam <Rajagopalan(dot)R(at)repucom(dot)net> |
| Cc: | "pgsql-admin(at)postgresql(dot)org" <pgsql-admin(at)postgresql(dot)org> |
| Subject: | Re: Will analyze run on a database affect writes? |
| Date: | 2013-08-29 11:27:12 |
| Message-ID: | CABOikdOaD1ASmjx_AAviShEWXZasjPaQky7eSy-qK180z4Bupg@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-admin |
On Wed, Aug 28, 2013 at 8:19 PM, Rajagopalan Ramanujam <
Rajagopalan(dot)R(at)repucom(dot)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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Bocap | 2013-08-29 13:54:26 | Using of replication by initdb for both nodes? |
| Previous Message | Rajagopalan Ramanujam | 2013-08-28 14:49:24 | Will analyze run on a database affect writes? |