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

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
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.
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
Jun
4
comment Why don't databases create their own indexes automatically?
@AndréParamés exactly!
Jun
4
comment Why don't databases create their own indexes automatically?
A database can already put an index on a table it just currently requires us to command it to, a car physically cannot replace a tire, until we build it some arms to use.
Jun
4
comment Why don't databases create their own indexes automatically?
a more accurate analogy is does your ECU alter the power supplied to the fuel pump to fix fuel/oil flow rates and compensate for dirty lines? to which the answer is yes..
Jun
4
comment Why don't databases create their own indexes automatically?
@KennethFisher the idea wasn't to anticipate future workloads, but to improve on recurring ones. for an example, i constantly hit the user table getting a list of all the posts from a user, this happens once every 10 queries and queries happen about 300/sec, couldn't the DB work out that an index on that would be advantageous just from the hit rate?
Jun
4
comment Why don't databases create their own indexes automatically?
why can't they take an iterative approach to it? i understand that on a server that is pushed to the limit already it'd be a bad thing having your DB attempt to tweak itself automatically and so you'd turn it off. but surely if a database is able to suggest queries to you, then it could surely try it out when at lower than average load and determine if there is a performance hit.
Jan
31
comment Master to Slave to Slave Configuration in MySQL
let us continue this discussion in chat
Jan
31
comment Master to Slave to Slave Configuration in MySQL
I have recently updated the snapshot on server 2 by request of the boss
Jan
31
comment Master to Slave to Slave Configuration in MySQL
doesn't appear to have it running
Jan
31
comment Master to Slave to Slave Configuration in MySQL
50MB, server 1 can't go down for more than a minute, server 2/3 are expendable for now, No.
Sep
24
comment Maximum number of databases for single instance of PostgreSQL 9
Wal Archiving for a backup would make sense here.
Sep
11
comment Postgresql WAL Archiving, How to do it properly?
Ok, restore works, but there were a few things they didn't mention in the Docs. namely, that the directory you need to set the restore command to is the data area for postgresql (on ubuntu this is /var/lib/postgresql/<main_version>.<minor_version>/main/), also it doesn't seem to do everything for you in regards to getting the server back online, you still have to physically start the server again, but i suppose thats for safety
Sep
10
comment Postgresql WAL Archiving, How to do it properly?
ok, now i'm taking a standard logical dump to restore from just in case