Erwin Brandstetter

less info

network profile

9,346 reputation

1440

bio	website
	location	Vienna, Austria
	age	93
visits	member for	1 year, 8 months
	seen	39 mins ago
stats	profile views	367

summary answers questions tags badges favorites bounties reputation activity

222 Answers

votes activity newest

19	Pattern matching with LIKE, SIMILAR TO or regular expressions in PostgreSQL
14	PostgreSQL multi-column unique constraint and NULL values
14	Working of indexes in PostgreSQL
12	Is a composite index also good for queries on the first field?
12	PostgreSQL versus MySQL for EAV structures storage

view more

9,346 Reputation

+10	Is there a name for this database structure?
+20	Best practice for storing record metadata
+20	Are regular VACUUM ANALYZE stil recommended under 9.1?
+10	Mirrored tables on PostgreSQL

view more

1 Question

votes activity newest

20	USING construct in JOIN clause can introduce optimization barriers in certain cases?

147 Tags

683 postgresql × 209	72 database-design × 16
167 sql × 49	52 postgresql-9.1 × 14
154 index × 26	39 mysql × 10
142 performance × 26	38 pattern-matching × 6
75 plpgsql × 22	37 query-performance × 11

view more

17 Accounts

	Stack Overflow	61,330 rep	544100
	Database Administrators	9,346 rep	1440
	Meta Stack Overflow	673 rep	214
	Code Review	166 rep	7
	Server Fault	160 rep	18

35 Badges

recent class name

Necromancer × 3	Enlightened × 5
Nice Answer × 11	sql
Popular Question	Custodian × 4
Constituent	Informed
Caucus	Quorum

view more

0 Active bounties

active offered earned

This user has no active bounties

470 Votes Cast

all time			by type			month		week
457	up		242	question		7		1
13	down		228	answer		7		1

Technology			Life / Arts	Culture / Recreation	Science	Other
Stack Overflow Server Fault Super User Web Applications Ask Ubuntu Webmasters Game Development TeX - LaTeX	Programmers Unix & Linux Ask Different (Apple) WordPress Answers Geographic Information Systems Electrical Engineering Android Enthusiasts IT Security	Database Administrators Drupal Answers SharePoint User Experience Mathematica more (14)	Photography Science Fiction & Fantasy Seasoned Advice (cooking) Home Improvement more (13)	English Language & Usage Skeptics Mi Yodeya (Judaism) Travel Christianity Arqade (gaming) Bicycles Role-playing Games more (21)	Mathematics Cross Validated (stats) Theoretical Computer Science Physics more (7)	Stack Apps Meta Stack Overflow Area 51 Stack Overflow Careers

site design / logo © 2013 stack exchange inc; user contributions licensed under cc-wiki with attribution required

rev 2013.6.18.748

Database Administrators Stack Exchange works best with JavaScript enabled