Re: FW: Query length limitation in postgres server > 8.2.9 - Mailing list pgsql-sql

\d search_site1_2009_03_13
         Table "public.search_site1_2009_03_13"       Column        |          Type          | Modifiers
----------------------+------------------------+-----------item_id              | bigint                 | not
nulltransaction_id      | bigint                 | not nullsite_id              | smallint               | not
nullleaf_category_1     | integer                | not nullcurrent_price_usd    | numeric                | not
nullbuy_it_now_price_usd| numeric                |qty_sold             | integer                | not nullqty_avail
      | integer                | not nullauction_type         | smallint               | not nullflags                |
integer               | not nullseller_user_id       | bigint                 | not nullstart_price_usd      | numeric
             | not nulllisting_end_time     | time without time zone |days_since_sale      | smallint
|duration            | smallint               |hour                 | smallint               |bid_count            |
smallint              |buyer_id             | bigint                 |ship_from            | character varying
|ship_to             | character varying      |ship_cost            | numeric                |age                  |
smallint              |gender               | character(1)           |buyer_cntry_id       | smallint
|seller_cntry_id     | smallint               |selling_channel      | smallint               |transaction_site_id  |
smallint              |keyword_01_crc       | integer                |keyword_02_crc       | integer
|keyword_03_crc      | integer                |keyword_04_crc       | integer                |keyword_05_crc       |
integer               |keyword_06_crc       | integer                |keyword_07_crc       | integer
|keyword_08_crc      | integer                |keyword_09_crc       | integer                |keyword_10_crc       |
integer               |keyword_11_crc       | integer                |keyword_12_crc       | integer
|keyword_13_crc      | integer                |keyword_14_crc       | integer                |keyword_15_crc       |
integer               |keyword_16_crc       | integer                |keyword_17_crc       | integer
|keyword_18_crc      | integer                |keyword_19_crc       | integer                |attribute_value_01   |
bigint                |attribute_value_02   | bigint                 |attribute_value_03   | bigint
|attribute_value_04  | bigint                 |attribute_value_05   | bigint                 |attribute_value_06   |
bigint                |attribute_value_07   | bigint                 |attribute_value_08   | bigint
|attribute_value_09  | bigint                 |attribute_value_10   | bigint                 |upc_code             |
bigint                |isbn_code            | character varying      |mpn_code             | character varying
|relist_parent_id    | bigint                 | 
Indexes:   "search_site1_2009_03_13_isbn_code" btree (isbn_code, site_id) WHERE
isbn_code IS NOT NULL   "search_site1_2009_03_13_keyword_01_crc" btree (keyword_01_crc,
site_id) WHERE keyword_01_crc IS NOT NULL   "search_site1_2009_03_13_keyword_02_crc" btree (keyword_02_crc,
site_id) WHERE keyword_02_crc IS NOT NULL   "search_site1_2009_03_13_keyword_03_crc" btree (keyword_03_crc,
site_id) WHERE keyword_03_crc IS NOT NULL   "search_site1_2009_03_13_keyword_04_crc" btree (keyword_04_crc,
site_id) WHERE keyword_04_crc IS NOT NULL   "search_site1_2009_03_13_keyword_05_crc" btree (keyword_05_crc,
site_id) WHERE keyword_05_crc IS NOT NULL   "search_site1_2009_03_13_keyword_06_crc" btree (keyword_06_crc,
site_id) WHERE keyword_06_crc IS NOT NULL   "search_site1_2009_03_13_keyword_07_crc" btree (keyword_07_crc,
site_id) WHERE keyword_07_crc IS NOT NULL   "search_site1_2009_03_13_keyword_08_crc" btree (keyword_08_crc,
site_id) WHERE keyword_08_crc IS NOT NULL   "search_site1_2009_03_13_keyword_09_crc" btree (keyword_09_crc,
site_id) WHERE keyword_09_crc IS NOT NULL   "search_site1_2009_03_13_keyword_10_crc" btree (keyword_10_crc,
site_id) WHERE keyword_10_crc IS NOT NULL   "search_site1_2009_03_13_keyword_11_crc" btree (keyword_11_crc,
site_id) WHERE keyword_11_crc IS NOT NULL   "search_site1_2009_03_13_keyword_12_crc" btree (keyword_12_crc,
site_id) WHERE keyword_12_crc IS NOT NULL   "search_site1_2009_03_13_keyword_13_crc" btree (keyword_13_crc,
site_id) WHERE keyword_13_crc IS NOT NULL   "search_site1_2009_03_13_keyword_14_crc" btree (keyword_14_crc,
site_id) WHERE keyword_14_crc IS NOT NULL   "search_site1_2009_03_13_keyword_15_crc" btree (keyword_15_crc,
site_id) WHERE keyword_15_crc IS NOT NULL   "search_site1_2009_03_13_keyword_16_crc" btree (keyword_16_crc,
site_id) WHERE keyword_16_crc IS NOT NULL   "search_site1_2009_03_13_keyword_17_crc" btree (keyword_17_crc,
site_id) WHERE keyword_17_crc IS NOT NULL   "search_site1_2009_03_13_keyword_18_crc" btree (keyword_18_crc,
site_id) WHERE keyword_18_crc IS NOT NULL   "search_site1_2009_03_13_keyword_19_crc" btree (keyword_19_crc,
site_id) WHERE keyword_19_crc IS NOT NULL   "search_site1_2009_03_13_leaf_category_1" btree (leaf_category_1,
site_id) WHERE leaf_category_1 IS NOT NULL   "search_site1_2009_03_13_seller_user_id" btree (seller_user_id,
site_id) WHERE seller_user_id IS NOT NULL   "search_site1_2009_03_13_upc_code" btree (upc_code, site_id) WHERE
upc_code IS NOT NULL

-----Original Message-----
From: Tom Lane [mailto:tgl@sss.pgh.pa.us]
Sent: Thursday, July 09, 2009 11:06 AM
To: Jacob Bresciani
Cc: pgsql-sql@postgresql.org
Subject: Re: [SQL] FW: Query length limitation in postgres server >
8.2.9

<jacob@aers.ca> writes:
> I've simplified the query to make it easier to look at.

We need to see the table/index declarations.  The query by itself is
just about useless.
        regards, tom lane