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 1rQEaw-00HSba-R9 for pgsql-general@arkaria.postgresql.org; Wed, 17 Jan 2024 22:41:15 +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 1rQEav-00GMj2-Uu for pgsql-general@arkaria.postgresql.org; Wed, 17 Jan 2024 22:41:13 +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 1rQEav-00GMiu-Jx for pgsql-general@lists.postgresql.org; Wed, 17 Jan 2024 22:41:13 +0000 Received: from mail-oa1-x35.google.com ([2001:4860:4864:20::35]) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.94.2) (envelope-from ) id 1rQEat-0023UA-Bs for pgsql-general@lists.postgresql.org; Wed, 17 Jan 2024 22:41:12 +0000 Received: by mail-oa1-x35.google.com with SMTP id 586e51a60fabf-2108bbf0040so1260464fac.0 for ; Wed, 17 Jan 2024 14:41:11 -0800 (PST) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20230601; t=1705531270; x=1706136070; darn=lists.postgresql.org; h=content-transfer-encoding:in-reply-to:from:references:cc:to :content-language:subject:user-agent:mime-version:date:message-id :from:to:cc:subject:date:message-id:reply-to; bh=LjJc8sZ1PZwnEglkvi6AJSigG+zEUoSiDahgXVc8TIc=; b=nJLB3El7yt/YI7MAzWhXHKVIbJNFJcGJcwjc7499lIh3VLKEEHTsE8EmsqGO893CKy wohpBaiA+kIwl1VMThEHM/DTi8p4URg5fGF0ahVrr9zF5kQFv+IVkQ8g6K9fzSrGNfTd Pq1lLW1VtwTH7QKsI+n5wWwlhsGuwm439ClHl7FpTO7jmDAe3tTMfCrJBfOKqpDrYf8W XQh1qoaRhR7fKwacjgdJfbGhwcBeji/AWK5F++oyn/Rv8CRfLeB3lbJpynEeIkQ6SRfG yL45LuniXJWIunCh8aaiIzySO48rhUwOErMZ40FXqgUCJXHbcK1iJvvy4hDB84XnzrX6 ycfw== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20230601; t=1705531270; x=1706136070; h=content-transfer-encoding:in-reply-to:from:references:cc: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=LjJc8sZ1PZwnEglkvi6AJSigG+zEUoSiDahgXVc8TIc=; b=VQ6b8mfQmmLIgqhphYyBL6/DCVjlDMG6GcOrZH4JVHGQivmqQp82fPIbfWHw0Eir2t Qr6ssLXyM0BpXX/mpzC63LJn3b4WG//sRZBbraZUxKgdlIovzF+KojOZkBLG7yjLA7kv 2Fl0R0lv1tSV3rezbSXzfSfVwOA6kPueSIFLYRQz/bS7USvs6Yt9A0KDWDBQ1ssBerIU LQdzE4VghmyV77VPmbvWWoD3sMocqbjR+DRYdbrgOU3gcRWscr7VLD7Q8BfejFHSL7aW fiszkUyiWLJ+nYlXZxV45i/vB5ZG6ihHI8QFZEUcubSLMyj6cXLTrAZiCAzBw0hNqAR9 6tMw== X-Gm-Message-State: AOJu0YyELV3oRP/ndWfsSYIL74jE3IKBXpkTlCyycH+9no78GiqoKbqO gEKzJrgXgpfVrNkibDCaqg3HWhohEfiz X-Google-Smtp-Source: AGHT+IHUgX+2uRThWH5oH3XtA6yenDe3yX5U2eVK0wr+PyvppeSZdpfnH8ULs0e9hd0qGmJHN3P1YQ== X-Received: by 2002:a05:6870:f106:b0:206:b8c4:f3a1 with SMTP id k6-20020a056870f10600b00206b8c4f3a1mr12988219oac.55.1705531270650; Wed, 17 Jan 2024 14:41:10 -0800 (PST) Received: from [192.168.2.6] (070-113-014-216.res.spectrum.com. [70.113.14.216]) by smtp.gmail.com with ESMTPSA id qh21-20020a056870bf1500b0020650e8e782sm84912oab.57.2024.01.17.14.41.09 (version=TLS1_3 cipher=TLS_AES_128_GCM_SHA256 bits=128/128); Wed, 17 Jan 2024 14:41:10 -0800 (PST) Message-ID: Date: Wed, 17 Jan 2024 16:41:08 -0600 MIME-Version: 1.0 User-Agent: Mozilla Thunderbird Subject: Re: postgres sql assistance Content-Language: en-US To: arun chirappurath Cc: pgsql-general@lists.postgresql.org References: From: Jim Nasby In-Reply-To: Content-Type: text/plain; charset=UTF-8; format=flowed Content-Transfer-Encoding: 7bit List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk On 1/16/24 10:04 PM, arun chirappurath wrote: > Architect is pressing for a native procedure to data load. It's possible to write a loader in pl/pgsql but it would be easily twice as complex as where you got on your first attempt. It would also never perform anywhere near as well as a dedicated loader, because there's no way to avoid the temp table (which a native loader doesn't need to use). -- Jim Nasby, Data Architect, Austin TX