511 reputation
311
bio website storytotell.org
location Socorro, NM
age 33
visits member for 2 years, 10 months
seen Nov 7 at 23:16

Nov
7
revised PostgreSQL Complete Database Backup
incorporating advice from a comment
Nov
7
awarded  Nice Answer
Sep
30
awarded  Explainer
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. ;)