Conversation

Notices

1. Embed this notice
   pernia (pernia@freecumextremist.com)'s status on Sunday, 09-Oct-2022 12:14:10 JST pernia
   how long does this stage last
   • Embed this notice
     grumbulon (grumbulon@freecumextremist.com)'s status on Sunday, 09-Oct-2022 12:14:02 JST grumbulon

     in reply to

     • VIvi Nella Verita
     @pernia @verita84 indexes take forever esp if you ran pg_restore with -1 because it does it all as one transaction. You can run it with -j 4 or something depending how many cores you have and it will run simultanious jobs to make indexes and shit
   • Embed this notice
     pernia (pernia@freecumextremist.com)'s status on Sunday, 09-Oct-2022 12:14:03 JST pernia

     in reply to

     • VIvi Nella Verita
     @verita84 also i've been stuck on the same screen for an hour its been here for quite a bit should i be worried
   • Embed this notice
     VIvi Nella Verita (verita84@pooper.social)'s status on Sunday, 09-Oct-2022 12:14:04 JST VIvi Nella Verita

     in reply to

     @pernia@freecumextremist.com
     
     The copy part is quick but it has to build the tables and do stupid shit. The processing part is where you are at and it takes the longest. I strongly recommend a second postgres server to replicate to. Avoid this hebrew nonsense

   • Embed this notice
     VIvi Nella Verita (verita84@pooper.social)'s status on Sunday, 09-Oct-2022 12:14:05 JST VIvi Nella Verita

     in reply to

     @pernia@freecumextremist.com
     
     ok good, it will take time. This is why I made a second postgres server to replicate the data to. It takes minutes instead of hours

   • Embed this notice
     pernia (pernia@freecumextremist.com)'s status on Sunday, 09-Oct-2022 12:14:05 JST pernia

     in reply to

     • VIvi Nella Verita
     @verita84 man why the fuck is it so slow its like 1gb
   • Embed this notice
     pernia (pernia@freecumextremist.com)'s status on Sunday, 09-Oct-2022 12:14:06 JST pernia

     in reply to

     • VIvi Nella Verita
     @verita84 it do be chuggin
   • Embed this notice
     VIvi Nella Verita (verita84@pooper.social)'s status on Sunday, 09-Oct-2022 12:14:07 JST VIvi Nella Verita

     in reply to

     @pernia@freecumextremist.com
     
     use the top command then type c .
     
     You will be able to see if your CPU cores are doing anything

   • Embed this notice
     pernia (pernia@freecumextremist.com)'s status on Sunday, 09-Oct-2022 12:14:08 JST pernia

     in reply to

     • VIvi Nella Verita
     @verita84 its a fast-ish box 4 cores 24gb ram, idk if it crashed or something
   • Embed this notice
     VIvi Nella Verita (verita84@pooper.social)'s status on Sunday, 09-Oct-2022 12:14:09 JST VIvi Nella Verita

     in reply to

     Could take hours if your hardware is slow

   • Embed this notice
     grumbulon (grumbulon@freecumextremist.com)'s status on Sunday, 09-Oct-2022 12:15:20 JST grumbulon

     in reply to

     • VIvi Nella Verita
     @pernia @verita84 up to you, fce db is like 70~90 gb and I ran it with -j 12 and it restored in like 2 hours
   • Embed this notice
     pernia (pernia@freecumextremist.com)'s status on Sunday, 09-Oct-2022 12:15:21 JST pernia

     in reply to

     • grumbulon
     • VIvi Nella Verita
     @grumbulon @verita84 should i rerun it with -j 4?
   • Embed this notice
     pernia (pernia@freecumextremist.com)'s status on Sunday, 09-Oct-2022 12:16:43 JST pernia

     in reply to

     • grumbulon
     • VIvi Nella Verita
     @grumbulon @verita84 nvm it just finished :hapysnail:
     postgres is fucking SLOW
     grumbulon likes this.
   • Embed this notice
     grumbulon (grumbulon@freecumextremist.com)'s status on Sunday, 09-Oct-2022 12:17:25 JST grumbulon

     in reply to

     • grumbulon
     • VIvi Nella Verita
     @pernia @verita84 also I feel like this is obvious but if you do -j in the future don't overload it too much I have 16 threads thats why I did 12 concurent processes
   • Embed this notice
     grumbulon (grumbulon@freecumextremist.com)'s status on Sunday, 09-Oct-2022 12:18:10 JST grumbulon

     in reply to

     • VIvi Nella Verita
     @pernia @verita84 if you have too many jobs it wraps around to being slow again?
   • Embed this notice
     pernia (pernia@freecumextremist.com)'s status on Sunday, 09-Oct-2022 12:18:12 JST pernia

     in reply to

     • grumbulon
     • VIvi Nella Verita
     @grumbulon @verita84 y
   • Embed this notice
     grumbulon (grumbulon@freecumextremist.com)'s status on Sunday, 09-Oct-2022 12:19:42 JST grumbulon

     in reply to

     • VIvi Nella Verita
     @pernia @verita84 how does that make no sense
   • Embed this notice
     pernia (pernia@freecumextremist.com)'s status on Sunday, 09-Oct-2022 12:19:44 JST pernia

     in reply to

     • grumbulon
     • VIvi Nella Verita
     @grumbulon @verita84 why does that even happen that makes no sense
   • Embed this notice
     grumbulon (grumbulon@freecumextremist.com)'s status on Sunday, 09-Oct-2022 12:21:54 JST grumbulon

     in reply to

     • VIvi Nella Verita
     @pernia @verita84 To quote the pg_restore documentation
     
     > The optimal value for this option depends on the hardware setup of the server, of the client, and of the network. Factors include the number of CPU cores and the disk setup. A good place to start is the number of CPU cores on the server, but values larger than that can also lead to faster restore times in many cases. Of course, values that are too high will lead to decreased performance because of thrashing.
     
     rtfm :GnuPedophileGrin:
   • Embed this notice
     pernia (pernia@freecumextremist.com)'s status on Sunday, 09-Oct-2022 12:21:55 JST pernia

     in reply to

     • grumbulon
     • VIvi Nella Verita
     @grumbulon @verita84 why would more processes on cpu = slow? its not like the vm is thermal throttling
   • Embed this notice
     kala i think :bluegrinch: (kala_@freecumextremist.com)'s status on Sunday, 09-Oct-2022 12:24:48 JST kala i think :bluegrinch:

     in reply to

     • grumbulon
     • VIvi Nella Verita
     @grumbulon @pernia @verita84
     >hasn’t memorized the manual
     ngmi
     grumbulon likes this.
   • Embed this notice
     grumbulon (grumbulon@freecumextremist.com)'s status on Sunday, 09-Oct-2022 12:24:56 JST grumbulon

     in reply to

     • kala i think :bluegrinch:
     • VIvi Nella Verita
     @kala_ @pernia @verita84 I'm autistic but I'm not retarded
   • Embed this notice
     grumbulon (grumbulon@freecumextremist.com)'s status on Sunday, 09-Oct-2022 12:26:37 JST grumbulon

     in reply to

     • VIvi Nella Verita
     @pernia @verita84 yeah having 2 cores and setting -j to like 15 or higher is probably retarded
   • Embed this notice
     pernia (pernia@freecumextremist.com)'s status on Sunday, 09-Oct-2022 12:26:38 JST pernia

     in reply to

     • grumbulon
     • VIvi Nella Verita
     @grumbulon @verita84 ok yea i've heard of thrashing fair enuf
   • Embed this notice
     grumbulon (grumbulon@freecumextremist.com)'s status on Sunday, 09-Oct-2022 12:27:22 JST grumbulon

     in reply to

     • kala i think :bluegrinch:
     • VIvi Nella Verita
     • BlobMoron
     @nerdman @kala_ @pernia @verita84 glad to know I can do that, I'll keep you in mind next time I need a retarded autist
   • Embed this notice
     BlobMoron (nerdman@blob.cat)'s status on Sunday, 09-Oct-2022 12:27:23 JST BlobMoron

     in reply to

     • grumbulon
     • kala i think :bluegrinch:
     • VIvi Nella Verita
     @grumbulon @kala_ @pernia @verita84
     
     If anyone needs someone autistic AND retarded you can always @ me.
   • Embed this notice
     grumbulon (grumbulon@freecumextremist.com)'s status on Sunday, 09-Oct-2022 12:29:52 JST grumbulon

     in reply to

     • VIvi Nella Verita
     @pernia @verita84 pulling up on my IBM cloud free tier vps running -j 9001 and bringing down their whole infrastructure
   • Embed this notice
     pernia (pernia@freecumextremist.com)'s status on Sunday, 09-Oct-2022 12:29:53 JST pernia

     in reply to

     • grumbulon
     • VIvi Nella Verita
     @grumbulon @verita84 -j 64 on my new athlon 1700