network profile
| bio | website | |
|---|---|---|
| location | Paris, France | |
| age | 28 | |
| visits | member for | 1 year, 8 months |
| seen | May 6 at 13:16 | |
| stats | profile views | 8 |
C++, python, django, PostgreSQL
Machine Learning, Statistics, NLP
|
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? |
