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 1uH5oQ-00DOg7-0p for pgsql-general@arkaria.postgresql.org; Mon, 19 May 2025 19:06:10 +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 1uH5oO-000d7q-PM for pgsql-general@arkaria.postgresql.org; Mon, 19 May 2025 19:06:08 +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 1uH5oO-000d7h-B0 for pgsql-general@lists.postgresql.org; Mon, 19 May 2025 19:06:08 +0000 Received: from mail-ot1-x32d.google.com ([2607:f8b0:4864:20::32d]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.96) (envelope-from ) id 1uH5oK-002jh8-0c for pgsql-general@postgresql.org; Mon, 19 May 2025 19:06:08 +0000 Received: by mail-ot1-x32d.google.com with SMTP id 46e09a7af769-72ecb4d9a10so5597507a34.3 for ; Mon, 19 May 2025 12:06:04 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20230601; t=1747681562; x=1748286362; 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=heKENM7iVTdUWByv4CqqijL4CUt8UEqWQspd/bedSu4=; b=nPwuxm2mnFDOJuEHuXN9j47QsH7L/K8FLGjeYs/qrWeV05c0W5ESCcKXGgLWVk2CTu yguubClPIF9sq73x58kNX5ZFjA/1DOnkR/R/X8dNOQLI1LId2fhmbpHgDQpzke6QlFYr JY06v8GB3kKxtTiF2Ueaa6mjDj0nP2WWkov5oiSCgzf/ys1KyR+VOE4fY1SVa5oZwSL/ 4xMaMzYc7SSLDKnQiZDAImGnaLEv2Y7Dx2VPIy+MLd45I2JpmR2sYNCqf0U4e29YH/5l ScoqR2wWoI9TEbWgb4nY00Szas0mrYRPmN67SZYV9w39Wl8g26/+023LILgSo6mq7O3A tkIQ== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20230601; t=1747681562; x=1748286362; 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=heKENM7iVTdUWByv4CqqijL4CUt8UEqWQspd/bedSu4=; b=rY1EsWJO4RHSONtTgGB5JOX5KvJ1XGI5PvEje9WkwutMqo1jmLzJwBxO0Xndch3QM2 zxuGPSuoLHJdlsXmrk18qob9u+W9vk2bs7zO+OC9xuJid+Uc9tOtbWyNvPLbOZm3vUcU aIX+cFL85/T3pww+fQCBbWYmDOVZgKB2bb0qr9cRlNhSuk5z5wKavGxC7EYGeX2Q2lQ/ ntg+ToSEolYrJertK4mEA01QgJE4PSKMlMEvS24zWeqRyMptIxWjx4yHYh/yVuBWsMC3 8kVl3ct519nGjpZeCG0MDFPzWIPtJCtmReO9nnOsLv99oHUd/XqlxfEDozkgO2pITEQv wN9w== X-Gm-Message-State: AOJu0YwTXW+tbsDK/df2g/ieJTexbbbS5OedcgdL3iBoBcpuj/kDOCeD ysfZwFMm7XWSCrPNHBeKxLOYIJm16Cjtk8WcdfF8b0b8zBj7+7nmhVvtM8cu7YP3xtpl1k8ZnAy 60nyqZakL1gyBgwZrKAXm9QbW1MeOemJ3mg== X-Gm-Gg: ASbGnct1Efrbgaz3/oTygUOxUEb+6dCwnxFu6ijK/3vgh+DvexrDj9rUPqhfTbHUTAC vaa0F7HwlGiAePEmYBnziUITdDdwolf9hRUuTDSFuZUMuYxfb7pD3G5Wwh8eC0gb4xO3VFNMmYW QaHVwHHhR4vsl5v6+Itiq8m7gXAnDb3fyCQ2INu/YZbVTo X-Google-Smtp-Source: AGHT+IFL7WKTdSXZyEYN5KTifbbfhMF8J/ynUQ6dCXgT2TrqmnHA+wsrH8eVpk/ChskbfL04TEGILrffQj16IpPQUYQ= X-Received: by 2002:a05:6870:c698:b0:2d4:e8fd:7ffb with SMTP id 586e51a60fabf-2e3c1b71604mr7987909fac.1.1747681562283; Mon, 19 May 2025 12:06:02 -0700 (PDT) MIME-Version: 1.0 References: In-Reply-To: From: Ron Johnson Date: Mon, 19 May 2025 15:05:51 -0400 X-Gm-Features: AX0GCFvpRpUEvJ9TSBd4ZVSzdOXGFG-D1-Qfyo_vOfa8pfnwhToomsVgK295bCQ Message-ID: Subject: Re: get speed help To: pgsql-general Content-Type: multipart/alternative; boundary="000000000000b352fb063581d2de" List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --000000000000b352fb063581d2de Content-Type: text/plain; charset="UTF-8" Content-Transfer-Encoding: quoted-printable Ok? Honestly, your questions puzzle me: PG is open source, binaries are available for Windows, every Linux distro, and even BSD. And *the database is pretty small*. Install it, and *test it yourself*. Then you'll have the answer. On Mon, May 19, 2025 at 12:57=E2=80=AFPM Dias Thomas wrote: > Hi, > I mean any manual > I have a small code, that searches some 10000 billion records in 1 > seconds thru index simple case -- I want to test that with postgres > > > On Mon, May 19, 2025 at 10:14=E2=80=AFPM Ron Johnson > wrote: > >> Spinning rust? SSD? NVMe? SATA? SCSI? Fiber? >> >> Anyway... off the cuff, for 1 giga-rows, that's about a 50GB table. >> Small enough that you can easily test that yourself. >> >> On Mon, May 19, 2025 at 12:38=E2=80=AFPM Dias Thomas >> wrote: >> >>> Hello, >>> 1 field 20 chars plus primary key id field - small table >>> indexed on that char - 20 field , say 16 gb ram, amd normal power >>> processor >>> no parallel processing, to know it, the speed in single processor >>> >>> On Mon, May 19, 2025 at 9:55=E2=80=AFPM Ron Johnson >>> wrote: >>> >>>> 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? >>>> >>>> -- >>>> Death to , and butter sauce. >>>> Don't boil me, I'm still alive. >>>> lobster! >>>> >>> >> >> -- >> Death to , and butter sauce. >> Don't boil me, I'm still alive. >> lobster! >> > --=20 Death to , and butter sauce. Don't boil me, I'm still alive. lobster! --000000000000b352fb063581d2de Content-Type: text/html; charset="UTF-8" Content-Transfer-Encoding: quoted-printable
Ok?

