Re: FW: Query length limitation in postgres server > 8.2.9

\d search_site1_2009_03_13

Table "public.search_site1_2009_03_13"
Column | Type | Modifiers
----------------------+------------------------+-----------
item_id | bigint | not null
transaction_id | bigint | not null
site_id | smallint | not null
leaf_category_1 | integer | not null
current_price_usd | numeric | not null
buy_it_now_price_usd | numeric |
qty_sold | integer | not null
qty_avail | integer | not null
auction_type | smallint | not null
flags | integer | not null
seller_user_id | bigint | not null
start_price_usd | numeric | not null
listing_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(at)sss(dot)pgh(dot)pa(dot)us]
Sent: Thursday, July 09, 2009 11:06 AM
To: Jacob Bresciani
Cc: pgsql-sql(at)postgresql(dot)org
Subject: Re: [SQL] FW: Query length limitation in postgres server >
8.2.9

<jacob(at)aers(dot)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