Chris Travers's user avatar
Chris Travers's user avatar
Chris Travers's user avatar
Chris Travers
  • Member for 10 years, 9 months
  • Last seen this week
53 votes
Accepted

Scalability limitations of PostgreSQL and MySQL

50 votes

Very slow DELETE in PostgreSQL, workaround?

44 votes
Accepted

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

40 votes
Accepted

Increasing work_mem and shared_buffers on Postgres 9.2 significantly slows down queries

38 votes

Most efficient way of bulk deleting rows from postgres

17 votes
Accepted

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

17 votes

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

17 votes

Measure the size of a PostgreSQL table row

16 votes
Accepted

Constrain input to a few different strings

15 votes

What's better/faster? MySql or FileSystem?

15 votes

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

14 votes

Using MongoDB and PostgreSQL together

14 votes

Why is Database Administration so hard?

13 votes
Accepted

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

12 votes

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

12 votes
Accepted

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

11 votes

Setting up a Postgresql Partition with foreign key

11 votes

Why shouldn't we allow NULLs?

10 votes

Should binary files be stored in the database?

10 votes
Accepted

How to create a database for unknown kinds of data?

10 votes

Should developers be able to query production databases?

9 votes

What platform for a large record based mathematical database?

9 votes

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

9 votes
Accepted

Postgres DDL and DML best practices and coding standards

8 votes
Accepted

Graph Database with "non-graph" data

8 votes

Streaming Replication in PostgreSQL

7 votes

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

7 votes
Accepted

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

7 votes
Accepted

how to chain postgres RULEs?

7 votes
Accepted

Cannot `create function` in plpython3u, permission denied

1
2 3 4 5
10