Received: from maia.hub.org (unknown [200.46.204.183]) by mail.postgresql.org (Postfix) with ESMTP id 464816335B0 for ; Thu, 9 Jul 2009 15:10:37 -0300 (ADT) Received: from mail.postgresql.org ([200.46.204.86]) by maia.hub.org (mx1.hub.org [200.46.204.183]) (amavisd-maia, port 10024) with ESMTP id 78124-09 for ; Thu, 9 Jul 2009 15:10:26 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey-1.7.6 Received: from mail1.mailhostingservice.com (mail1.mailhostingservice.com [216.154.198.171]) by mail.postgresql.org (Postfix) with SMTP id A8537633145 for ; Thu, 9 Jul 2009 15:10:26 -0300 (ADT) Received: From aers.ca (24.68.32.77) by mail1.mailhostingservice.com Id <4aa5892104764fdef3f0f46ba6fc34bd6c2e1682@mail1.mailhostingservice.com> ; Thr, 9 Jul 2009 18:09:20 +0000 X-MimeOLE: Produced By Microsoft Exchange V6.5 Content-class: urn:content-classes:message MIME-Version: 1.0 Content-Type: text/plain; charset="US-ASCII" Content-Transfer-Encoding: quoted-printable Subject: Re: FW: Query length limitation in postgres server > 8.2.9 Date: Thu, 9 Jul 2009 11:10:22 -0700 Message-ID: <6B5AF6293A289F45826220B17ABE7937FDB1C6@BORON.aers.local> In-Reply-To: <3795.1247162732@sss.pgh.pa.us> X-MS-Has-Attach: X-MS-TNEF-Correlator: Thread-Topic: [SQL] FW: Query length limitation in postgres server > 8.2.9 Thread-Index: AcoAv9s8oeIVaf88RuyGrPnC2RJxuAAAJiGw References: <6B5AF6293A289F45826220B17ABE7937FDB16C@BORON.aers.local> <6B5AF6293A289F45826220B17ABE7937FDB1C0@BORON.aers.local> <3795.1247162732@sss.pgh.pa.us> From: To: Cc: X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0.001 tagged_above=0 required=5 tests=UNPARSEABLE_RELAY=0.001 X-Spam-Level: X-Archive-Number: 200907/43 X-Sequence-Number: 32784 \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@sss.pgh.pa.us]=20 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=20 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