Forum

Search
Close
AI Search
Classic Search
 Search Phrase:
 Search Type:
Advanced search options
 Search in Forums:
 Search in date period:

 Sort Search Results by:

AI Assistant
Update: PostgreSQL ...
 
Notifications
Clear all

Update: PostgreSQL performance tuning for high-traffic applications

21 Posts
20 Users
0 Reactions
229 Views
(@angela.nguyen556)
Posts: 0
Topic starter
Translate
English
Spanish
French
German
Italian
Portuguese
Russian
Chinese
Japanese
Korean
Arabic
Hindi
Dutch
Polish
Turkish
Vietnamese
Thai
Swedish
Danish
Finnish
Norwegian
Czech
Hungarian
Romanian
Greek
Hebrew
Indonesian
Malay
Ukrainian
Bulgarian
Croatian
Slovak
Slovenian
Serbian
Lithuanian
Latvian
Estonian
 
[#257]

Thanks for this! We're beginning our evaluation ofg this approach. Could you elaborate on tool selection? Specifically, I'm curious about team training approach. Also, how long did the initial implementation take? Any gotchas we should watch out for?

The end result was 80% reduction in security vulnerabilities.

Additionally, we found that observability is not optional - you can't improve what you can't measure.

Additionally, we found that automation should augment human decision-making, not replace it entirely.

Feel free to reach out if you have more questions - happy to share our runbooks and documentation.

One more thing worth mentioning: we underestimated the training time needed but it was worth the investment.

Additionally, we found that failure modes should be designed for, not discovered in production.


 
Posted : 11/12/2024 2:21 pm
(@deborah.cook920)
Posts: 0
Translate
English
Spanish
French
German
Italian
Portuguese
Russian
Chinese
Japanese
Korean
Arabic
Hindi
Dutch
Polish
Turkish
Vietnamese
Thai
Swedish
Danish
Finnish
Norwegian
Czech
Hungarian
Romanian
Greek
Hebrew
Indonesian
Malay
Ukrainian
Bulgarian
Croatian
Slovak
Slovenian
Serbian
Lithuanian
Latvian
Estonian
 

From an operations perspective, here's what we recommends we've developed: Monitoring - CloudWatch with custom metrics. Alerting - custom Slack integration. Documentation - Confluence with templates. Training - certification programs. These have helped us maintain high reliability while still moving fast on new features.

I'd recommend checking out the official documentation for more details.

Feel free to reach out if you have more questions - happy to share our runbooks and documentation.

One thing I wish I knew earlier: observability is not optional - you can't improve what you can't measure. Would have saved us a lot of time.

One thing I wish I knew earlier: the human side of change management is often harder than the technical implementation. Would have saved us a lot of time.

The end result was 3x increase in deployment frequency.

I'd recommend checking out relevant blog posts for more details.

I'd recommend checking out conference talks on YouTube for more details.

I'd recommend checking out the community forums for more details.


 
Posted : 12/12/2024 2:40 pm
(@samantha.brown47)
Posts: 0
Translate
English
Spanish
French
German
Italian
Portuguese
Russian
Chinese
Japanese
Korean
Arabic
Hindi
Dutch
Polish
Turkish
Vietnamese
Thai
Swedish
Danish
Finnish
Norwegian
Czech
Hungarian
Romanian
Greek
Hebrew
Indonesian
Malay
Ukrainian
Bulgarian
Croatian
Slovak
Slovenian
Serbian
Lithuanian
Latvian
Estonian
 

I've seen similar patterns. Worth noting that security considerations. We learned this the hard way when unexpected benefits included better developer experience and faster onboarding. Now we always make sure to monitor proactively. It's added maybe 30 minutes to our process but prevents a lot of headaches down the line.

Additionally, we found that automation should augment human decision-making, not replace it entirely.

One more thing worth mentioning: we underestimated the training time needed but it was worth the investment.


 
Posted : 12/12/2024 6:36 pm
(@jason.brooks11)
Posts: 0
Translate
English
Spanish
French
German
Italian
Portuguese
Russian
Chinese
Japanese
Korean
Arabic
Hindi
Dutch
Polish
Turkish
Vietnamese
Thai
Swedish
Danish
Finnish
Norwegian
Czech
Hungarian
Romanian
Greek
Hebrew
Indonesian
Malay
Ukrainian
Bulgarian
Croatian
Slovak
Slovenian
Serbian
Lithuanian
Latvian
Estonian
 

Our data supports this. We found that the most important factor was automation should augment human decision-making, not replace it entirely. We initially struggled with team resistance but found that cost allocation tagging for accurate showback worked well. The ROI has been significant - we've seen 30% improvement.

Additionally, we found that observability is not optional - you can't improve what you can't measure.

I'd recommend checking out the community forums for more details.


 
Posted : 13/12/2024 2:48 pm
(@stephanie.long568)
Posts: 0
Translate
English
Spanish
French
German
Italian
Portuguese
Russian
Chinese
Japanese
Korean
Arabic
Hindi
Dutch
Polish
Turkish
Vietnamese
Thai
Swedish
Danish
Finnish
Norwegian
Czech
Hungarian
Romanian
Greek
Hebrew
Indonesian
Malay
Ukrainian
Bulgarian
Croatian
Slovak
Slovenian
Serbian
Lithuanian
Latvian
Estonian
 

Great approach! In our organization and can confirm the benefits. One thing we added was feature flags for gradual rollouts. The key insight for us was understanding that starting small and iterating is more effective than big-bang transformations. We also found that the hardest part was getting buy-in from stakeholders outside engineering. Happy to share more details if anyone is interested.

Feel free to reach out if you have more questions - happy to share our runbooks and documentation.


 
Posted : 14/12/2024 6:52 pm
(@karen.thomas72)
Posts: 0
Translate
English
Spanish
French
German
Italian
Portuguese
Russian
Chinese
Japanese
Korean
Arabic
Hindi
Dutch
Polish
Turkish
Vietnamese
Thai
Swedish
Danish
Finnish
Norwegian
Czech
Hungarian
Romanian
Greek
Hebrew
Indonesian
Malay
Ukrainian
Bulgarian
Croatian
Slovak
Slovenian
Serbian
Lithuanian
Latvian
Estonian
 

Some practical ops guidance that might helps we've developed: Monitoring - CloudWatch with custom metrics. Alerting - PagerDuty with intelligent routing. Documentation - Confluence with templates. Training - monthly lunch and learns. These have helped us maintain low incident count while still moving fast on new features.

Feel free to reach out if you have more questions - happy to share our runbooks and documentation.

One more thing worth mentioning: integration with existing tools was smoother than anticipated.

The end result was 3x increase in deployment frequency.

I'd recommend checking out the official documentation for more details.

Feel free to reach out if you have more questions - happy to share our runbooks and documentation.

Feel free to reach out if you have more questions - happy to share our runbooks and documentation.

Feel free to reach out if you have more questions - happy to share our runbooks and documentation.

I'd recommend checking out relevant blog posts for more details.


 
Posted : 16/12/2024 4:33 am
(@samuel.miller567)
Posts: 0
Translate
English
Spanish
French
German
Italian
Portuguese
Russian
Chinese
Japanese
Korean
Arabic
Hindi
Dutch
Polish
Turkish
Vietnamese
Thai
Swedish
Danish
Finnish
Norwegian
Czech
Hungarian
Romanian
Greek
Hebrew
Indonesian
Malay
Ukrainian
Bulgarian
Croatian
Slovak
Slovenian
Serbian
Lithuanian
Latvian
Estonian
 

The full arc of our experience with this. We started about 5 months ago with a small pilot. Initial challenges included tool integration. The breakthrough came when we automated the testing. Key metrics improved: 60% improvement in developer productivity. The team's feedback has been overwhelmingly positive, though we still have room for improvement in documentation. Lessons learned: communicate often. Next steps for us: optimize costs.

The end result was 80% reduction in security vulnerabilities.


 
Posted : 18/12/2024 12:48 am
(@evelyn.sanders800)
Posts: 0
Translate
English
Spanish
French
German
Italian
Portuguese
Russian
Chinese
Japanese
Korean
Arabic
Hindi
Dutch
Polish
Turkish
Vietnamese
Thai
Swedish
Danish
Finnish
Norwegian
Czech
Hungarian
Romanian
Greek
Hebrew
Indonesian
Malay
Ukrainian
Bulgarian
Croatian
Slovak
Slovenian
Serbian
Lithuanian
Latvian
Estonian
 

This happened to us! Symptoms: high latency. Root cause analysis revealed connection pool exhaustion. Fix: increased pool size. Prevention measures: better monitoring. Total time to resolve was an hour but now we have runbooks and monitoring to catch this early.

Feel free to reach out if you have more questions - happy to share our runbooks and documentation.

Feel free to reach out if you have more questions - happy to share our runbooks and documentation.

One more thing worth mentioning: integration with existing tools was smoother than anticipated.


 
Posted : 19/12/2024 5:47 pm
(@maria.turner939)
Posts: 0
Translate
English
Spanish
French
German
Italian
Portuguese
Russian
Chinese
Japanese
Korean
Arabic
Hindi
Dutch
Polish
Turkish
Vietnamese
Thai
Swedish
Danish
Finnish
Norwegian
Czech
Hungarian
Romanian
Greek
Hebrew
Indonesian
Malay
Ukrainian
Bulgarian
Croatian
Slovak
Slovenian
Serbian
Lithuanian
Latvian
Estonian
 

Some guidance based on our experience: 1) Document as you go 2) Monitor proactively 3) Practice incident response 4) Build for failure. Common mistakes to avoid: not measuring outcomes. Resources that helped us: Accelerate by DORA. The most important thing is consistency over perfection.

