Skip to main content
Chris Travers's user avatar
Chris Travers's user avatar
Chris Travers's user avatar
Chris Travers
  • Member for 11 years, 10 months
  • Last seen more than a week ago
55 votes

Very slow DELETE in PostgreSQL, workaround?

54 votes
Accepted

Scalability limitations of PostgreSQL and MySQL

44 votes
Accepted

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

42 votes

Most efficient way of bulk deleting rows from postgres

40 votes
Accepted

Increasing work_mem and shared_buffers on Postgres 9.2 significantly slows down queries

18 votes

Measure the size of a PostgreSQL table row

17 votes

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

16 votes
Accepted

Constrain input to a few different strings

16 votes
Accepted

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

15 votes

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

15 votes

What's better/faster? MySql or FileSystem?

14 votes

Why is Database Administration so hard?

14 votes

Using MongoDB and PostgreSQL together

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

Why shouldn't we allow NULLs?

11 votes

Should developers be able to query production databases?

11 votes

Setting up a Postgresql Partition with foreign key

10 votes

Should binary files be stored in the database?

10 votes
Accepted

How to create a database for unknown kinds of data?

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

9 votes

What platform for a large record based mathematical database?

8 votes

Streaming Replication in PostgreSQL

8 votes

How to fine-tune Postgres for IO usage?

8 votes
Accepted

Graph Database with "non-graph" data

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

Inconsistency in repeatable read

1
2 3 4 5
10