Hello! In spryker package `spy_price_product_store` there is an index of `spy_price_product_store-i

Alberto Reyer

I know that Heapanalytics is using https://github.com/citusdata/citus to shard their data by customer transparently.
Maybe it’s worth a look for you (disclaimer, I’ve never worked with citus myself)

Unknown

can you make a performance test without the index, @UNBSW8S8K?

UNBSW8S8K

I am trying to drop it, but it takes forever. Running for 2 hrs already.

UNBSW8S8K

I will give an update, when it’s gone. @UJN2JRU4F

Unknown

😕

UNBSW8S8K

Ok. So it just dropped

UNBSW8S8K

This is explain analyze run w/o index

UNBSW8S8K

It finished really fast now…

UNBSW8S8K

So it is cause of that index for sure.

Alberto Reyer

Not problem related, but I can recommend http://tatiyants.com/pev/#/plans for query plan visualization 😉 Comes in pretty handy to read a query plan and see what is the real problem.

Valerii Trots

I'm not sure if it's helpful, but still - https://github.com/spryker/propel/releases/tag/3.16.0.

ULTE9DBGX

Good morning @valerii.trots with this release as far as i could see i can overwrite indexes but not dropping them right? there is any plan for dropping it as well?

Valerii Trots

Hi @ULTE9DBGX, yes, there are not only plans but ready to be released PR. So I will try not to forget to update once it's out.

ULTE9DBGX

Thanks

Valerii Trots

https://github.com/spryker/propel/releases/tag/3.16.1

ULTE9DBGX

Already updated it, it worked, thanks