Thank you very much in advance for any pointers you can
provide.  And, if this is the wrong forum for this question,
please let me know and I'll ask it elsewhere.


I think you may want to increase your statistics_target plus make sure you are running analyze. explain anaylze would do.

Sincerely,

Joshua D. Drake




JohnM





-----
table definitions
-----

-----
db=> \d contacts
                       Table "db.contacts"
Column | Type | Modifiers ------------------------------+-----------------------------+-----------
 id                           | numeric(38,0)               | not null
db_id | character varying(32) | firstname | character varying(64) | lastname | character varying(64) | company | character varying(128) | email | character varying(256) | phone | character varying(64) | address | character varying(128) | city | character varying(128) | state | character varying(32) | postalcode | character varying(16) | country | character varying(2) | not null contact_info_modified | character(1) | token_id | numeric(38,0) | status_id | numeric(38,0) | status_last_modified | timestamp without time zone | notes | character varying(2000) | demo_schedule | timestamp without time zone | partner_id | numeric(38,0) | prev_partner_id | numeric(38,0) | prev_prev_partner_id | numeric(38,0) | site_last_visited | timestamp without time zone | source_id | numeric(4,0) | demo_requested | timestamp without time zone | sourcebook_requested | timestamp without time zone | zip | numeric(8,0) | suffix | numeric(8,0) | feedback_request_sent | timestamp without time zone | products_sold | character varying(512) | other_brand | character varying(512) | printsample_requested | timestamp without time zone | indoor_media_sample | timestamp without time zone | outdoor_media_sample | timestamp without time zone | printers_owned | character varying(256) | business_type | character varying(256) | printers_owned2 | character varying(256) | contact_quality_id | numeric(38,0) | est_annual_value | numeric(38,2) | likelyhood_of_closing | numeric(38,0) | priority | numeric(38,0) | business_type_id | numeric(38,0) | lead_last_modified | timestamp without time zone | lead_value | numeric(38,2) | channel_contact_flag | character(1) | request_status_last_modified | timestamp without time zone | master_key_number | numeric(38,0) | master_key_token | character varying(32) | current_media_cust | character(1) | kodak_media_id | numeric(38,0) | printer_sample_id | numeric(38,0) | quantity_used_id | numeric(38,0) | rip_used_id | numeric(38,0) | language_code | character varying(3) | region_id | numeric(38,0) | not null lead_deleted | timestamp without time zone | last_request_set_status_id | numeric(38,0) | address2 | character varying(128) | media_usage_id | numeric(38,0) | Indexes:
    "contacts_pkey" primary key, btree (id)
    "contacts_partner_id_idx" btree (partner_id)
    "contacts_partner_id_null_idx" btree (partner_id) WHERE (partner_id IS NULL)
    "contacts_token_id_idx" btree (token_id)
Check constraints:
    "sys_c0050644" CHECK (country IS NOT NULL)
    "sys_c0050643" CHECK (id IS NOT NULL)
    "sys_c0050645" CHECK (region_id IS NOT NULL)
Triggers:
    insert_master_key BEFORE INSERT ON contacts FOR EACH ROW EXECUTE PROCEDURE 
pg_fct_insert_master_key()
-----

-----
db=> \d lead_requests
                 Table "db.lead_requests"
Column | Type | Modifiers -----------------------+-----------------------------+-----------
 id                    | numeric(38,0)               | not null
 contact_id            | numeric(38,0)               | not null
 request_id            | numeric(38,0)               | not null
 date_requested        | timestamp without time zone | not null
must_update_by | timestamp without time zone | date_satisfied | timestamp without time zone | status_id | numeric(38,0) | request_scheduled | timestamp without time zone | session_log_id | numeric(38,0) | notes | character varying(2000) | status_last_modified | timestamp without time zone | reminder_last_sent | timestamp without time zone | data | character varying(2000) | fulfillment_status_id | numeric(38,0) | Indexes:
    "lead_requests_pkey" primary key, btree (id)
    "lead_requests_contact_id_idx" btree (contact_id)
    "lead_requests_request_id_idx" btree (request_id)
Check constraints:
    "sys_c0049877" CHECK (request_id IS NOT NULL)
    "sys_c0049876" CHECK (contact_id IS NOT NULL)
    "sys_c0049878" CHECK (date_requested IS NOT NULL)
-----




--
Your PostgreSQL solutions company - Command Prompt, Inc. 1.800.492.2240
PostgreSQL Replication, Consulting, Custom Programming, 24x7 support
Managed Services, Shared and Dedicated Hosting
Co-Authors: plPHP, plPerlNG - http://www.commandprompt.com/

---------------------------(end of broadcast)---------------------------
TIP 7: don't forget to increase your free space map settings

Reply via email to