281 reputation
15
bio website
location
age
visits member for 3 years, 4 months
seen Sep 27 '13 at 20:11

Apr
30
awarded  Yearling
Nov
10
comment Single Drive vs Multiple Drives
I'm sorry, but I've never seen any significant increase in seek times due to striping. Wikipedia suggests the opposite effect.
Nov
8
awarded  Commentator
Nov
8
comment Single Drive vs Multiple Drives
Please do elaborate..
Oct
29
revised Single Drive vs Multiple Drives
added 14 characters in body
Sep
28
comment Using the name of a table contained in a field of another table?
XY problem
Sep
23
comment Using the name of a table contained in a field of another table?
I'm telling you to reconsider your data model.
Sep
23
comment Using the name of a table contained in a field of another table?
Sure you shouldn't be asking for data modeling input, rather than help on implementing the design you've come up with?
Sep
22
revised Single Drive vs Multiple Drives
deleted 1 characters in body
Sep
22
awarded  Critic
Sep
22
answered Single Drive vs Multiple Drives
Jun
22
awarded  Editor
Jun
22
revised How can I convert from Double Precision to Bigint with PostgreSQL?
added 137 characters in body
Jun
22
answered How can I convert from Double Precision to Bigint with PostgreSQL?
May
17
comment Finding empty columns of a table in PostgreSQL
Why would you need to do that? Sounds like you have too many columns/tables and should rethink your design.
May
9
comment What features of Oracle make it an attractive choice for small projects?
@Leigh Riffel -- It's "Postgres". The S does double duty, both as part of the original name, and part of "sql".
May
9
comment What features of Oracle make it an attractive choice for small projects?
Although not supporting index organized tables, Postgres does let you reorder existing tuples to index order with the CLUSTER function. You could use WAL shipping for incremental backup. There is excellent support for triggers, and a wide range of date/time -functions. -- One feature I love about Postgres is that DDL is transactional. Does Oracle have that?
May
9
comment What features of Oracle make it an attractive choice for small projects?
Your 2nd reason for choosing Oracle is pretty much the same as the 1st, IMO. Basically that you're committed. -- As for support, that certainly exists for Postgres as well. If you're not happy with the excellent mailing lists, check out this list for companies offering paid support in your region.
May
2
awarded  Teacher
May
2
answered How could DBAs be more 'programmer friendly'?