[18:02] <soultcer> Good idea, maybe even do both
[19:30] <chronomex> nah, actually there's little likelihood of much benefit
[19:30] <chronomex> clustering is only effective if you return many results at a time, so you cluster to reduce disk seeks while constructing large result sets
[19:31] <soultcer> Oh
[19:31] <soultcer> I didn't research how postgres actually stores the data. I know about toast and how the indexes work, but not the actualy data stuff or any of the MVCC stuff
[19:33] <chronomex> yeah
[19:34] <chronomex> I'm looking into clustering my db, since I serve out 30-40 results at once on many queries
[19:34] <soultcer> On what index are you clustering them? Country? City? Last name?
[19:35] <chronomex> city and name, I think.
[19:35] <chronomex> I have to get my city refs sorted out first though