Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1qeZLQ-0078MA-CQ for pgsql-general@arkaria.postgresql.org; Fri, 08 Sep 2023 11:08:12 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.94.2) (envelope-from ) id 1qeZLN-009xf0-UA for pgsql-general@arkaria.postgresql.org; Fri, 08 Sep 2023 11:08:09 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1qeZLN-009xer-IJ for pgsql-general@lists.postgresql.org; Fri, 08 Sep 2023 11:08:09 +0000 Received: from mail-pj1-x102d.google.com ([2607:f8b0:4864:20::102d]) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.94.2) (envelope-from ) id 1qeZLG-003Q9w-9g for pgsql-general@lists.postgresql.org; Fri, 08 Sep 2023 11:08:08 +0000 Received: by mail-pj1-x102d.google.com with SMTP id 98e67ed59e1d1-26d63b608d4so1526800a91.2 for ; Fri, 08 Sep 2023 04:08:02 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20221208; t=1694171281; x=1694776081; darn=lists.postgresql.org; h=content-transfer-encoding:in-reply-to:from:references:to :content-language:subject:user-agent:mime-version:date:message-id :from:to:cc:subject:date:message-id:reply-to; bh=yopWLfe5LheIVWfiGzYALMM+mus6AAVJ15tKq2UfDiA=; b=JxaSlkxINV3xXeH93Rck3wUUkhZjhZx5r3A0NBpb2VFgIlo0cD3bqWyo2zW7MzcJNp 8N3R2BEsZLs4iAANkIASxxOMC8PN0HcmDc1GVeMVOc7I3v4GksNmIitjoM+t4WZjhfF2 aQmsBz7cPdbt4rIE7CXOJK/0hoMmSYTIboM2+FFcBNzg0Iq4WGY8SIK1leebLQpwjvLf HMw7lLAYzrnPPOxw3oWUM1yTeyVesPm/7uEeESJp2EPrMV2s3tK+OvOrAqIpLF2JchBj P9eWZoM6dxaldohx0Y253vhe+wCHjSl1R4EDQvZSzGZd4M7jnPXHUBCe0/cme50xJ7og 8FLw== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20230601; t=1694171281; x=1694776081; h=content-transfer-encoding:in-reply-to:from:references:to :content-language:subject:user-agent:mime-version:date:message-id :x-gm-message-state:from:to:cc:subject:date:message-id:reply-to; bh=yopWLfe5LheIVWfiGzYALMM+mus6AAVJ15tKq2UfDiA=; b=eQycBlS5PfIP42xeo0S1BSutwllrOk2Lk67Ye4RSDiAlreYcchGvxYXmnYNmfBdHiQ 0d4R8QLUqVdI2uPiuFvSBcXxW2nZgzCXZ5MouWxvlxBhRYBX3xbRNM4tygT13tQwHEAc IVdvkv053k3N0S1baeGgOH+NNTEulsa+eX045PhaqjDpol35ESJ+BvwIVm/3RimjBpXT 6U5QJeK2qUeHyaSLPpCPJlC6nTb9HvMNp0tFGIMvduSNaueuTbV9xJ4JIYxAddwnI148 ZTWe1Lyawni+sjjnhXZ0UCOtUMGACnv2Jt3RCkijtXoVg0AVL/60SOQBIbG7egketIAN eqXw== X-Gm-Message-State: AOJu0Yw95w5tT5mwXZX/eMaQB+bufK/X9fPbLJU+IFr8GHZt2z+AVAV/ acYYPILSQP8xD/p+samNcf/uCNEdFPA= X-Google-Smtp-Source: AGHT+IE9nzVjKVSti7ygpozfsHW5hqrwrEIasmYROFv0eMaLsdncnP3ofbOKNxK11uVPYoEqZR5BuQ== X-Received: by 2002:a17:90a:130d:b0:271:af7b:7c5e with SMTP id h13-20020a17090a130d00b00271af7b7c5emr2166007pja.44.1694171280640; Fri, 08 Sep 2023 04:08:00 -0700 (PDT) Received: from ?IPV6:2601:681:5a00:f790:236d:c069:8f35:80b? ([2601:681:5a00:f790:236d:c069:8f35:80b]) by smtp.gmail.com with ESMTPSA id s2-20020a17090a074200b002682523653asm1186946pje.49.2023.09.08.04.07.59 for (version=TLS1_3 cipher=TLS_AES_128_GCM_SHA256 bits=128/128); Fri, 08 Sep 2023 04:08:00 -0700 (PDT) Message-ID: <63b173c8-03fe-5238-8060-434ea9f8822e@gmail.com> Date: Fri, 8 Sep 2023 05:07:58 -0600 MIME-Version: 1.0 User-Agent: Mozilla/5.0 (X11; Linux x86_64; rv:102.0) Gecko/20100101 Thunderbird/102.15.0 Subject: Re: Huge input lookup exception when trying to create the index for XML data type column in postgreSQL Content-Language: en-CA To: pgsql-general@lists.postgresql.org References: <1736511.1694113781@sss.pgh.pa.us> <87357840.138645.1694115470979@office.mailbox.org> <1755041.1694118103@sss.pgh.pa.us> From: Rob Sargent In-Reply-To: Content-Type: text/plain; charset=UTF-8; format=flowed Content-Transfer-Encoding: 8bit List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk On 9/7/23 23:51, Sai Teja wrote: > Thank you so much for all your responses. > > I just tried with Hash, GIN etc > > But it didn't worked. And I think it is because of "Xpath" expression > which I used in the index create command. > > But is there any alternative way to change this Xpath? Since I need to > parse the XML as there is no other option. I need the other ways to > create the index . > > May be if there are any parameters to change like xmloption etc it > would help us to resolve the issue. > > Thanks, > Sai > > What is a typical value returned by your xpath statement? (XPATH (‘directory/access/mode/@Identifier’, content))