From: | "Kumar, Virendra" <Virendra(dot)Kumar(at)guycarp(dot)com> |
---|---|
To: | Ron <ronljohnsonjr(at)gmail(dot)com>, "pgsql-general(at)lists(dot)postgresql(dot)org" <pgsql-general(at)lists(dot)postgresql(dot)org> |
Subject: | RE: why select count(*) consumes wal logs |
Date: | 2018-11-06 17:38:38 |
Message-ID: | b679068d5f1b4d0e99463cf646121059@USFKL11XG20CN01.mercer.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
I concord.
Why VACUUM when there is no update or deletes.
Regards,
Virendra
From: Ron [mailto:ronljohnsonjr(at)gmail(dot)com]
Sent: Tuesday, November 06, 2018 12:20 PM
To: pgsql-general(at)lists(dot)postgresql(dot)org
Subject: Re: why select count(*) consumes wal logs
On 11/06/2018 11:12 AM, Michael Nolan wrote:
On Tue, Nov 6, 2018 at 11:08 AM Ravi Krishna <srkrishna1(at)aol(dot)com<mailto:srkrishna1(at)aol(dot)com>> wrote:
PG 10.5
I loaded 133 million rows to a wide table (more than 100 cols) via COPY.
It's always a good idea after doing a large scale data load to do a vacuum analyze on the table (or the entire database.)
I understand the need to ANALYZE (populate the histograms needed by the dynamic optimizer), but why VACUUM (which is recommended after updates and deletes).
Thanks
--
Angular momentum makes the world go 'round.
________________________________
This message is intended only for the use of the addressee and may contain
information that is PRIVILEGED AND CONFIDENTIAL.
If you are not the intended recipient, you are hereby notified that any
dissemination of this communication is strictly prohibited. If you have
received this communication in error, please erase all copies of the message
and its attachments and notify the sender immediately. Thank you.
From | Date | Subject | |
---|---|---|---|
Next Message | Tom Lane | 2018-11-06 17:40:11 | Re: why select count(*) consumes wal logs |
Previous Message | Ron | 2018-11-06 17:19:54 | Re: why select count(*) consumes wal logs |