From: Andrew Lazarus <andrew@pillette.com>
To: pgsql-performance@postgresql.org
Subject: What *_mem to increase when running CLUSTER
Date: Thu, 25 Aug 2005 12:24:38 -0700
Message-ID: <430E1AF6.9030803@pillette.com> (raw)
In-Reply-To: <6EE64EF3AB31D5448D0007DD34EEB3417DD1D2@Herge.rcsinc.local>
References: <6EE64EF3AB31D5448D0007DD34EEB3417DD1D2@Herge.rcsinc.local>
Should I temporarily increase sort_mem, vacuum_mem, neither, or both
when doing a CLUSTER on a large (100 million row) table where as many as
half of the tuples are deadwood from UPDATEs or DELETEs? I have large
batch (10 million row) inserts, updates, and deletes so I'm not sure
frequent vacuuming would help.
Attachments:andrew.vcf (text/x-vcard, 296B) download
begin:vcard
fn:Andrew Lazarus
n:Lazarus;Andrew
org:Pillette Investment Management;Research and Development
adr;dom:;;3028 Fillmore;San Francisco;CA;94123
email;internet:andrew@pillette.com
title:Director
tel;work:800-366-0688
tel;fax:415-440-4093
url:http://www.pillette.com
version:2.1
end:vcard
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-performance@postgresql.org
Cc: andrew@pillette.com
Subject: Re: What *_mem to increase when running CLUSTER
In-Reply-To: <430E1AF6.9030803@pillette.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox