Received: from sss.pgh.pa.us (unknown [192.204.191.242]) by postgresql.org (Postfix) with ESMTP id 217BB4759A1 for ; Mon, 4 Mar 2002 18:16:43 -0500 (EST) Received: from sss2.sss.pgh.pa.us (tgl@localhost [127.0.0.1]) by sss.pgh.pa.us (8.11.4/8.11.4) with ESMTP id g24NGYS09167; Mon, 4 Mar 2002 18:16:34 -0500 (EST) To: Matthew Price Cc: pgsql-sql@postgresql.org Subject: Re: Changing sequence cache In-reply-to: <20020304.130237.19811.60399@wm7.jersey.juno.com> References: <20020304.130237.19811.60399@wm7.jersey.juno.com> Comments: In-reply-to Matthew Price message dated "Mon, 04 Mar 2002 18:02:37 +0000" Date: Mon, 04 Mar 2002 18:16:33 -0500 Message-ID: <9164.1015283793@sss.pgh.pa.us> From: Tom Lane X-Archive-Number: 200203/52 X-Sequence-Number: 6934 Matthew Price writes: > I already have a sequence named customers_custid_seq > I would like to increase the cache setting some. How can i alter the cache after the sequence has already been created? You can't, but there's no reason you shouldn't drop and recreate the sequence. regards, tom lane