PostgreSQL Performance Optimization | Antigravity AI Directory

.antigravity

# PostgreSQL Optimization

## Indexing Strategies
- Create indexes on foreign keys
- Use partial indexes
- Implement multi-column indexes
- Monitor index usage

## Query Optimization
- Use EXPLAIN ANALYZE
- Avoid SELECT *
- Use CTEs appropriately
- Implement proper JOINs

## Connection Pooling
- Use pg_bouncer
- Configure pool size
- Handle connection lifecycle
- Monitor pool usage

## Performance Monitoring
- Use pg_stat_statements
- Monitor slow queries
- Analyze query plans
- Set up performance alerts

When to Use This Prompt

This PostgreSQL prompt is ideal for developers working on:

PostgreSQL applications requiring modern best practices and optimal performance
Projects that need production-ready PostgreSQL code with proper error handling
Teams looking to standardize their postgresql development workflow
Developers wanting to learn industry-standard PostgreSQL patterns and techniques

By using this prompt, you can save hours of manual coding and ensure best practices are followed from the start. It's particularly valuable for teams looking to maintain consistency across their postgresql implementations.

How to Use

Copy the prompt - Click the copy button above to copy the entire prompt to your clipboard
Paste into your AI assistant - Use with Claude, ChatGPT, Cursor, or any AI coding tool
Customize as needed - Adjust the prompt based on your specific requirements
Review the output - Always review generated code for security and correctness

💡 Pro Tip: For best results, provide context about your project structure and any specific constraints or preferences you have.

Best Practices

✓ Always review generated code for security vulnerabilities before deploying
✓ Test the PostgreSQL code in a development environment first
✓ Customize the prompt output to match your project's coding standards
✓ Keep your AI assistant's context window in mind for complex requirements
✓ Version control your prompts alongside your code for reproducibility

Frequently Asked Questions

Can I use this PostgreSQL prompt commercially?

Yes! All prompts on Antigravity AI Directory are free to use for both personal and commercial projects. No attribution required, though it's always appreciated.

Which AI assistants work best with this prompt?

This prompt works excellently with Claude, ChatGPT, Cursor, GitHub Copilot, and other modern AI coding assistants. For best results, use models with large context windows.

How do I customize this prompt for my specific needs?

You can modify the prompt by adding specific requirements, constraints, or preferences. For PostgreSQL projects, consider mentioning your framework version, coding style, and any specific libraries you're using.

Related Prompts

💬 Comments

Loading comments...

# PostgreSQL Optimization ## Indexing Strategies - Create indexes on foreign keys - Use partial indexes - Implement multi-column indexes - Monitor index usage ## Query Optimization - Use EXPLAIN ANALYZE - Avoid SELECT * - Use CTEs appropriately - Implement proper JOINs ## Connection Pooling - Use pg_bouncer - Configure pool size - Handle connection lifecycle - Monitor pool usage ## Performance Monitoring - Use pg_stat_statements - Monitor slow queries - Analyze query plans - Set up performance alerts