Re: [Pulp-dev] Performance testing results, autoincrement ID vs UUID primary keys

2019-03-01 Thread Daniel Alley
I'm less concerned with the difference between autoincrement vs. UUID speed, and more concerned with how quickly performance was getting worse with database size on PostgreSQL in both cases (and not on MariaDB strangely). There's probably a *lot* that can be done to improve performance that we

Re: [Pulp-dev] Unified interface for plugin actions

2019-03-01 Thread David Davis
I'm curious about how these "actions" are defined. Is the /v3/actions/ namespace limited to plugins? Or, for example, should distribution create/update/delete be nested under /v3/actions/? What about repository create/update/delete? David On Fri, Mar 1, 2019 at 9:08 PM Justin Sherrill wrote:

Re: [Pulp-dev] Performance testing results, autoincrement ID vs UUID primary keys

2019-03-01 Thread Brian Bouterse
I've finally gotten to read through the numbers and this thread. It is a tradeoff but I am +1 for switching to UUIDs. I focus on the PostgreSQL UUID vs int case because that is our default database. I don't think too much about how things perform on MariaDB because they can improve their own

Re: [Pulp-dev] Unified interface for plugin actions

2019-03-01 Thread Justin Sherrill
On 3/1/19 2:45 PM, Robin Chan wrote: Justin, Would such a change make a significant difference in the effort, complexity, or time to migrate existing (or support new) plugins in Katello? It would be a very small and simple change. Robin On Fri, Mar 1, 2019 at 2:00 PM Justin Sherrill

Re: [Pulp-dev] Performance testing results, autoincrement ID vs UUID primary keys

2019-03-01 Thread Dana Walker
As I brought up on irc, I don't know how feasible the complications to maintenance would be going forward, but I would prefer if we could use some sort of settings in order to choose uuid or id based on MariaDB or PostgreSQL. I want us to work everywhere, but I'm really concerned at the impact to

Re: [Pulp-dev] Unified interface for plugin actions

2019-03-01 Thread Robin Chan
Justin, Would such a change make a significant difference in the effort, complexity, or time to migrate existing (or support new) plugins in Katello? Robin On Fri, Mar 1, 2019 at 2:00 PM Justin Sherrill wrote: > To me this makes a lot of sense, allows for plugin flexibility, and is > more

Re: [Pulp-dev] Unified interface for plugin actions

2019-03-01 Thread Dana Walker
+1 to what Justin said. I think it's a huge benefit to have the differences between plugins show up in the api docs together. Dana Walker Associate Software Engineer Red Hat On Fri, Mar 1, 2019 at 2:00 PM Justin Sherrill wrote: > To me this

Re: [Pulp-dev] Unified interface for plugin actions

2019-03-01 Thread Justin Sherrill
To me this makes a lot of sense, allows for plugin flexibility, and is more consistent across plugins. I feel like this will make differences between plugins more understandable by reading the api docs, rather than scanning the README's of the respective plugin and trying to work out what is

Re: [Pulp-dev] Performance testing results, autoincrement ID vs UUID primary keys

2019-03-01 Thread David Davis
I just want to bump this thread. If we hope to make the Pulp 3 RC date, we need feedback today. David On Wed, Feb 27, 2019 at 5:09 PM Matt Pusateri wrote: > Not sure if https://www.webyog.com/ Monyog will give a free opensource > project license. But that might help diagnose the MariaDB