How do I know if autovacuum is reclaiming space or is my max_fsm setting
plain wrong. (I understand that autovacuum marks tuples for reuse, but
shouldn't pg_total_relation_size take that into account)
You can find out if your FSM settings are big enough by running vacuumdb
-av (and yes, it n
On Thu, Jun 15, 2006 at 10:26:59AM +0530, Praveen Kumar N wrote:
> I have observed that the size of data (for example size of
> table in a database) stored by database system on physical storage is
> more than actual datasize.It seems database is storing data in some
> format.For example
I am in the process of writing a migration utility to move data from a
SQL Server to PostgreSQL. The original schema contains identity fields.
When converting the schema, I have 2 option - either make them serial
(or bigserisl) columns, with the associated automatic constraint, or
declaring the as
Thanks. I just looked at the definition and see it is a default value,
so I should be safe just pumping the data over.
On completion of the import I plan to reseed he sequence generator.
-Original Message-
From: Juan Miguel Paredes [mailto:[EMAIL PROTECTED]
Sent: Thursday, June 15, 2006
unsubscribe pgsql-admin
--
Patricia Megumi Matsumoto <[EMAIL PROTECTED]>
---(end of broadcast)---
TIP 2: Don't 'kill -9' the postmaster
