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 1uH3If-00CaCu-Us for pgsql-general@arkaria.postgresql.org; Mon, 19 May 2025 16:25:14 +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 1uH3Ie-00H6Hn-VV for pgsql-general@arkaria.postgresql.org; Mon, 19 May 2025 16:25:12 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1uH3Ie-00H6Hf-K1 for pgsql-general@lists.postgresql.org; Mon, 19 May 2025 16:25:12 +0000 Received: from mail-oa1-x32.google.com ([2001:4860:4864:20::32]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.96) (envelope-from ) id 1uH3Ib-002i8z-35 for pgsql-general@postgresql.org; Mon, 19 May 2025 16:25:12 +0000 Received: by mail-oa1-x32.google.com with SMTP id 586e51a60fabf-2cc89c59cc0so1937257fac.0 for ; Mon, 19 May 2025 09:25:10 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20230601; t=1747671908; x=1748276708; darn=postgresql.org; h=to:subject:message-id:date:from:in-reply-to:references:mime-version :from:to:cc:subject:date:message-id:reply-to; bh=U2mX8VT9Ew78s30RJLRYNfGNs3ANilKfjGbP6IXjIuY=; b=KPij+9nKyngz878PQBh+QuYy477VPtvq7cLJtc+Q6P324nStOU1U+Iv8sTG/YOrrZg TClN+dK9bN2IFHdcIhVNRAzEhGa24ipKNntf5mbu33YS4BhpwmKamHT0bzygpM+xSrIY GLJVSeJOQuEVLsu+S440BsHN3TD9SiRJkPUajejLKoJx9W5sHwHd5RHqUvlgfdZG+a7Y OQqJLXpKLLnoeki2hof4X470birbUhB6omHtLaGAeqyvGLM9MATeyRW1wKN+/4Y/1HvU A7eoxU4rfDQn8c/rPZnxTNMvYTQjczVg8jT/ExtB0HFuulOAnA5JlkB0lIliYdrz1LJX rx0Q== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20230601; t=1747671908; x=1748276708; h=to:subject:message-id:date:from:in-reply-to:references:mime-version :x-gm-message-state:from:to:cc:subject:date:message-id:reply-to; bh=U2mX8VT9Ew78s30RJLRYNfGNs3ANilKfjGbP6IXjIuY=; b=Ofw205R7Vb9jxTaJ4LNSbtuZ91ENo1Uk7PChU+pTF6thduxIRPR6rmX4rP+IRU1orY nAotRG9P7Jqkkcp61pEyVpQyXQX5ldUF68PfZGCUA9bKi+h++4VdnIAuur/53cVv1C9I oT8bBERGeoN8X1IlmvEKu8Yb/wt32H2r4mIN204c9KkOVGEcwt05HHhe6jiKqM3pVN5l aGBdu/NLPXT/fMN4G8nvAtf/E6ULJM25FpxovJOnETXl8fMpp+RaupWXE1TLyVHUdZ/z UKUsd6KskRn3KGwHyPvdiY0lLsaAZA22vD6HZgwph/41FnuV5aAbdVUG6ThGGUhg4chT TNSQ== X-Gm-Message-State: AOJu0YyVOidKHSjUVUsNmb8Ohe2oH3d8W9TXUCjY3D5c+9KN02iG4DDV g7j/E/jesD/1SilSrOKxOnMpFFcPm8K67jejpvJD2quglwaMKthpDwLEh+jr1VVMRReEHxpzOsi mrVYzHRUv7DdOoqu0p131ec6VXPO4V0sMwg== X-Gm-Gg: ASbGncsbBZos/TnhSRbVrec/SHZUVRh470sJMVuitHEGZLx6EBHKsB0G0knQbmoRcRO n+AzDyE7rmfI4gjCryQxU9jt5Rfc6Y66Y5bFfnxZCc8IG/8tIOZZzMPiC9dq+/y8ZTSBr9s060N cWBxkcWXcHeyU3iHioFintM3JOqqiSgN0fyNm+WOR/97Ou X-Google-Smtp-Source: AGHT+IGfd6JdsoktOY8xhNnph9ngSnLxfeG6rjIaZtjuK6S1xtH3RbWMmF0IhIGPb7sarLvSIcPUOjk8sQbvxoMMlD4= X-Received: by 2002:a05:6870:51c6:b0:2d4:f2da:9bb8 with SMTP id 586e51a60fabf-2e3c274218fmr8192677fac.1.1747671908237; Mon, 19 May 2025 09:25:08 -0700 (PDT) MIME-Version: 1.0 References: In-Reply-To: From: Ron Johnson Date: Mon, 19 May 2025 12:24:57 -0400 X-Gm-Features: AX0GCFuRRZ_dR3i-X40FyTF9RWQ69nxm92Givlk6R7bAsfO-twehzybFkBg-c6c Message-ID: Subject: Re: get speed help To: pgsql-general Content-Type: multipart/alternative; boundary="00000000000046475406357f9368" List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --00000000000046475406357f9368 Content-Type: text/plain; charset="UTF-8" Content-Transfer-Encoding: quoted-printable On Mon, May 19, 2025 at 12:12=E2=80=AFPM Dias Thomas wrote: > Hello all, > Could i get a help, postgres 1 billion records indexed table, search > speed in a normal machine, no parallel processing ... for a knowledge ?? > 1. How big are the records? 2. How big are the keys? 3. What is a normal machine? 4. Why no parallel processing? --=20 Death to , and butter sauce. Don't boil me, I'm still alive. lobster! --00000000000046475406357f9368 Content-Type: text/html; charset="UTF-8" Content-Transfer-Encoding: quoted-printable
On Mon, May 19, 2025 at 12:12=E2=80=AFPM = Dias Thomas <dsthomas500@gmail.= com> wrote:
Hello all,=
=C2=A0Could i get a help, postgres 1 billion records indexed table, sea= rch speed in a normal machine, no parallel processing ... for a knowledge ?= ?

1. How big are the records?
2. How big are the keys?
3. What is a normal machine?
4. Why no parallel processing?

--
Death to <Redacted>, and butter sauce.Don't boil me, I'm still alive.
<Redacted> lobs= ter!
--00000000000046475406357f9368--