Re: postgresql vs mysql

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).
--
Jim Nasby                                            jim@nasby.net
EnterpriseDB      http://enterprisedb.com      512.569.9461 (cell)