Re: get speed help - Mailing list pgsql-general

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 PM Ron Johnson <ronljohnsonjr@gmail.com> 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 PM 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 processor

no parallel processing, to know it, the speed in single processor

On Mon, May 19, 2025 at 9:55 PM Ron Johnson <ronljohnsonjr@gmail.com> wrote:

On Mon, May 19, 2025 at 12:12 PM 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!

--

Death to <Redacted>, and butter sauce.

Don't boil me, I'm still alive.

<Redacted> lobster!