orokusaki's user avatar
orokusaki's user avatar
orokusaki's user avatar
orokusaki
  • Member for 11 years, 2 months
  • Last seen more than a month ago
51 votes
7 answers
83k views

Why does Postgres generate an already used PK value?

11 votes
2 answers
8k views

Why does Postgres ORDER BY seem to halfway ignore leading underscores?

10 votes
1 answer
4k views

How does Postgres 9.2's streaming replication handle schema changes, and initial table setup?

10 votes
1 answer
34k views

Why does `pg_lsclusters` not list my Postgres cluster?

5 votes
1 answer
1k views

Give a “super” user more work_mem

4 votes
1 answer
780 views

Why aren't my Postgres WAL segments (up to the point of turning on archiving) being archived?

3 votes
1 answer
2k views

I need help understanding Postgres's archive cleanup functionality

2 votes
1 answer
658 views

Do I need to perform any tasks after Postgres goes into recovery mode?

1 vote
1 answer
899 views

Why doesn't more memory necessarily make Postgres more performant?

1 vote
1 answer
341 views

Should my Postgres backup server be as beefy (IO, processor, RAM) as my master?

1 vote
1 answer
3k views

How does Postgres know which logs have been archived?

1 vote
1 answer
68 views

Postgres - how to avoid unnecessary comparisons inside a WHERE with a JOIN?

0 votes
1 answer
94 views

Schema Design - would you split this table?