Reputation
12,815
Top tag
Next privilege 15,000 Rep.
Protect questions
Badges
28 59
Newest
 Nice Answer
Impact
~394k people reached

1d
comment Why have both a postmaster and postgres executable?
It was historical. Back in in the earlier days of Postgres it used a fork-exec process to spawn instances of the DBMS, which would then attach to shared memory and synchronisation resources. This was widely used on unix based DBMS platforms of the client-server era - Informix SE, INGRES, interbase, early versions of Sybase, Progress and probably some others worked in this way. Even Oracle has a mode where you can bring it up in this way. Postmaster was a gateway daemon that listened on a port (5432 by default) and spawned instances of the main server when a client connected to it.
Apr
20
awarded  Nice Answer
Apr
6
reviewed Approve What characters are word breakers in English for SQL Server 2005 and 2008 R2?
Apr
6
reviewed Close Time series and gap filling
Mar
11
awarded  Custodian
Mar
11
reviewed No Action Needed mysqlfailover utility (as a HA tool)
Mar
6
comment Integrating Postgres/GIS data in a SQL Server environment without generating 'data islands'
PostgreSQL is a reasonable choice as it has mature support for spatial data and plays nicely with most GIS frontends. You can still master the population and other data on SQL Server and then export it to PostgreSQL (or the other way if needed). SSIS is your friend here.
Feb
18
awarded  Enlightened
Feb
18
awarded  Nice Answer
Feb
2
awarded  Nice Answer
Feb
2
awarded  Nice Answer
Jan
22
awarded  sql-server-2008
Jan
20
answered Datawarehouse bad practice?
Jan
14
comment Free universe tool monitoring all database
Shopping list questions are off-topic for dba.se as they are primarily opinion based and do not necessarily have a definitive correct answer. See the FAQ
Oct
22
awarded  Taxonomist
Sep
24
awarded  Autobiographer
Sep
1
comment How to architect an analytical BI platform?
I doubt you'd find any objective case studies on this sort of kit. It starts at 6 digits and goes up from there, so independents like AnandTech are never going to buy up a batch of machines for comparison. The majority of literature will come from the vendors and should be taken with a grain of salt.
Aug
31
revised How to architect an analytical BI platform?
added 40 characters in body
Aug
31
comment How to architect an analytical BI platform?
There is a question hidden in here, asking whether OP is likely to need a different DBMS platform to support ETL for the system. @sfactor - you might try re-phrasing the question to make this a bit more clear.
Aug
31
answered How to architect an analytical BI platform?