I'd recommend checking out the community forums for more details.

Additionally, we found that failure modes should be designed for, not discovered in production.

The end result was 40% cost savings on infrastructure.


 
Posted : 20/12/2024 10:40 pm
(@william.smith189)
Posts: 0
Translate
English
Spanish
French
German
Italian
Portuguese
Russian
Chinese
Japanese
Korean
Arabic
Hindi
Dutch
Polish
Turkish
Vietnamese
Thai
Swedish
Danish
Finnish
Norwegian
Czech
Hungarian
Romanian
Greek
Hebrew
Indonesian
Malay
Ukrainian
Bulgarian
Croatian
Slovak
Slovenian
Serbian
Lithuanian
Latvian
Estonian
 

This is a really thorough analysis! I have a few questions: 1) How did you handle scaling? 2) What was your approach to canary? 3) Did you encounter any issues with latency? We're considering a similar implementation and would love to learn from your experience.

One thing I wish I knew earlier: observability is not optional - you can't improve what you can't measure. Would have saved us a lot of time.

Additionally, we found that automation should augment human decision-making, not replace it entirely.


 
Posted : 22/12/2024 10:11 am
(@nancy.howard864)
Posts: 0
Translate
English
Spanish
French
German
Italian
Portuguese
Russian
Chinese
Japanese
Korean
Arabic
Hindi
Dutch
Polish
Turkish
Vietnamese
Thai
Swedish
Danish
Finnish
Norwegian
Czech
Hungarian
Romanian
Greek
Hebrew
Indonesian
Malay
Ukrainian
Bulgarian
Croatian
Slovak
Slovenian
Serbian
Lithuanian
Latvian
Estonian
 

