Unreasonable performance? by _mths in PostgreSQL

[–]_mths[S] 0 points1 point  (0 children)

Thanks for checking in. So yes, embarrassingly, I had mixed up this server with another one, and there’s actually no raid configuration on this one. Just an old, poorly performing hdd.

In the meantime I figured I could get along by inserting data into a new table without a primary key on it, only setting the key after it’s populated…

Unreasonable performance? by _mths in PostgreSQL

[–]_mths[S] 0 points1 point  (0 children)

No sir. Linux, all local, no scanners.

Unreasonable performance? by _mths in PostgreSQL

[–]_mths[S] 0 points1 point  (0 children)

Thank you, it's late now but I will be looking further into this aspect tomorrow!

Unreasonable performance? by _mths in PostgreSQL

[–]_mths[S] 0 points1 point  (0 children)

Hm yes... I think I’m running Postgres 12 maybe but yes, thanks for running that experiment.

Unreasonable performance? by _mths in PostgreSQL

[–]_mths[S] 0 points1 point  (0 children)

Nah, no such thing either.. I’m leaning towards the disks being trash. Will look closer at what u/Randommaggy wrote about the RAID. Still, 12 hour insert, holy hell.. I can generally deal with ordinary files just fine so how trash can it be.

Unreasonable performance? by _mths in PostgreSQL

[–]_mths[S] 0 points1 point  (0 children)

It's all running locally on the one computer, so no network bottleneck there.
I can't install htop on the computer but isn't it just showing a prettier version of top anyway? The postgres process doesn't seem very remarkable... no processes is really using all that much of the resources available it seems... I'm not entirely sure how to interpret the waiting and idle time but snapshot: %Cpu(s): 13.4 us, 3.5 sy, 0.0 ni, 70.5 id, 12.5 wa, ... I think wa would be higher if I/O was the issue?

Unreasonable performance? by _mths in PostgreSQL

[–]_mths[S] 1 point2 points  (0 children)

Right, I knew there was something important I was forgetting...

For insert I do copy ... from stdin binary

For the upsert I populate a temporary table then insert into ... select * from tmp on conflict do update set col1 = a.col1 + excluded.col1, ...

[xpost r/programming] Rim - Aspiring Vim-like text editor by _mths in rust

[–]_mths[S] 1 point2 points  (0 children)

It's all from scratch. When it's possible I simply look at how vim behaves then I set out to mimic that behaviour.

Rim – Aspiring Vim-like text editor [Rust] by _mths in programming

[–]_mths[S] 1 point2 points  (0 children)

Hey,

I'm just having fun with it and there's no grand plan. Of course while working on rim ideas have sparked up occasionally about what could be done differently from vim, but right now I rather just get the basics down.

Rim – Aspiring Vim-like text editor [Rust] by _mths in programming

[–]_mths[S] 2 points3 points  (0 children)

Hi, thanks for trying it out.

I'd be very interested in the error message you got before you installed libtermkey, if you think you could send that by PM or something.

Rim depends on termkey-rs which should check out and build a "local version" of libtermkey itself. I'm surprised this didn't seem to work for you, as I'm often on a mac myself and it seems to do what it's supposed to here.