Thread: Re: get speed help
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!
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 tableindexed on that char - 20 field , say 16 gb ram, amd normal power processorno parallel processing, to know it, the speed in single processorOn 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!
Ok?
Honestly, your questions puzzle me: PG is open source, binaries are available for Windows, every Linux distro, and even BSD. And the database is pretty small.
Install it, and test it yourself.
Then you'll have the answer.
On Mon, May 19, 2025 at 12:57 PM Dias Thomas <dsthomas500@gmail.com> wrote:
Hi,I mean any manualI have a small code, that searches some 10000 billion records in 1 seconds thru index simple case -- I want to test that with postgresOn 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 tableindexed on that char - 20 field , say 16 gb ram, amd normal power processorno parallel processing, to know it, the speed in single processorOn 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!
Death to <Redacted>, and butter sauce.
Don't boil me, I'm still alive.
<Redacted> lobster!