Comments (4)
azygis
commented on August 12, 2024
Would you be able to provide the differences in terms of execution plans? One without new index, one with, on that heavily-loaded database if possible? Would be nice if it's links to dalibo visualizer.
from hangfire.postgresql.
guenaelgonnord
commented on August 12, 2024
Here are 2 screenshots from Query insights (Google CloudSQL PostgreSQL) :
More explain : https://explain.dalibo.com/plan/043bdcc9d5e5cf1a
from hangfire.postgresql.
azygis
commented on August 12, 2024
I don't see why not, honestly. If it helps, it helps, while I personally can't see how it could regress anything. Would you be willing to create a PR for this new index?
from hangfire.postgresql.
azygis
commented on August 12, 2024
It's been merged, but will be released later on when there are more changes. You're free to just continue using the same index as it will later be recreated with an update.
from hangfire.postgresql.
Related Issues (20)
- How inject in hangfire postgres connection HOT 5
- NpgsqlConnectionStringBuilder is not giving updated builder instance for new connection string value. HOT 6
- Unable to run the solution as is in .NET 8 HOT 2
- ExpirationManager issue removing million of jobs HOT 13
- Performance Issues with Postgress HOT 29
- Job supposed to be re-queued on worker shutdown but it never is HOT 38
- NpgsqlDataSource support HOT 3
- How to migrate obsolete PostgreSqlBootstrapperConfigurationExtensions usage HOT 2
- Error "unsupported Unicode escape sequence" after update HOT 1
- EnableHeavyMigrations missing from PostgreSqlStorageOptions HOT 1
- One jobId with two entries of same parameter name in db HOT 1
- Not operating: "Could not place a lock on the resource 'hangfire:locks:schedulepoller': Lock timeout" HOT 1
- 1.8 migration guide HOT 1
- Could not place a lock on the resource 'hangfire:lock:recurring-job:jobid': Lock timeout. HOT 2
- Processing order in Hangfire.PostgreSql? HOT 2
- Implement the List-returning GetFirstByLowestScoreFromSet HOT 3
- Attempting to retrieve FetchedJobs crashes due to duplicates
- Exception when Using NpgsqlDataSource with ConnectionFactory HOT 4
- Loading 5000 Failed jobs when there's even more causes a Memory Leak HOT 2
Recommend Projects
-
React
A declarative, efficient, and flexible JavaScript library for building user interfaces.
-
Vue.js
🖖 Vue.js is a progressive, incrementally-adoptable JavaScript framework for building UI on the web.
-
Typescript
TypeScript is a superset of JavaScript that compiles to clean JavaScript output.
-
TensorFlow
An Open Source Machine Learning Framework for Everyone
-
Django
The Web framework for perfectionists with deadlines.
-
Laravel
A PHP framework for web artisans
-
D3
Bring data to life with SVG, Canvas and HTML. 📊📈🎉
-
Recommend Topics
-
javascript
JavaScript (JS) is a lightweight interpreted programming language with first-class functions.
-
web
Some thing interesting about web. New door for the world.
-
server
A server is a program made to process requests and deliver data to clients.
-
Machine learning
Machine learning is a way of modeling and interpreting data that allows a piece of software to respond intelligently.
-
Visualization
Some thing interesting about visualization, use data art
-
Game
Some thing interesting about game, make everyone happy.
Recommend Org
-
Facebook
We are working to build community through open source technology. NB: members must have two-factor auth.
-
Microsoft
Open source projects and samples from Microsoft.
-
Google
Google ❤️ Open Source for everyone.
-
Alibaba
Alibaba Open Source for everyone
-
D3
Data-Driven Documents codes.
-
Tencent
China tencent open source team.
from hangfire.postgresql.