4,332 reputation
922
bio website petereisentraut.blogspot.com
location Pennsylvania
age 35
visits member for 3 years, 9 months
seen Oct 2 at 0:50

PostgreSQL and Debian hacker, DBA at MeetMe


Jun
12
answered Prune unused joins
May
30
answered Change built-in default privileges in PostgreSQL?
May
28
comment How to get the information of the optimizer of PostgreSQL?
Look for "PLANNER STATISTICS" at level "LOG" in the server log.
May
21
answered Why does postgres use more space for a time with timezone than a timestamp with timezone?
May
16
answered psql coloured prompt misbehaving
May
16
answered How to get the information of the optimizer of PostgreSQL?
Apr
28
comment Is there better way to 'touch' a row than performing a dummy update?
That certainly sounds more sane.
Apr
24
answered Is there better way to 'touch' a row than performing a dummy update?
Apr
24
answered “Rewinding” a Postgresql database
Apr
2
awarded  Nice Answer
Mar
4
comment PostgreSQL 9.1 streaming replication problem: replica fails to use an index properly
Yes, if you replicate to an OS with a different locale implementation, things will break badly.
Feb
21
answered issues with encoding and pg_dump/restore between windows and linux
Feb
11
answered PostgreSQL 9.1, how to restore a Hot Standby Slave w/o any Wal Files?
Feb
5
revised Struggling with pgBouncer
add pgbouncer tag
Feb
5
answered Struggling with pgBouncer
Jan
16
answered PostgreSQL replication
Jan
4
awarded  Revival
Jan
4
answered ON DELETE CASCADE on pg_class in PostgreSQL does not work
Jan
3
awarded  Yearling
Jan
2
comment Tool for Reverse Engineering of PostgreSQL Database on Linux (Ubuntu)
That creates a table diagram. Getting from there to an entity-relationship diagram is another step.