does.
@Peter E.: Do you still have observer status at the ISO committee?
2016-07-06 13:19 GMT+02:00 Stefan Keller <sfkel...@gmail.com>:
> Thomas
>
> 2016-07-04 6:44 GMT+02:00 Thomas Munro <thomas.mu...@enterprisedb.com>:
>> ... But ISO/IEC CD 9075-15
>> (Multi-Dimen
19075-5 (Row Pattern Recognition) has also reached stage
> 30.60. Does anyone know what that one is about? Maybe something like
Peter surely would know: https://www.jacobs-university.de/directory/pbaumann
:Stefan
2016-07-04 6:44 GMT+02:00 Thomas Munro <thomas.mu...@enterprisedb.com>:
&g
Hi,
FYI: I'd just like to point you to following two forthcoming standard
parts from "ISO/IEC JTS 1/SC 32" comittee: one on JSON, and one on
"Multi-Dimensional Arrays" (SQL/MDA).
They define there some things different as already in PG. See also
Peter Baumann's slides [1] and e.g. [2]
:Stefan
this splitting resources to implement types like
geometry twice.
:Stefan
2015-10-12 11:24 GMT+02:00 Alexander Korotkov <a.korot...@postgrespro.ru>:
> Hi, Stefan!
>
> On Sun, Oct 11, 2015 at 10:00 PM, Stefan Keller <sfkel...@gmail.com> wrote:
>>
>> Pls.
Hi Emre
Pls. don't misunderstand my questions: They are directed to get an
even more useful spatial data handling of PostgreSQL. I'm working with
PostGIS since years and are interested in any work regarding spatial
types...
Can anyone report use cases or applications of these built-in geometric
Hi,
2015-05-05 2:51 GMT+02:00 Andreas Karlsson andr...@proxel.se:
From my point of view as a reviewer this patch set is very close to being
committable.
I'd like to thank already now to all committers and reviewers and hope
BRIN makes it into PG 9.5.
As a database instructor, conference
Hi Alvaro
2014-08-15 20:16 GMT+02:00 you answered:
(...)
Yeah, it's just a matter of adding an opclass for it -- pretty simple
(...)
Right now there are opclasses for the following types:
(...)
Of course, the real interesting part is adding a completely different
opclass, such as one that
Hi Hadi
Do you think that cstore_fd*w* is also welll suited for storing and
retrieving linked data (RDF)?
-S.
2014-04-03 18:43 GMT+02:00 Hadi Moshayedi h...@citusdata.com:
Dear Hackers,
We at Citus Data have been developing a columnar store extension for
PostgreSQL. Today we are excited
.
I have to dig into my tests in order to give you the EXPLAIN ANALYZE.
Yours, Stefan
2013/5/26 Tom Lane t...@sss.pgh.pa.us:
Stefan Keller sfkel...@gmail.com writes:
Given following schema:
1. TABLE a and TABLE b, each with INDEX on attribute geom.
2. A VIEW with union:
CREATE VIEW myview
william.k...@quentustech.com
On 05/25/2013 05:35 PM, Stefan Keller wrote:
Hi
I've encountered a fundamental problem which - to me - can only be
solved with an (future/possible) real index on views in PostgreSQL
(like the exist already in MS SQL Server and Ora):
Given following schema:
1
Hi
I've encountered a fundamental problem which - to me - can only be
solved with an (future/possible) real index on views in PostgreSQL
(like the exist already in MS SQL Server and Ora):
Given following schema:
1. TABLE a and TABLE b, each with INDEX on attribute geom.
2. A VIEW with union:
Hi Jeff
2013/1/18 Jeff Davis pg...@j-davis.com:
On Thu, 2013-01-17 at 21:03 +0100, Stefan Keller wrote:
Hi Jeff
I'm perhaps really late in this discussion but I just was made aware
of that via the tweet from Josh Berkus about PostgreSQL 9.3: Current
Feature Status
What is the reason
Hi Jeff
2012/4/19 Jeff Davis pg...@j-davis.com:
On Wed, 2012-04-18 at 01:21 -0400, Tom Lane wrote:
(...)
This is just handwaving of course. I think some digging in the
spatial-join literature would likely find ideas better than any of
these.
I will look in some more detail. The merge-like
Hi Robert
2012/3/11 Robert Haas robertmh...@gmail.com:
On Sat, Mar 10, 2012 at 4:35 PM, Stefan Keller sfkel...@gmail.com wrote:
The main conclusion was:
* Do a tar cf /dev/zero $PG_DATA/base either shortly before or
shortly after the database is created
* Do a seq scan SELECT * FROM
Cédric and Robert
Thanks, Cédric, for the reminder.
Would be nice to sort out the features of the two Postgres extentions
pgfincore (https://github.com/klando/pgfincore ) and pg_prewarm: what
do they have in common, what is complementary?
I would be happy to test both. But when reading the
Hi Robert,
Just recently I asked on postgres-performance PG as in-memory db? How
to warm up and re-populate buffers? How to read in all tuples into
memory?
Somehow open was, what's the best practice of configuration and
relationship between disk/OS cache vs. Portgres cache
The main conclusion
Hi Andrew
Nice work!
Just for completeness: Did you also think of including geometry types
in JSON output functions in later releases? There's a nice extension
of JSON called GeoJSON for a starting point.
Yours, Stefan
2012/2/3 Andrew Dunstan and...@dunslane.net:
On 02/02/2012 12:20 PM,
Hi
I'm proposing OpenStreetMap which is of variable size up to 250 GB
XML Data for whole world.
It's downloadable from CloudMade.com or Geofabrik.de and can be
imported into PostgreSQL using osm2pgsql.
It's a key/value schema literally of the real world. I'm using hstore
option of osm2pgsql and
Tom,
There seems to exist some opportunities now with GIST which relate to
geometry/geography types (but not only...):
1. Index-only scans on geometry columns with SP-GIST (being able to do
a SELECT id FROM my_table WHERE mygeom...;).
2. Index clustering incuding NULL values (i.e. being able to do
-td4935560.html[2]
http://www.postgresql.org/docs/9.1/interactive/file-fdw.html
2011/11/28 Stefan Keller sfkel...@gmail.com:
Hi Robert
2011/11/28 Robert Haas robertmh...@gmail.com wrote:
You might want to try this question on pgsql-general or pgsql-novice
rather than here; this is a list
Hi Robert
2011/11/28 Robert Haas robertmh...@gmail.com wrote:
You might want to try this question on pgsql-general or pgsql-novice
rather than here; this is a list for discussing the development of
PostgreSQL itself.
Thanks for the hint.
It was actually my advice to post this question here.
I'm on the way to open a ticket for hash indexes (adding WAL support) anyway:
May I open a ticket for adding GiST support to unlogged tables ?
Stefan
2011/9/14 Stefan Keller sfkel...@gmail.com:
Robert,
2011/9/6 Alexander Korotkov aekorot...@gmail.com:
GiST use serial numbers of operations
Robert,
2011/9/6 Alexander Korotkov aekorot...@gmail.com:
GiST use serial numbers of operations for concurrency. In current
implementation xlog record ids are used in capacity of that numbers. In
unlogged table no xlog records are produced. So, we haven't serial numbers
of operations. AFAIK,
Hi,
Unlogged tables seems to me to follow a similar goal. Obviously GiST
indexes are not supported there.
Do you know the technical reason?
Do you see some synergy in your work on fast GiST index building and
unlogged tables?
Yours, Stefan
2011/9/6 Alexander Korotkov aekorot...@gmail.com:
Hi,
We did a benchmark comparing a Key-Value-Pairs stored as EAV db schema
versus hstore. The results are promising in favor of hstore but there are some
question which remain.
1. Obviously the '@' has to be used in order to let use the GiST index.
Why is the '-' operator not supported by GiST
Ok.
But again: There is a library mentioned and documented in the famous
PostgreSQL book from Douglas Douglas called pgcurl (
http://gborg.postgresql.org/project/pgcurl/ ). Where's this gone?
Yours, S.
2009/5/20 Robert Haas robertmh...@gmail.com
On Wed, May 20, 2009 at 6:34 AM, Stefan Keller
regarding index usage in
tsearch2 and regex. Should I place these here (or else where?)?
Regards, S.
2009/5/19 Tom Lane t...@sss.pgh.pa.us
Robert Haas robertmh...@gmail.com writes:
On Mon, May 18, 2009 at 4:03 PM, Stefan Keller sfkel...@gmail.com
wrote:
I'd expect functions like get_text
How to insert a text file into a field in PostgreSQL?
I'd like to insert a row with fields from a local or remote text file.
I'd expect functions like get_text() or get_url() in order to do the
following:
INSERT INTO collection(id, path, content) VALUES(1, '/tmp/mytext,
get_text('/tmp/mytext));
28 matches
Mail list logo