What are the Slack Archives?
It’s a history of our time together in the Slack Community! There’s a ton of knowledge in here, so feel free to search through the archives for a possible answer to your question.
Because this space is not active, you won’t be able to create a new post or comment here. If you have a question or want to start a discussion about something, head over to our categories and pick one to post in! You can always refer back to a post from Slack Archives if needed; just copy the link to use it as a reference..
Hello, maybe there is a chance anybody had performance problems updating spy_touch table? PostgeSQL
Hello, maybe there is a chance anybody had performance problems updating spy_touch table?
PostgeSQL version: 9.6.19spy_touch number or records: 3,846,538
Import process hangs on UPDATE "spy_touch" SET "touched"=$1 WHERE "spy_touch"."id_touch"=$2 . Sometimes this query takes 10+ minutes to execute.
Comments
-
spy_touch… sounds like a distant memory 😊
0 -
is theere maybe an index missing?
0 -
the query alone taks 10 mins 🤔
0 -
with an id lookup?
0 -
with that amount of data it should not eveen take anywhere near that time even with a sequential scan
0 -
indexes are there
0 -
ah, it is a string, right?
0 -
but wait
0 -
yup, it should not take that long...
0 -
Maybe some data imports lock the table?
0 -
Well this happens during data import, and the import hangs from time to time. Even if the table is locked it should not take 10 minutes for single row update 🤔
0 -
deadlocks could occur and block things for a long time, but thats not spryker specific. More Spryker specific could be FK constraints that lock other tables or have relations to much bigger tables that take time, too.
0 -
Won't Postgres reindex on INSERTS and UPDATES? Large tables with large indexes might have low write performance due to index updates.
0
Categories
- All Categories
- 42 Getting Started & Guidelines
- 7 Getting Started in the Community
- 8 Additional Resources
- 7 Community Ideas and Feedback
- 75 Spryker News
- 924 Developer Corner
- 783 Spryker Development
- 88 Spryker Dev Environment
- 362 Spryker Releases
- 3 Oryx frontend framework
- 35 Propel ORM
- 68 Community Projects
- 3 Community Ideation Board
- 30 Hackathon
- 3 PHP Bridge
- 6 Gacela Project
- 25 Job Opportunities
- 3.2K 📜 Slack Archives
- 116 Academy
- 5 Business Users
- 370 Docker
- 551 Slack General
- 2K Help
- 75 Knowledge Sharing
- 6 Random Stuff
- 4 Code Testing
- 32 Product & Business Questions
- 70 Spryker Safari Questions
- 50 Random