On Thu, Jun 10, 2010 at 11:32 AM, Anj Adu <fotographs@xxxxxxxxx> wrote: > Attached Hmm. Well, I'm not quite sure what's going on here, but I think you must be using a modified verison of PostgreSQL, because, as Tom pointed out upthread, we don't have a data type called "timestamp with time area". It would be called "timestamp with time zone". Can we see the index and table definitions of the relevant tables (attached as a text file) and the size of each one (use select pg_relation_size('name'))? -- Robert Haas EnterpriseDB: http://www.enterprisedb.com The Enterprise Postgres Company -- Sent via pgsql-performance mailing list (pgsql-performance@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance