Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Is this project abandoned? #42

Open
AbelVM opened this issue Sep 23, 2018 · 5 comments

Comments

@AbelVM
Copy link

commented Sep 23, 2018

Just curious.

There is no commit in the last 3 years, 1 year old PR with no answer and several issues without answer or action taken.

Is there any up-to-date fork, or alternative project that fully works with PostgreSQL 10+ features? I have started my own 10+ fork, indeed, just asking to avoid useless extra work if anybody has done it already.

@macobo

This comment has been minimized.

Copy link

commented Oct 28, 2018

Doesn't seem like there is an up-to-date fork according to https://github.com/AlexTatiyants/pev/network

@pgiraud

This comment has been minimized.

Copy link

commented Jul 10, 2019

@AbelVM I've been working on a fork/rewrite as well with a bunch on fixes and new stuff. I hope I can publish it soon.
What are the PostgreSQL 10+ features you are thinking of?

@AbelVM

This comment has been minimized.

Copy link
Author

commented Jul 10, 2019

Parallelism mainly:

  • complete and correct workers support (#26 and #29 )
  • parallel workers' sort activity
  • parallel hash join

And also, as you are working on it 😁 , some nice to have features, not related to Postgres version:

  • Color-coding the join methods( nested, merged, hash joins) and sort methods (external, quicksort, heapsort) based on its theoretical performance from fastest to slowest (green to red), to get a quick look of the selected strategy per node
  • Big warning when a node operation is using disk!!
  • Adding information of the selectivity of a node: output rows/ input rows ratio and visual clue when the ratio is close to 1
  • Pack it as a component, to enable devs to integrate it into other projects instead of being standalone
  • Ability to consume external JSONs, local or remote. This way, it can be connected to a pipeline instead of being an isolated piece where you need to copy&paste the explain results
@pgiraud

This comment has been minimized.

Copy link

commented Aug 6, 2019

@AbelVM As mentioned earlier, I worked on a rewrite of PEV given its inactivity with the hope to mainain and enhance it.
Please have a look at https://github.com/dalibo/pev2
Looking forward to getting feedback.

@AbelVM

This comment has been minimized.

Copy link
Author

commented Aug 6, 2019

Looks über-coo @pgiraud l!

We should move the conversation to your repo, but:

  • Is it planned to go through all the pending issues here? Roadmap? I have seen some of them already fixed in your examples! 😁
  • This: #42 (comment) . There's a parallel branch so... 😬

Will give it an IRL test tomorrow at the office and any further feedback will be posted at your repo

@pgiraud pgiraud referenced this issue Aug 23, 2019
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Projects
None yet
3 participants
You can’t perform that action at this time.