MIME-Version: 1.0
References: <CAD1E=95W47yo_ijm_h0CTA8TKWHQg_VibRBA33PvGEK3DbsDHA@mail.gmail.com>
 <CANzqJaB71Mmhs+AKsqDG_HAhG1AJFub3TPCTwxfgB8RSQGF6qA@mail.gmail.com> <CAD1E=97qte1U1-XOkEKAtKuRye+p-_Bx_fFO4x73T542O_Z+ig@mail.gmail.com>
In-Reply-To: <CAD1E=97qte1U1-XOkEKAtKuRye+p-_Bx_fFO4x73T542O_Z+ig@mail.gmail.com>
From: Ron Johnson <ronljohnsonjr@gmail.com>
Date: Mon, 19 May 2025 12:43:42 -0400
Message-ID: <CANzqJaAP3aVYvWqtvL6GBw3Bj=x17cCTODwHECVjG2Qjru59Qg@mail.gmail.com>
Subject: Re: get speed help
To: pgsql-general <pgsql-general@postgresql.org>
Content-Type: multipart/alternative; boundary="00000000000053525c06357fd629"
Archived-At: <https://www.postgresql.org/message-id/CANzqJaAP3aVYvWqtvL6GBw3Bj%3Dx17cCTODwHECVjG2Qjru59Qg%40mail.gmail.com>
Precedence: bulk

--00000000000053525c06357fd629
Content-Type: text/plain; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable

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 <dsthomas500@gmail.com=
> 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 process=
or
> no parallel processing, to know it, the speed in single processor
>
> On Mon, 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@gmail.=
com>
>> 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 <Redacted>, and butter sauce.
>> Don't boil me, I'm still alive.
>> <Redacted> lobster!
>>
>

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

--00000000000053525c06357fd629
Content-Type: text/html; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable

<div dir=3D"ltr"><div>Spinning rust?=C2=A0 SSD?=C2=A0 NVMe? SATA? SCSI?=C2=
=A0 Fiber?</div><div><br></div><div>Anyway... off the cuff, for 1 giga-rows=
, that&#39;s about a 50GB table.=C2=A0 Small enough that you can easily tes=
t that yourself.</div><br><div class=3D"gmail_quote gmail_quote_container">=
<div dir=3D"ltr" class=3D"gmail_attr">On Mon, May 19, 2025 at 12:38=E2=80=
=AFPM Dias Thomas &lt;<a href=3D"mailto:dsthomas500@gmail.com">dsthomas500@=
gmail.com</a>&gt; wrote:<br></div><blockquote class=3D"gmail_quote" style=
=3D"margin:0px 0px 0px 0.8ex;border-left:1px solid rgb(204,204,204);padding=
-left:1ex"><div dir=3D"ltr">Hello,<div>1 field 20 chars plus primary key id=
 field - small table<div>indexed on that char - 20 field , say 16 gb ram, a=
md normal power processor</div><div>no parallel processing, to know it, the=
 speed in single processor</div></div></div><br><div class=3D"gmail_quote">=
<div dir=3D"ltr" class=3D"gmail_attr">On Mon, May 19, 2025 at 9:55=E2=80=AF=
PM Ron Johnson &lt;<a href=3D"mailto:ronljohnsonjr@gmail.com" target=3D"_bl=
ank">ronljohnsonjr@gmail.com</a>&gt; wrote:<br></div><blockquote class=3D"g=
mail_quote" style=3D"margin:0px 0px 0px 0.8ex;border-left:1px solid rgb(204=
,204,204);padding-left:1ex"><div dir=3D"ltr"><div dir=3D"ltr">On Mon, May 1=
9, 2025 at 12:12=E2=80=AFPM Dias Thomas &lt;<a href=3D"mailto:dsthomas500@g=
mail.com" target=3D"_blank">dsthomas500@gmail.com</a>&gt; wrote:</div><div =
class=3D"gmail_quote"><blockquote class=3D"gmail_quote" style=3D"margin:0px=
 0px 0px 0.8ex;border-left:1px solid rgb(204,204,204);padding-left:1ex"><di=
v dir=3D"ltr">Hello all,<br>=C2=A0Could i get a help, postgres 1 billion re=
cords indexed table, search speed in a normal machine, no parallel processi=
ng ... for a knowledge ??<br></div></blockquote><div><br></div><div>1. How =
big are the records?</div><div>2. How big are the keys?</div><div>3. What i=
s a normal machine?</div><div>4. Why no parallel processing?</div><div><br>=
</div></div><span class=3D"gmail_signature_prefix">-- </span><br><div dir=
=3D"ltr" class=3D"gmail_signature"><div dir=3D"ltr">Death to &lt;Redacted&g=
t;, and butter sauce.<div>Don&#39;t boil me, I&#39;m still alive.<br><div><=
div>&lt;Redacted&gt; lobster!</div></div></div></div></div></div>
</blockquote></div>
</blockquote></div><div><br clear=3D"all"></div><div><br></div><span class=
=3D"gmail_signature_prefix">-- </span><br><div dir=3D"ltr" class=3D"gmail_s=
ignature"><div dir=3D"ltr">Death to &lt;Redacted&gt;, and butter sauce.<div=
>Don&#39;t boil me, I&#39;m still alive.<br><div><div>&lt;Redacted&gt; lobs=
ter!</div></div></div></div></div></div>

--00000000000053525c06357fd629--