541 reputation
23
bio website pgexperts.com
location San Francisco
age
visits member for 2 years, 1 month
seen May 2 at 21:58

Aug
8
answered Postgresql query plan differs with limit value making the query slower for lower limits
Jul
12
awarded  Yearling
Nov
22
awarded  Nice Answer
Jul
12
awarded  Yearling
Jun
14
answered How to drop inheritance?
May
2
answered Why do psql queries take longer when inserting many rows. Why is it non linear
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.
Oct
14
answered How can I create a dblink from Postgresql 8.3 to SQL Server (2000 and 2008)?
Oct
14
answered Why does PostgreSQL aggregate result in the Index or Seq scan outputting all columns of the table?
Sep
30
answered Which performance can I expect?
Aug
16
answered PostgreSQL hot standby promotion, multiple hot standbys
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.
Aug
3
answered How do you figure out what planner cost constants to use in Postgres?
Jul
28
answered Aggressive Autovacuum on PostgreSQL
Jul
13
comment Why is my postmaster process (sometimes) becoming unmanageable after a WAL base restore?
define "unmanageable", please
Jul
12
awarded  Teacher
Jul
12
answered How to configure postgresql to use multiple cores?
Jul
12
answered PostgreSQL data type text vs varchar without length
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?