192 reputation
1216
bio website
location San Francisco, CA
age
visits member for 5 years, 6 months
seen Sep 30 at 1:27

Sep
2
awarded  Famous Question
Jul
2
awarded  Curious
Jun
14
awarded  Nice Question
Mar
20
awarded  Popular Question
Nov
21
awarded  Popular Question
Nov
20
awarded  Notable Question
Mar
21
awarded  Popular Question
Jan
27
accepted Too much memory being swapped out, while cache uses it all on Centos 5.4
Jan
27
comment Too much memory being swapped out, while cache uses it all on Centos 5.4
I hadn't realized it would use the tmpfs tablespace for external merge sorts (assumed it would use pg_default tablespace), but that makes a lot of sense.
Jan
26
comment Too much memory being swapped out, while cache uses it all on Centos 5.4
Oh wait a minute.. If tmpfs is swapped out, it shouldn't still show up in the cache right? That part doesn't make sense to me still.
Jan
26
comment Too much memory being swapped out, while cache uses it all on Centos 5.4
Oh, that explains it, thanks! I had a nagging feeling that was it. However, the memory amount used didn't add up in my head, so I discarded that theory. I guess I'll have to figure out why it's taking so much memory for the sort when I set PostgreSQL work_mem to stay within limits of RAM - tmpfs..
Jan
26
asked Too much memory being swapped out, while cache uses it all on Centos 5.4
Jan
15
accepted Bash Parallelization of CPU-intensive processes
Jan
14
comment Bash Parallelization of CPU-intensive processes
Well, I don't actually care about maintaining order in the file in this case. However, I'm sure it's important for other tasks. If the program which divides the stdin also recombines the stdout, as I hope for, it can do a line-by-line recombine, which would maintain order just fine I think.
Jan
14
revised Bash Parallelization of CPU-intensive processes
added 63 characters in body; edited tags
Jan
14
revised Bash Parallelization of CPU-intensive processes
added 7 characters in body
Jan
14
revised Bash Parallelization of CPU-intensive processes
added 342 characters in body; edited title
Jan
14
asked Bash Parallelization of CPU-intensive processes
Jan
5
answered Why don't EC2 ubuntu images have swap?
Dec
24
awarded  Popular Question