6 reputation
1
bio website
location Heidelberg, Germany
age
visits member for 1 year, 8 months
seen Sep 6 '13 at 11:31

Mar
12
comment slow queries - set weight to token type in tsquery - postgresql
Thanks, I'll keep looking. But honestly being Postgres so widely used, I don't really quite get why they make this sort of thing this difficult
Mar
7
comment slow queries - set weight to token type in tsquery - postgresql
Thanks Craig, could you pass over the link to those if you still have them at hand?
Mar
7
comment postgres GROUP BY and ORDER BY problem
Thank you. I will try that and see how it goes ;)
Mar
7
comment postgres GROUP BY and ORDER BY problem
On the other hand I want to get the first XD cids per query name. If I use LIMIT X it returns the first X results of the entire query table, not the first X per name (row) of the query table as I want
Mar
7
comment postgres GROUP BY and ORDER BY problem
There's another table to which this one is linked and that it's irrelevant to this query. What I want is, on one hand for those results whose rank is the same, eg above 5283035 and 5311211, get 5311211 as top result because that cid has more hits than 5283035, so I sort of wanna take into account the number of hits/cid in the rank, like final_rank = 1+ts_rank(cid)/no. of hits(cid).
Mar
7
comment postgres GROUP BY and ORDER BY problem
There's another table to which this one is linked and that it's irrelevant to this query. The output I want is:
Mar
1
awarded  Student
Feb
28
asked postgres GROUP BY and ORDER BY problem
Feb
27
comment slow queries - set weight to token type in tsquery - postgresql
And about the NoSQL, I'm totally novice with those and to be honest I don't know which approach would be better. We need to have very fast reads. That's the main thing. We had key/value approach in mind, with the chemical cids as keys associated to many values. But, can be have an array of values associated to a key? I've seen something about JSON strings as values. That could work. On the other hand we don't wanna make it too complicated. We will have many many values to associate with the cids. Which approach/dbh would you recommend? Thanks!
Feb
27
comment slow queries - set weight to token type in tsquery - postgresql
How can I implement my own parser? c/c++? I've been looking for tutorials on how to set up my own configuration but haven't found many examples or guidelines .. For instance where (in my pc) can I found the default files of the tfs default configuration? I edited the english.stop file but didn't make any difference
Feb
27
comment slow queries - set weight to token type in tsquery - postgresql
Thank you for your reply.
Feb
26
asked slow queries - set weight to token type in tsquery - postgresql