On Tue, Mar 29, 2011 at 08:27:25PM +0300, Ibrahim Harrani wrote: > > > How did you change the fillfactor? You would need to do an alter > > table followed by a cluster to rewrite the table and include the > > freespace required by the fillfactor. Is that how you performed > > that operation. You could also do a full copy to a new table with > > the correct fillfactor. > > I simply issued > ALTER TABLE dspam_token_data SET ( FILLFACTOR = 90 ); > But I did not make a fully copy on the table. > Can you give me an example how to issue cluster on the table? >
CLUSTER dspam_token_data USING dspam_token_data_uid_key; This command will rewrite the table with the correct fill-factor and allow HOT updates to work. Cheers, Ken ------------------------------------------------------------------------------ Enable your software for Intel(R) Active Management Technology to meet the growing manageability and security demands of your customers. Businesses are taking advantage of Intel(R) vPro (TM) technology - will your software be a part of the solution? Download the Intel(R) Manageability Checker today! http://p.sf.net/sfu/intel-dev2devmar _______________________________________________ Dspam-user mailing list Dspam-user@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/dspam-user
