meta user
network profile
| bio | website | pgexperts.com |
|---|---|---|
| location | San Francisco | |
| age | ||
| visits | member for | 10 months |
| seen | Dec 4 '12 at 0:15 | |
| stats | profile views | 9 |
|
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? |
|
Jul 12 |
awarded | Supporter |
|
Jul 12 |
answered | Postgresql: Two concurrent COPY FROM |
