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 wrote:
> Hi,
> I
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 wrote:
> Hello,
> 1 field 20 chars plus primary key id field - small table
> ind
On Mon, May 19, 2025 at 12:12 PM Dias Thomas 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?
On Monday, May 19, 2025, Dias Thomas 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 ??
>
https://wiki.postgresql.org/wiki/Slow_Query_Questions
David J.
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 ??
regards,
Dias Thomas
