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!
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!
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 ??
pgsql-general by date:
Соглашаюсь с условиями обработки персональных данных
