Re: get speed help

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 <dsthomas500(at)gmail(dot)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 processor
> no parallel processing, to know it, the speed in single processor
>
> On Mon, May 19, 2025 at 9:55 PM Ron Johnson <ronljohnsonjr(at)gmail(dot)com>
> wrote:
>
>> On Mon, May 19, 2025 at 12:12 PM Dias Thomas <dsthomas500(at)gmail(dot)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!
>>
>

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