Svetlana Orlova
@svetlanao
Member · Member since Mar 2018
Postgres internals.
0 followers · 0 following
Badges and trust level are earned across the whole community.
- Topics created
- 0
- Posts created
- 1
- Likes given
- 27
- Likes received
- 0
- Days visited
- 0
- Solutions
- 0
Days visited count across the whole community, not just this forum.
Most active topics
Nothing yet.
Most liked posts
Nothing yet.
Top categories
Top tags
Nothing yet.
Recent badges
- C#: async void vs async Task
Only for event handlers. Exceptions from async void cannot be caught by the caller and crash the process; use async Task everywhere else.
Likes given · 10/12/2026
- Spark: how to avoid a shuffle when joining a small table?
Broadcast the small side: from pyspark.sql.functions import broadcast facts.join(broadcast(lookup), "country_code") Spark also does this automatically below spa
Likes given · 10/12/2026
- Embedded C: volatile still needed for memory-mapped registers?
Still required: volatile stops the compiler from caching or eliding the accesses. Barriers order accesses but do not force them to happen. You often need both o
Likes given · 10/12/2026
- Floating point: why is 0.1 + 0.2 != 0.3?
0.1 + 0.2 === 0.3 is false in JavaScript. Is the language broken?
Likes given · 10/12/2026
- Async Python: run blocking code without freezing the event loop
Push it to a thread: result = await asyncio.to_thread(blocking_fn, arg) For CPU-heavy work use a process pool with loop.run_in_executor(ProcessPoolExecutor(), f
Likes given · 10/12/2026
- Async Python: run blocking code without freezing the event loop
I call a blocking library function inside an async def handler and the whole server stalls. How do I run it without blocking?
Likes given · 10/12/2026
- Java: concurrent modification exception when removing from a list in a for-each loop
Use removeIf: names.removeIf(String::isBlank); or an explicit Iterator and it.remove().
Likes given · 10/12/2026
- Java: concurrent modification exception when removing from a list in a for-each loop
for (String s : names) { if (s.isBlank()) names.remove(s); } throws ConcurrentModificationException. How should I remove while iterating?
Likes given · 10/12/2026
- Kubernetes pod stuck in CrashLoopBackOff, no logs
--previous showed a missing env var. Thanks!
Likes given · 10/12/2026
- Kubernetes pod stuck in CrashLoopBackOff, no logs
Look at the previous container and the events: kubectl logs mypod --previous kubectl describe pod mypod # check Last State, Exit Code, Events Exit code 137 is
Likes given · 10/12/2026
- SQL: get the latest row per group
For each customer_id I need the most recent order from orders(id, customer_id, created_at, total).
Likes given · 10/12/2026
- Bash: loop over files with spaces in their names
Do not parse ls. Let the shell glob, and quote the variable: for f in *.txt; do printf '%s\n' "$f" done For recursive search use find … -print0 | while IFS= r
Likes given · 10/12/2026
- Go: all goroutines are asleep — deadlock! with an unbuffered channel
A send on an unbuffered channel blocks until another goroutine receives. main is the only goroutine, so it blocks on the send forever. Either receive in another
Likes given · 10/12/2026
- Go: all goroutines are asleep — deadlock! with an unbuffered channel
func main() { ch := make(chan int) ch <- 1 fmt.Println(<-ch) } Why does this deadlock?
Likes given · 10/12/2026
- Docker container exits immediately with code 0
The trailing & backgrounds the process. The container's main process (the shell) then has nothing left to do, exits with 0, and Docker stops the container. Use
Likes given · 10/12/2026
- JavaScript: why does [1, 2, 10].sort() put 10 before 2?
[1, 2, 10].sort() // [1, 10, 2] Is this a bug?
Likes given · 10/12/2026
- PostgreSQL: query is slow even though the column is indexed
Range rewrite: 4 s → 3 ms. Thank you.
Likes given · 10/12/2026
- PostgreSQL: query is slow even though the column is indexed
This query takes ~4 s on a 30M-row table even though created_at has a B-tree index: SELECT * FROM events WHERE date(created_at) = '2026-10-01'; EXPLAIN shows a
Likes given · 10/12/2026
- CSS grid: make the last row items stretch to fill the width
Not with grid alone — grid tracks are shared by every row, so a row cannot have its own column sizes. Use flexbox for that layout: .cards { display: flex; flex-
Likes given · 10/12/2026