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 <dsthomas...@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 processor > no parallel processing, to know it, the speed in single processor > > On Mon, May 19, 2025 at 9:55 PM Ron Johnson <ronljohnso...@gmail.com> > wrote: > >> On Mon, May 19, 2025 at 12:12 PM Dias Thomas <dsthomas...@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! >> > -- Death to <Redacted>, and butter sauce. Don't boil me, I'm still alive. <Redacted> lobster!