= Honestly, your questions puzzle me: PG is open source, binaries are availab= le for Windows, every Linux distro, and even BSD.=C2=A0 And the database= is pretty small.

Install it, and test it y= ourself.

Then you'll have the answer.
On Mon, May 19, 2025 at 12:57=E2=80=AFPM Dias Thomas <<= a href=3D"mailto:dsthomas500@gmail.com">dsthomas500@gmail.com> wrote= :
Hi,
I mean any manual
=C2=A0I have a small code, that sear= ches some 10000 billion records in 1 seconds thru index simple case -- I wa= nt to test that with postgres


On Mon, May 19, 2025 at 1= 0:14=E2=80=AFPM Ron Johnson <ronljohnsonjr@gmail.com> wrote:
Spinning rus= t?=C2=A0 SSD?=C2=A0 NVMe? SATA? SCSI?=C2=A0 Fiber?

Anyway... off the cuff, for 1 giga-rows, that's about a 50GB table.=C2= =A0 Small enough that you can easily test that yourself.

On Mon, May 19, 202= 5 at 12:38=E2=80=AFPM Dias Thomas <dsthomas500@gmail.com> wrote:
Hello,
1 fi= eld 20 chars plus primary key id field - small table
indexed on that ch= ar - 20 field , say 16 gb ram, amd normal power processor
no para= llel processing, to know it, the speed in single processor

On Mo= n, May 19, 2025 at 9:55=E2=80=AFPM Ron Johnson <ronljohnsonjr@gmail.com> wrote:=
On Mon, May 19, 2025 at 12:12=E2=80=AFPM Dias Thomas <= ;dsthomas500@gma= il.com> wrote:
Hello all,
=C2=A0Could i g= et a help, postgres 1 billion records indexed table, search speed in a norm= al machine, no parallel processing ... for a knowledge ??

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

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


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


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