275 reputation
214
bio website
location
age
visits member for 2 years, 6 months
seen Sep 13 '13 at 13:28

Dec
1
awarded  Notable Question
Sep
25
awarded  Popular Question
Aug
18
awarded  Popular Question
Jul
17
awarded  Popular Question
Jul
2
awarded  Curious
Jul
3
accepted Bulk update of all columns
Jul
3
comment Bulk update of all columns
If that's the case, then I'll accept this answer. Shame though that postgresql doesn't allow a similar short syntax. Maybe I could request it? if so where?
Jul
3
comment Bulk update of all columns
This is closest to what i'm looking for, updated my question with a note regarding the mapping of columns. in the meantime this will work if not a bit more verbose when you have many columns
Jul
3
revised Bulk update of all columns
added 193 characters in body
Jul
3
comment Bulk update of all columns
The INSERT was showing the data format I was given to update with.
Jul
3
comment Bulk update of all columns
i'm after an update not upsert.
Jul
3
asked Bulk update of all columns
Jun
18
accepted Why don't databases create their own indexes automatically?
Jun
17
awarded  Popular Question
Jun
7
awarded  Nice Question
Jun
4
awarded  Yearling
Jun
4
comment Why don't databases create their own indexes automatically?
@JNK, the point being like AndréParamés said, if it's affecting more queries negatively then it would remove the index again and disregard it as an option for automatic creation and later on when you decided to try it yourself, the server could warn you it's already tried it on X date. you keep saying that it's part art, but it can be boiled down to repetitive modification over time.
Jun
4
comment Why don't databases create their own indexes automatically?
@JNK my previous comment was in response to yours to AndréParamés, i understand that there would be a large cost in implementing an index, and obviously it would be something that was configurable to your environment.
Jun
4
comment Why don't databases create their own indexes automatically?
@JNK that would not be an index that would be automatically applied. something an RDBMS could implement itself would be smaller repetitive queries, the "low hanging fruit" if you will. something where you're constantly filtering on one item, such as all posts from X user.
Jun
4
comment Why don't databases create their own indexes automatically?
@ypercube do you not have redundancy? load balancing? do your queries have to use that index if it's being created? i don't understand why creating an index should lock a table