141 reputation
6
bio website
location Paris, France
age 30
visits member for 3 years, 2 months
seen Aug 31 at 17:31

C++, python, django, PostgreSQL

Machine Learning, Statistics, NLP


Sep
24
awarded  Autobiographer
Aug
21
awarded  Popular Question
Apr
15
comment Concurrency with Select-conditional Insert/Update/Delete - PostgreSQL
This article uses EXCLUDE constraints and the "2D-ness" of box type for a similar problem, in a convoluted but interesting way. I'll give more thoughts into that, and maybe keep my SERIALIZABLE solution for now and wait for 9.2. Anyway, thanks again!
Apr
15
comment Concurrency with Select-conditional Insert/Update/Delete - PostgreSQL
Well then, first of all thanks for your work on PostgreSQL! I didn't know the EXCLUSION constraints and hadn't thought of enforcing the constraint at database level. It's interesting. However, I haven't dug into temporal data type, but it seems that I'd have a problem in specifying a constraint on both the interval and the variable_id, wouldn't I? I don't want all intervals to be distinct, but rather all intervals of a variable to be distinct. (to be cont.)
Apr
15
asked Concurrency with Select-conditional Insert/Update/Delete - PostgreSQL
Sep
14
awarded  Supporter
Sep
14
awarded  Scholar
Sep
14
accepted What does “GIN doesn't support full index scans” mean?
Sep
13
awarded  Teacher
Sep
13
answered What does “GIN doesn't support full index scans” mean?
Sep
13
comment What does “GIN doesn't support full index scans” mean?
Well I've got 500+ different words in my list, so a regex, or several regex, would be clumsy, I guess. I think I'm going to stick with the full-text-search capabilities of pgsql, it seems quite powerful and we're probably going to use it for other stuffs anyway. Thanks for your answers. Btw, I think I have the answer to my question, I'll write it later.
Sep
12
awarded  Student
Sep
12
comment What does “GIN doesn't support full index scans” mean?
Thanks for your answer. However, how would I "scan" the input texts? Wouldn't the best be to use the pgsql full-text-search feature (tsearch)? And it would feel more natural to use the index solution that's coming with it. Otherwise, I guess I'd have to create a TRIGGER that would parse all incoming texts and compare them to my list of words, which I'd probably do less well than tsearch. Besides, would there be a performance impact (many-to-many vs. gin index)? And finally, I'd still like to know what "full index scan" mean, as I'm considering using this for something else. Thks again
Sep
11
asked What does “GIN doesn't support full index scans” mean?