network profile
| bio | website | storytotell.org |
|---|---|---|
| location | Socorro, NM | |
| age | 31 | |
| visits | member for | 1 year, 4 months |
| seen | May 13 at 20:23 | |
| stats | profile views | 26 |
|
May 13 |
awarded | Caucus |
|
Jan 15 |
awarded | Popular Question |
|
Jan 5 |
awarded | Yearling |
|
Apr 25 |
comment |
Optimisation Newbie: How much of a 'sin' is redundancy? In general, I agree, but @PlankTon is clearly talking about adding summary columns to one table. There's an obvious source-derived relationship between the votes and the count of votes. If they disagree, the count is wrong and should be regenerated. |
|
Apr 23 |
accepted | Dropping indexes doesn't seem to release space to the OS. Can it? |
|
Apr 23 |
comment |
Dropping indexes doesn't seem to release space to the OS. Can it? It's not #1. #2 is worth noting, because the filesystem is ext4 which apparently cannot report disk usage deterministically. #3 seems unlikely, there's nothing else really running on this box. I'm going to investigate #4. Thanks! |
|
Apr 23 |
asked | Dropping indexes doesn't seem to release space to the OS. Can it? |
|
Mar 6 |
comment |
hstore for versioning fields in postgresql I had some bad luck with tablelog a few months ago. It doesn't seem to be well-documented or well-maintained. But just today I discovered PG comes with a module called timetravel that does something similar. |
|
Mar 5 |
comment |
Database suggestion for a social network/ knowledge base community? What I'm saying has to do with age and wide use, not with the design of the storage engine. |
|
Mar 1 |
awarded | Commentator |
|
Mar 1 |
answered | Trouble setting up Postgres for the first time |
|
Feb 29 |
comment |
PostgreSQL partitioning query performance inexplicably bad Thanks, I hadn't seen this. Yes, I'm on 9.0. This is definitely another good reason to upgrade to 9.1. |
|
Feb 29 |
accepted | PostgreSQL partitioning query performance inexplicably bad |
|
Feb 29 |
comment |
Separate Address Table, Latitude, Longitude I don't, but I know a right answer when I see one. ;) |
|
Feb 29 |
revised |
Separate Address Table, Latitude, Longitude improved formatting somewhat |
|
Feb 29 |
awarded | Teacher |
|
Feb 29 |
answered | Separate Address Table, Latitude, Longitude |
|
Feb 29 |
suggested | suggested edit on Separate Address Table, Latitude, Longitude |
|
Feb 29 |
comment |
Why can't relational databases meet the scales of Big Data? To qualify as full disclosure, you should probably also mention that your co-founder and CTO Michael Stonebraker was also co-architect of all your examples. And that VoltDB's SQL support is an embarrassingly small subset. |
|
Feb 29 |
comment |
How can I prevent gaps in a MySQL table AUTO_INCREMENT field? I strongly recommend you redesign your system to eliminate this additional, hidden responsibility from your user IDs and find a less clever, less brittle approach to synchronizing your systems. If you don't, I predict this will be only the first of many difficulties you'll face. |
