On Mon, Mar 12, 2012 at 3:06 AM, Nur Hidayat <hidayat...@gmail.com> wrote: > I once have the same problem. In my case it's because most of my table using > text datatype. > When I change the field type to character varying (1000) database size > reduced significantly
I'll bet what happened was postgres re-wrote your table for you, effectively doing a compaction. You can get similar effect by doing an alter table and "changing" an INTEGER field to be INTEGER. Postgres does not optimize that do a no-op, so you get the re-writing effect. -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
