5 ms·
You should probably read the post first, my dude. > Half of the time if you need to sort, you're doing something wrong and the data should already be sorted O
by japhib 4y ago
You should probably read the post first, my dude.
> Half of the time if you need to sort, you're doing something wrong and the data should already be sorted
OP is literally talking about the C implementation of Postgres. He probably needs to sort.
- sophacles 4y agoWhy can't postgres just get it's data in a pre-sorted way tho?
- jstimpfle 4y agoOnly the least technical among many possible reasons: it cannot know in advance the row ordering that is requested by the user.
- sicp-enjoyer 4y agoStable sort and binary search is the bread and butter of pretty much every database operation. When you bulk insert into indexed columns, it sorts the inserted data and merges that with the existing index. If you do joins on non-indexed columns it often sorts the intermediate results.
- jstimpfle 4y agoI hadn't known that we're on such close terms, my friend. Seems like this case is falling in the other half then.
- jyounker 4y agoHe knows the information about the author because he read the article.
- japhib 4y agoIf “my dude” offended you, I’m sorry. I was just trying to make it lighthearted. I get frustrated at the number of comments on HN articles that are mostly irrelevant if you’ve actually read the article.