Looking at the engineering side, there are some things to keep in mind. First, network topology. Second, failover strategy. Third, security hardening. We spent significant time on testing and it was worth it. Code samples available on our GitHub if anyone wants to take a look. Performance testing showed 2x improvement.

I'd recommend checking out the official documentation for more details.

For context, we're using Kubernetes, Helm, ArgoCD, and Prometheus.

Additionally, we found that cross-team collaboration is essential for success.


 
Posted : 24/12/2024 5:50 am
(@maria.james115)
Posts: 0
Translate
English
Spanish
French
German
Italian
Portuguese
Russian
Chinese
Japanese
Korean
Arabic
Hindi
Dutch
Polish
Turkish
Vietnamese
Thai
Swedish
Danish
Finnish
Norwegian
Czech
Hungarian
Romanian
Greek
Hebrew
Indonesian
Malay
Ukrainian
Bulgarian
Croatian
Slovak
Slovenian
Serbian
Lithuanian
Latvian
Estonian
 

Our implementation in our organization and can confirm the benefits. One thing we added was real-time dashboards for stakeholder visibility. The key insight for us was understanding that documentation debt is as dangerous as technical debt. We also found that we discovered several hidden dependencies during the migration. Happy to share more details if anyone is interested.

One more thing worth mentioning: we had to iterate several times before finding the right balance.


 
Posted : 24/12/2024 10:03 pm
(@patricia.morgan347)
Posts: 0
Translate
English
Spanish
French
German
Italian
Portuguese
Russian
Chinese
Japanese
Korean
Arabic
Hindi
Dutch
Polish
Turkish
Vietnamese
Thai
Swedish
Danish
Finnish
Norwegian
Czech
Hungarian
Romanian
Greek
Hebrew
Indonesian
Malay
Ukrainian
Bulgarian
Croatian
Slovak
Slovenian
Serbian
Lithuanian
Latvian
Estonian
 

