public inbox for [email protected]
help / color / mirror / Atom feedFrom: Ron Johnson <[email protected]>
To: pgsql-general <[email protected]>
Subject: Re: get speed help
Date: Mon, 19 May 2025 12:43:42 -0400
Message-ID: <CANzqJaAP3aVYvWqtvL6GBw3Bj=x17cCTODwHECVjG2Qjru59Qg@mail.gmail.com> (raw)
In-Reply-To: <CAD1E=97qte1U1-XOkEKAtKuRye+p-_Bx_fFO4x73T542O_Z+ig@mail.gmail.com>
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>
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 PM Dias Thomas <[email protected]> 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 PM Ron Johnson <[email protected]>
> wrote:
>
>> On Mon, May 19, 2025 at 12:12 PM Dias Thomas <[email protected]>
>> 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!
>>
>
--
Death to <Redacted>, and butter sauce.
Don't boil me, I'm still alive.
<Redacted> lobster!
view thread (2+ messages) latest in thread
reply
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: [email protected]
Cc: [email protected]
Subject: Re: get speed help
In-Reply-To: <CANzqJaAP3aVYvWqtvL6GBw3Bj=x17cCTODwHECVjG2Qjru59Qg@mail.gmail.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox