On Mon, Mar 12, 2012 at 3:06 AM, Nur Hidayat <[email protected]> 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 ([email protected]) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
