-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 On 02/22/07 17:17, Jim Nasby wrote: > On Feb 21, 2007, at 10:26 AM, Scott Marlowe wrote: >> The only thing I can think of that rewrites a whole postgresql table >> would be reindexing it, or an update without a where clause (or a where >> clause that includes every row). Normal operations, like create index, >> add column, drop column, etc do not need to rewrite the table and happen >> almost instantly. > > Reindexing won't re-write a table; clustering will. Also some ALTER > TABLE commands will (such as changing the data type of a column, or > creating a new column that's NOT NULL). Man, that's just Not Right. -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.4.6 (GNU/Linux) iD8DBQFF3itiS9HxQb37XmcRAqnWAJ0R9MmdmlUR92B3F81vlGI/D7Es8ACgmiKI F6BrBA/ZeTsciqJAdiYfTCo= =KJDL -----END PGP SIGNATURE-----
