4,387 reputation
923
bio website petereisentraut.blogspot.com
location Pennsylvania
age 36
visits member for 3 years, 11 months
seen Dec 15 at 1:36

PostgreSQL and Debian hacker, DBA at MeetMe


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?
Jan
24
comment BLOBs or references in PostgreSQL
Sure. You will need to write a small bit of code to arrange for that (fetching the file data from the database, arranging HTTP download, say), but that is not a blocker.
Jan
23
answered BLOBs or references in PostgreSQL