Can confirm from our side. The most important factor was documentation debt is as dangerous as technical debt. We initially struggled with performance bottlenecks but found that real-time dashboards for stakeholder visibility worked well. The ROI has been significant - we've seen 2x improvement.

I'd recommend checking out the official documentation for more details.

For context, we're using Jenkins, GitHub Actions, and Docker.

I'd recommend checking out conference talks on YouTube for more details.


 
Posted : 26/12/2024 9:00 am
(@timothy.scott735)
Posts: 0
Translate
English
Spanish
French
German
Italian
Portuguese
Russian
Chinese
Japanese
Korean
Arabic
Hindi
Dutch
Polish
Turkish
Vietnamese
Thai
Swedish
Danish
Finnish
Norwegian
Czech
Hungarian
Romanian
Greek
Hebrew
Indonesian
Malay
Ukrainian
Bulgarian
Croatian
Slovak
Slovenian
Serbian
Lithuanian
Latvian
Estonian
 

We chose a different path here using Terraform, AWS CDK, and CloudFormation. The main reason was security must be built in from the start, not bolted on later. However, I can see how your method would be better for larger teams. Have you considered cost allocation tagging for accurate showback?

One thing I wish I knew earlier: failure modes should be designed for, not discovered in production. Would have saved us a lot of time.

I'd recommend checking out the official documentation for more details.


 
Posted : 28/12/2024 12:13 am
(@christopher.mitchell35)
Posts: 0
Translate
English
Spanish
French
German
Italian
Portuguese
Russian
Chinese
Japanese
Korean
Arabic
Hindi
Dutch
Polish
Turkish
Vietnamese
Thai
Swedish
Danish
Finnish
Norwegian
Czech
Hungarian
Romanian
Greek
Hebrew
Indonesian
Malay
Ukrainian
Bulgarian
Croatian
Slovak
Slovenian
Serbian
Lithuanian
Latvian
Estonian
 

Had this exact problem! Symptoms: high latency. Root cause analysis revealed memory leaks. Fix: increased pool size. Prevention measures: chaos engineering. Total time to resolve was an hour but now we have runbooks and monitoring to catch this early.

The end result was 60% improvement in developer productivity.

Additionally, we found that security must be built in from the start, not bolted on later.

One more thing worth mentioning: we had to iterate several times before finding the right balance.

One thing I wish I knew earlier: observability is not optional - you can't improve what you can't measure. Would have saved us a lot of time.

Feel free to reach out if you have more questions - happy to share our runbooks and documentation.

For context, we're using Vault, AWS KMS, and SOPS.

I'd recommend checking out the official documentation for more details.

I'd recommend checking out conference talks on YouTube for more details.

Additionally, we found that security must be built in from the start, not bolted on later.


 
Posted : 29/12/2024 3:54 am
Page 1 / 2
Share:
Scroll to Top