On Sunday 11 January 2009 5:21:46 pm Phoenix Kiula wrote: > On Mon, Jan 12, 2009 at 9:12 AM, Ian Barwick <barwick@xxxxxxxxx> wrote: > > 2009/1/12 Phoenix Kiula <phoenix.kiula@xxxxxxxxx>: > >> I am trying to resize a column on a large-ish database (with 5 million > >> rows). > > > > ALTER TABLE users ALTER COLUMN name TYPE VARCHAR(35) > > > > HTH > > Thanks! I guess I was missing the word "TYPE". This won't affect my > "not null" on the column right? > > Also, is there a safe and fast way of doing this on a live database, > without bringing it down if possible? This is an indexed column so I > wonder if that will slow up the process quite a bit? >From the fine manual: http://www.postgresql.org/docs/8.3/interactive/sql-altertable.html "Adding a column with a non-null default or changing the type of an existing column will require the entire table to be rewritten. This might take a significant amount of time for a large table; and it will temporarily require double the disk space." -- Adrian Klaver aklaver@xxxxxxxxxxx -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
