User Chris Travers - Database Administrators Stack Exchange

Chris Travers

Member for 10 years, 9 months
Last seen this week

ledgersmbdev.blogspot.com
Berlin, Germany

295 Answers

Score Activity Newest

53 votes

Accepted

Scalability limitations of PostgreSQL and MySQL

answered Oct 1, 2012 at 3:22

50 votes

Very slow DELETE in PostgreSQL, workaround?

answered Mar 20, 2013 at 10:01

44 votes

Accepted

Performance difference between MySQL and PostgreSQL for the same schema/queries

answered Sep 1, 2013 at 2:14

40 votes

Accepted

Increasing work_mem and shared_buffers on Postgres 9.2 significantly slows down queries

answered Jan 27, 2013 at 15:23

38 votes

Most efficient way of bulk deleting rows from postgres

answered Feb 19, 2013 at 10:37

17 votes

Accepted

Is it better to separate a big query into multiple smaller queries?

answered Feb 23, 2013 at 1:28

17 votes

Is it OK to keep a value which updates in a table?

answered Jan 29, 2013 at 14:02

17 votes

Measure the size of a PostgreSQL table row

answered Sep 7, 2012 at 12:47

16 votes

Accepted

Constrain input to a few different strings

answered Sep 3, 2012 at 0:13

15 votes

What's better/faster? MySql or FileSystem?

answered Aug 31, 2012 at 12:59

15 votes

Why can't RDBM's cluster the way NoSQL does?

answered Feb 23, 2013 at 11:05

14 votes

Using MongoDB and PostgreSQL together

answered Apr 20, 2013 at 15:54

14 votes

Why is Database Administration so hard?

answered Nov 18, 2013 at 9:20

13 votes

Accepted

NoSQL, CouchDB vs. CouchBase, What should i do?

answered Feb 13, 2013 at 14:47

12 votes

USING construct in JOIN clause can introduce optimization barriers in certain cases?

answered Sep 3, 2012 at 7:43

12 votes

Accepted

Postgresql vs MySQL - Which is better for join queries & writing data(inserts)

answered Sep 4, 2013 at 10:53

11 votes

Setting up a Postgresql Partition with foreign key

answered Jan 27, 2013 at 3:11

11 votes

Why shouldn't we allow NULLs?

answered Feb 23, 2013 at 14:08

10 votes

Should binary files be stored in the database?

answered Feb 18, 2013 at 8:17

10 votes

Accepted

How to create a database for unknown kinds of data?

answered Apr 22, 2013 at 5:57

10 votes

Should developers be able to query production databases?

answered Aug 30, 2012 at 6:25

9 votes

What platform for a large record based mathematical database?

answered Feb 13, 2013 at 5:49

9 votes

Custom unique constraint, only enforced if one column has a specific value

answered Mar 24, 2013 at 12:34

9 votes

Accepted

Postgres DDL and DML best practices and coding standards

answered Aug 29, 2013 at 15:21

8 votes

Accepted

Graph Database with "non-graph" data

answered Feb 22, 2013 at 1:22

8 votes

Streaming Replication in PostgreSQL

answered Sep 8, 2012 at 8:56

7 votes

What are the real life cases for using Oracle advanced queuing?

answered Oct 1, 2012 at 2:51

7 votes

Accepted

How to pass a table type with an array field to a function in postgresql

answered Feb 27, 2013 at 12:41

7 votes

Accepted

how to chain postgres RULEs?

answered Mar 16, 2013 at 7:34

7 votes

Accepted

Cannot `create function` in plpython3u, permission denied

answered Mar 22, 2013 at 13:05

1

2 3 4 5

…