Skip to content
Navigation menu
Search
Search
Log in
Create account
DEV Community
Close
#
distributed
Follow
Posts
Left menu
👋
Sign in
for the ability to sort posts by
relevant
,
latest
, or
top
.
Right menu
DROP TABLE while being read: wait or wound?
Franck Pachot
Franck Pachot
Franck Pachot
Follow
for
AWS Heroes
May 30
DROP TABLE while being read: wait or wound?
#
distributed
#
sql
#
postgres
#
yugabytedb
Comments
Add Comment
8 min read
Approximate Count for hash sharded YugabyteDB tables
Franck Pachot
Franck Pachot
Franck Pachot
Follow
May 25
Approximate Count for hash sharded YugabyteDB tables
#
yugabytedb
#
postgres
#
distributed
#
sql
Comments
Add Comment
4 min read
Parallel Scan in YugabyteDB (ysql_select_parallelism=-1)
Franck Pachot
Franck Pachot
Franck Pachot
Follow
for
YugabyteDB
May 24
Parallel Scan in YugabyteDB (ysql_select_parallelism=-1)
#
yugabytedb
#
distributed
#
sql
#
database
Comments
Add Comment
3 min read
How ACID is CitusDB?(compared to YugabyteDB)
Franck Pachot
Franck Pachot
Franck Pachot
Follow
for
YugabyteDB
Apr 26
How ACID is CitusDB?(compared to YugabyteDB)
#
distributed
#
sql
#
database
#
yugabytedb
Comments
Add Comment
4 min read
TiDB: Distributed MySQL with Foreign Key but not Serializable
Franck Pachot
Franck Pachot
Franck Pachot
Follow
Apr 28
TiDB: Distributed MySQL with Foreign Key but not Serializable
#
distributed
#
sql
#
database
#
tidb
Comments
Add Comment
5 min read
Range indexes for LIKE queries in YugabyteDB
Franck Pachot
Franck Pachot
Franck Pachot
Follow
for
YugabyteDB
Apr 22
Range indexes for LIKE queries in YugabyteDB
#
yugabytedb
#
postgres
#
distributed
#
sql
Comments
Add Comment
8 min read
pg_hint_plan in views? No. But in UDFs, Yes
Franck Pachot
Franck Pachot
Franck Pachot
Follow
for
AWS Heroes
May 17
pg_hint_plan in views? No. But in UDFs, Yes
#
postgres
#
yugabytedb
#
distributed
#
sql
2
reactions
Comments
Add Comment
10 min read
🦦 What OtterTune hates the most in PostgreSQL🐘 is solved in YugabyteDB🚀
Franck Pachot
Franck Pachot
Franck Pachot
Follow
for
YugabyteDB
Apr 27
🦦 What OtterTune hates the most in PostgreSQL🐘 is solved in YugabyteDB🚀
#
postgres
#
yugabytedb
#
distributed
#
sql
7
reactions
Comments
Add Comment
10 min read
Scalable bounded COUNT DISTINCT in YugabyteDB
Franck Pachot
Franck Pachot
Franck Pachot
Follow
for
YugabyteDB
Apr 9
Scalable bounded COUNT DISTINCT in YugabyteDB
#
yugabytedb
#
distributed
#
sql
#
database
Comments
Add Comment
6 min read
UPSERT in YugabyteDB
Franck Pachot
Franck Pachot
Franck Pachot
Follow
for
YugabyteDB
Apr 3
UPSERT in YugabyteDB
#
yugabytedb
#
distributed
#
sql
#
postgres
2
reactions
Comments
Add Comment
6 min read
Filtering on DENSE_RANK() optimized as pushed-down DISTINCT in YugabyteDB
Franck Pachot
Franck Pachot
Franck Pachot
Follow
for
YugabyteDB
Apr 2
Filtering on DENSE_RANK() optimized as pushed-down DISTINCT in YugabyteDB
#
yugabytedb
#
distributed