944 reputation
520
bio website xenoterracide.com
location Austin, TX
age 29
visits member for 3 years, 3 months
seen Mar 29 at 15:46

Desktop

  • Gentoo Linux 2003 - 2009
    • First experience with Linux 4Q 2003
    • Long term functioning, dual boot, Linux install 4Q 2004
    • Stopped using Windows on a regular basis, approximately 2006
  • Arch Linux 2009 - present

Server ( well professionally, as I constantly run servers daemons on my desktop )

  • CentOS 2006 - 2007, 2010 - Present
    • BusinessGrade - Systems Administration Intern
    • Liquid Web - Linux System Administrator

Student, Web Developer, Systems Administrator See more on my blog.

Extended Contact info: xenoterracide@gmail.com: email, msn, gtalk; xenterracide: yahoo,aim,freenode;---


Mar
18
awarded  Nice Question
Feb
25
awarded  Popular Question
Jan
28
comment Postgres 8.3 faster than 9.3?
+1 just arguing that 8.3 is now unsupported, and thus will receive no updates going forward.
Jan
4
awarded  Yearling
Jan
2
comment What database should I use to create a webmail service like gmail?
^ and choose a distributed filesystem for scalability, and ensure that your frontend is restful so you can have different servers serving the frontend. (angularjs would be my recommendation for building the frontend)
Dec
28
awarded  Citizen Patrol
Oct
31
comment Best way to populate a new column in a large table?
in relatively recent (9.x something?) version there are deferred constraints that would allow you to add the not null without immediately having the whole thing populated. depending on what the column is you could then maybe lazily populate the old records if the uuid is not found.
Oct
26
answered A way to reference the ID in a multi insert transaction? (postgres)
Sep
11
comment Text-based interface for PostgreSQL?
I don't think he is, he's looking for something that's more of a curses interface. think, he wants top instead of ps.
Sep
3
comment Benefit to keeping a record in the database, rather than deleting it, for performance issues?
The most common reason for doing this is actually data archiving and analysis, as well as record versioning. It's safer to leave the row around in that context.
Jul
1
awarded  Popular Question
Jun
25
comment Why is Postgres on 64-bit CentOS 6 significantly slower than Postgres on 32-bit CentOS 6
I won't know... but what postgres version are you using? and are you using the centos RPM's or the official postgres one's from the postgres repo's.
Jun
22
awarded  Popular Question
May
2
accepted update column based on the sort order of another query
Apr
4
revised update column based on the sort order of another query
edited tags
Apr
4
asked update column based on the sort order of another query
Apr
4
comment Arbitrarily ordering records in a table
how do you calculate the number in between?
Mar
28
awarded  Notable Question
Mar
6
comment Materialized View PostgreSQL
of course when the beta's start hitting... or you could just build from source...
Jan
11
comment PostgreSQL: how can queries possibly be “immutable” / functional?
the inclusion of a functional feature does not mean that the language is purely functional, nore does the primary paradigm being something else preclude a functional feature.