bobflux's user avatar
bobflux's user avatar
bobflux's user avatar
bobflux
  • Member for 7 years
  • Last seen this week
14 votes
Accepted

Is there a performance penalty for unique key constraint violations in Postgres?

5 votes

Asked to Not Use Transactions and to Use A Workaround to Simulate One

5 votes

In MySQL/MariaDB, do Indexes' performance degrade as they become larger and larger?

4 votes

Postgres value that never goes below zero

4 votes
Accepted

Improve query performance of filtered left outer join of big tables

3 votes
Accepted

What database to store 20~ billions rows

3 votes
Accepted

optimize SELECT MAX() with GROUP BY in Postgres?

3 votes

Prevent timing attacks in postgres?

2 votes

Really poor performance when using subquery to get one value

2 votes

What are the pros and cons of using Postgres over SQLite for tiny and small projects?

2 votes

Mysql group by and count queries are slow

2 votes

Is it possible to have a temporary, on-the-fly PostgreSQL table which only ever lives in RAM?

2 votes

How to treat numbers within strings as numbers when sorting ("A3" sorts before "A10", not after)

2 votes

Query is much slower with indexes

2 votes
Accepted

Why is DISCARD ALL called many times in Azure PostgreSQL?

2 votes

Seeking Guidance on Storage Models for Frequently Executed SQL Statement

2 votes
Accepted

Does a commit occur all at same time from a transactional point of view?

2 votes

Design: What should be my PK, FK etc

1 vote

PostgreSQL enforcing order dependent constraints within a query

1 vote

Optimizing Reads on versioned table with multiple ANDed "IN" clauses

1 vote
Accepted

How to improve performance for this query ? Any Suggestions

1 vote

LEFT JOIN LATERAL with a function result, how to prevent unnecessary function calls?

1 vote

Less efficient query plan after merging tables

1 vote

MariaDB- Can i create a unique key requirement if the dates are the same but allow it if they are different?

1 vote

Need help with count query

1 vote

Store a value into a variable

1 vote

Retrieve 1 million rows of user record in postgress

1 vote
Accepted

Joining tables using the longest matching ltree path

1 vote
Accepted

Sum of Round vs Round of Sum

1 vote

Difference between Backup and Snapshot