Reputation
4,507
Top tag
Next privilege 5,000 Rep.
Approve tag wiki edits
Badges
10 24
Impact
~128k people reached

Apr
26
answered What are the differences between “Stored Procedures” and “Stored Functions”?
Apr
19
awarded  Enlightened
Apr
19
awarded  Nice Answer
Apr
17
comment Where does the magic column “name” come from?
It would help to show the definition of site.
Mar
2
comment How to upgrade PostgreSQL minor releases without a dump/restore?
I didn't downvote anything.
Mar
2
answered How to upgrade PostgreSQL minor releases without a dump/restore?
Mar
1
comment How to upgrade PostgreSQL minor releases without a dump/restore?
Which part of "stop the database server, install the updated binaries, and restart the server" are you having problems with?
Feb
25
answered Get a list of databases that have a certain table
Feb
21
answered PostgreSQL: SET-ing from psql arguments
Feb
20
answered Postgresql 8.3: Limit resource consumption per query
Feb
20
answered How do I find PostgreSQL's data directory?
Feb
20
comment How do I find PostgreSQL's data directory?
This is specific to Debian/Ubuntu.
Feb
17
answered Are there any good and free tools for managing a PostgreSQL database?
Feb
16
answered How-to implement an entity with an unknown maximum number of attributes?
Feb
7
comment Why are so many MPP solutions based on PostgreSQL instead of MySQL?
Gaius: What's your point? The MPP solutions discussed here sell proprietary software that is derived from open-source software. They don't sell their software as a service.
Feb
7
answered Why are so many MPP solutions based on PostgreSQL instead of MySQL?
Feb
7
awarded  Commentator
Feb
7
comment Why are so many MPP solutions based on PostgreSQL instead of MySQL?
Well, most of the time, these commercial forks develop their own planner and optimizer to accommodate the distributed or parallel nature of what they are doing.
Jan
28
awarded  Nice Question
Jan
25
answered Why won't some DBMS's allow rollback for certain DDL statements?