481 reputation
39
bio website storytotell.org
location Socorro, NM
age 33
visits member for 2 years, 8 months
seen Apr 29 at 21:29

Mar
10
awarded  Nice Question
Jan
5
awarded  Yearling
Aug
7
awarded  Notable Question
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