Re: get speed help
| От | Ron Johnson |
|---|---|
| Тема | Re: get speed help |
| Дата | |
| Msg-id | CANzqJaAP3aVYvWqtvL6GBw3Bj=x17cCTODwHECVjG2Qjru59Qg@mail.gmail.com обсуждение исходный текст |
| Ответ на | Re: get speed help (Ron Johnson <ronljohnsonjr@gmail.com>) |
| Список | pgsql-general |
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!
В списке pgsql-general по дате отправления: