public inbox for [email protected]
help / color / mirror / Atom feedFrom: Ron Johnson <[email protected]>
To: pgsql-general <[email protected]>
Subject: Re: get speed help
Date: Mon, 19 May 2025 15:05:51 -0400
Message-ID: <CANzqJaAfOTSa2_7=Y+orntUHZFqG_bvE8RZmtCufQ3_t4KSN+A@mail.gmail.com> (raw)
In-Reply-To: <CAD1E=95oWHxpLhQh+Y+nPMjp6DdHhV4KbavUE5vYUh0_s66AVw@mail.gmail.com>
References: <CAD1E=95W47yo_ijm_h0CTA8TKWHQg_VibRBA33PvGEK3DbsDHA@mail.gmail.com>
<CANzqJaB71Mmhs+AKsqDG_HAhG1AJFub3TPCTwxfgB8RSQGF6qA@mail.gmail.com>
<CAD1E=97qte1U1-XOkEKAtKuRye+p-_Bx_fFO4x73T542O_Z+ig@mail.gmail.com>
<CANzqJaAP3aVYvWqtvL6GBw3Bj=x17cCTODwHECVjG2Qjru59Qg@mail.gmail.com>
<CAD1E=95oWHxpLhQh+Y+nPMjp6DdHhV4KbavUE5vYUh0_s66AVw@mail.gmail.com>
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!
view thread (2+ messages)
reply
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: [email protected]
Cc: [email protected]
Subject: Re: get speed help
In-Reply-To: <CANzqJaAfOTSa2_7=Y+orntUHZFqG_bvE8RZmtCufQ3_t4KSN+A@mail.gmail.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox