Y
HN Search
Hacker News Search
new
|
comments
|
top
|
jobs
rdunklau
searching PlanetScale…
1.
▲
2.
▲
3.
▲
4.
▲
5.
▲
6.
▲
3 ms
·
1.
▲
by
rdunklau
15y ago
Thank you for this report. I'll try to make it work on Ubuntu, expect the documentation to be updated in the next few days. PS: if you're the 'leopard' who requested a redmine account, it should be activated now, feel free to report it ther
2.
▲
by
rdunklau
15y ago
It depends on what your use case is. If you have well targeted queries (eg, with filters on "From" or "Subject" headers, and only query the message headers (not the payload) you can have a pretty good performance. What is your use case, exa
3.
▲
by
rdunklau
15y ago
I totally agree with you regarding PL/Python. I may try to ask upstream what they think about it.
4.
▲
by
rdunklau
15y ago
Sorry to beat you at it ;) We currently have some very rudimentary python to postgres type conversion, but this area still need a lot of improvements. You should release your code, I'm sure you have a wide range of ideas worth merging into
5.
▲
by
rdunklau
15y ago
Thank you for your interest! The postgresql plan is parsed, and passed as a list of "quals", objects representing simple filters. As an implementer, you don't HAVE to enforce those, since postgresql will recheck them for you anyway, but the
6.
▲
by
rdunklau
15y ago
Multicorn developer here, I'll be glad to answer any question.
7.
▲
by
rdunklau
15y ago
On the top of my head, another list of features worth looking at: - ARRAY support: makes your life easier, especially the array_agg aggregation function - HSTORE extension: use postgresql like a key/value store - SQL/MED implementation, for