public inbox for [email protected]
help / color / mirror / Atom feedRe: get speed help
2+ messages / 1 participants
[nested] [flat]
* Re: get speed help
@ 2025-05-19 16:43 Ron Johnson <[email protected]>
0 siblings, 1 reply; 2+ messages in thread
From: Ron Johnson @ 2025-05-19 16:43 UTC (permalink / raw)
To: 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 <[email protected]> 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 <[email protected]>
> wrote:
>
>> On Mon, May 19, 2025 at 12:12 PM Dias Thomas <[email protected]>
>> 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!
^ permalink raw reply [nested|flat] 2+ messages in thread
* Re: get speed help
@ 2025-05-19 19:05 Ron Johnson <[email protected]>
parent: Ron Johnson <[email protected]>
0 siblings, 0 replies; 2+ messages in thread
From: Ron Johnson @ 2025-05-19 19:05 UTC (permalink / raw)
To: pgsql-general
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 <[email protected]> wrote:
> 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 <[email protected]>
> 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 <[email protected]>
>> 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 <[email protected]>
>>> wrote:
>>>
>>>> On Mon, May 19, 2025 at 12:12 PM Dias Thomas <[email protected]>
>>>> 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!
^ permalink raw reply [nested|flat] 2+ messages in thread
end of thread, other threads:[~2025-05-19 19:05 UTC | newest]
Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2025-05-19 16:43 Re: get speed help Ron Johnson <[email protected]>
2025-05-19 19:05 ` Ron Johnson <[email protected]>
This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox