511 reputation
13
bio website pgexperts.com
location San Francisco
age
visits member for 1 year, 9 months
seen Mar 27 at 21:51

Dec
3
comment How to switch master server and warm standby (with streaming replication) in PostgreSQL?
a warm standby or a hot standby? In Postgres, "warm standby" is usually used to refer to a second server which is keeping up to date, but not accepting connections.
Aug
16
comment Can I get the union of the a Postgres fulltext index?
What do you mean by "terms used in the index"? A fulltext index indexes all of the words in the column.
Aug
14
comment How do you figure out what planner cost constants to use in Postgres?
A server which is very similar to production, and a synthetic test workload based on production which you can run and do statistical measurements of comparative overall execution times from. The problem with just changing a parameter is it can make one query better while making many others worse.
Jul
13
comment Why is my postmaster process (sometimes) becoming unmanageable after a WAL base restore?
define "unmanageable", please
Jul
12
comment Why is my postmaster process (sometimes) becoming unmanageable after a WAL base restore?
are you saying you can psql into postgres? Then it's not hung. Maybe you're restoring the wrong file? Or init'ing the wrong directory?