Postgres Pro
Downloads
Home   >   mailing lists

What *_mem to increase when running CLUSTER - Mailing list pgsql-performance

From Andrew Lazarus
Subject What *_mem to increase when running CLUSTER
Date
Msg-id 430E1AF6.9030803@pillette.com
Whole thread Raw
In response to Re: Need for speed 2  ("Merlin Moncure" <merlin.moncure@rcsonline.com>)
Responses Re: What *_mem to increase when running CLUSTER  (Steve Poe <spoe@sfnet.cc>)
Re: What *_mem to increase when running CLUSTER  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-performance
Tree view 
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.
Attachment

pgsql-performance by date:

Previous
From: Kelly Burkhart
Date:
Subject: Re: Need for speed 2
Next
From: Steve Poe
Date:
Subject: Re: What *_mem to increase when running CLUSTER