Re: What's faster?

> Because Postgres requires VACUUM ANALYZE more frequently on updated tables,
> should I break this single field out into its own table, and if so what kind
> of a speed up can I expect to achieve. I would be appreciative of any
> guidance offered.

Unless that field is part of the key, I wouldn't think that a vacuum
analyze would be needed, as the key distribution isn't changing.

I don't know if that is still true if that field is indexed.  Tom?

Even then, as I understand things vacuum analyze doesn't rebuild indexes,
so I could see a need to drop and rebuild indexes on a regular basis,
even if you move that field into a separate table.
--
Mike Nolan