In response to "Satish Burnwal (sburnwal)" <sburnwal@xxxxxxxxx>: > controlsmartdb=# \d repcopy; > Table "public.repcopy" > Column | Type | Modifiers > -----------------+--------------------------------+----------- > report_id | integer | not null > dm_ip | character varying(64) | > dm_mac | character varying(64) | > dm_user | character varying(255) | > dm_os | character varying(64) | > report_time | timestamp(0) without time zone | > sys_name | character varying(255) | > sys_user | character varying(255) | > sys_user_domain | character varying(255) | > ss_key | character varying(128) | > login_time | character varying(64) | > role_id | smallint | > new_vlan_id | character varying(64) | > report_status | smallint | > Indexes: > "repcopy_pk" PRIMARY KEY, btree (report_id) Unless you truncated this output, you _really_ need to add some indexes to this table. Read back through earlier messages in the thread for suggestions. -- Bill Moran http://www.potentialtech.com http://people.collaborativefusion.com/~wmoran/ -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
