network profile
| bio | website | depesz.com |
|---|---|---|
| location | ||
| age | 36 | |
| visits | member for | 2 years |
| seen | May 2 at 22:08 | |
| stats | profile views | 54 |
|
Mar 25 |
comment |
Postgres full text search with multiple columns, why concat in index and not at runtime? Jack :) I'll bite - subscribed. |
|
Mar 23 |
comment |
Working of window functions and idea window size for window function Window functions are not (generally) for limiting recordsets. they are to provide additional information based on (sub)set of the data. So, while it might be possible to use window function + wheres to emulate "limit" functionality - it's far from optimal. |
|
Mar 23 |
awarded | Editor |
|
Mar 23 |
comment |
Postgres full text search with multiple columns, why concat in index and not at runtime? @Jack: not sure I will - I found stackexchange sites less and less usable. I generally try to get RSS, but on stackexchange sites rss is pretty much useless - so much pollution from edition of old questions. |
|
Mar 23 |
revised |
Postgres full text search with multiple columns, why concat in index and not at runtime? added 494 characters in body |
|
Mar 23 |
answered | Postgres full text search with multiple columns, why concat in index and not at runtime? |
|
Dec 18 |
answered | Single node parallelism with PL/Proxy? |
|
May 4 |
awarded | Teacher |
|
May 4 |
answered | master to multi-slave replication |
|
May 3 |
comment |
Query PostgreSQL 9.0 table on foreign key value? Well, neither do I, since I don't know your data distribution and statistics. |
|
Apr 28 |
answered | Query PostgreSQL 9.0 table on foreign key value? |
|
Apr 28 |
awarded | Supporter |
