postgres-xc-announce — Release and other announce

[Postgres-xc-announce] Postgres-XC minor releases

[Koichi S. <koi...@gm...>]

Now Postgres-XC 1.0.4 and Postgres-XC 1.1.1 are available.   They come
with various fixes/improvements as seen in each release note.

For 1.1.1,
Release note is available at
http://postgres-xc.sourceforge.net/docs/1_1_1/release-xc-1-1-1.html
Source tarball is available at
https://sourceforge.net/projects/postgres-xc/files/Version_1.1/
Document is available at http://postgres-xc.sourceforge.net/docs/1_1_1/

For 1.0.4
Release note is available at
http://postgres-xc.sourceforge.net/docs/1_0_4/release-xc-1-0-4.html
Source tarball is available at
https://sourceforge.net/projects/postgres-xc/files/Version_1.0/
Document is available at http://postgres-xc.sourceforge.net/docs/1_0_4/

Enjoy;
---
Koichi Suzuki

Re: [Postgres-xc-announce] [Postgres-xc-general] Postgres-XC 1.2.1 is out

[Juned K. <jkh...@gm...>]

that's the good news.


On Thu, Apr 3, 2014 at 11:54 AM, Koichi Suzuki <koi...@gm...>wrote:

> Postgres-XC development group is pleased to announce that Postgres-XC
> 1.2.1 is out.
>
> This includes many important features from PostgreSQL 9.3 such as
> materialized views, LATERAL, event triggers and automatic updatable
> views, as well as improved distributed query optimizer.   It also
> comes with many fixes and improvement as found in the release note.
>
> Release note is available at
> http://postgres-xc.sourceforge.net/docs/1_2_beta/release-xc-1-2.html
> Source tarball is available at
> https://sourceforge.net/projects/postgres-xc/files/Version_1.2/
> Document is available at http://postgres-xc.sourceforge.net/docs/1_2_1/
>
> Enjoy.
> ---
> Koichi Suzuki
>
>
> ------------------------------------------------------------------------------
> _______________________________________________
> Postgres-xc-general mailing list
> Pos...@li...
> https://lists.sourceforge.net/lists/listinfo/postgres-xc-general
>



-- 
Thanks,
Juned Khan
iNextrix Technologies Pvt Ltd.
www.inextrix.com

[Postgres-xc-announce] Postgres-XC 1.2.1 is out

[Koichi S. <koi...@gm...>]

Postgres-XC development group is pleased to announce that Postgres-XC
1.2.1 is out.

This includes many important features from PostgreSQL 9.3 such as
materialized views, LATERAL, event triggers and automatic updatable
views, as well as improved distributed query optimizer.   It also
comes with many fixes and improvement as found in the release note.

Release note is available at
http://postgres-xc.sourceforge.net/docs/1_2_beta/release-xc-1-2.html
Source tarball is available at
https://sourceforge.net/projects/postgres-xc/files/Version_1.2/
Document is available at http://postgres-xc.sourceforge.net/docs/1_2_1/

Enjoy.
---
Koichi Suzuki

[Postgres-xc-announce] Postgres-XC 1.2 beta is out

[Koichi S. <koi...@gm...>]

Postgres-XC 1.1 beta is now out.   Thank you very much for waiting long.

This release includes many major new features from PostgreSQL 9.3.
Also this release changes its release schedule from June - August to
January - February to make it easier to catch up PostgreSQL
development.

Source tarball is available at
https://sourceforge.net/projects/postgres-xc/files/Version_1.2/

Document page is at http://postgres-xc.sourceforge.net/docs/1_2_beta/

Release note is at
http://postgres-xc.sourceforge.net/docs/1_2_beta/release-xc-1-2.html

This patch enables all the major PostgreSQL new features as follows:

1) Materialized view, by Ashutosh Bapat
2) Event trigger, by Koichi Suzuki
3) Automatic updatable views, by Abbas But
4) LATERAL, by Ashutosh Bapat

Due to many internal API changes of PosgreSQL planner, corresponding
Postgres-XC planner needed many changes too.

This effort inlcudes the following by Abbas But:

1) Fix false report of partition column updation.
2) Fix for alias problem in returning list of INSERT statements.
3) Fix a problem in RETURNING support when all the items of the list
are not shippable.
4) Change the way UPDATEs are handeled, by updating all the columns of
the result relation instead of updating only the columns that were in
the target list.
5) Fix for all problems emerging because the query deparsing system
now generates unique rtable names by appending digits Initdb message
improvement was done by Masataka Saito.

Postgres-XC development group appreciates for all the inputs and helps
from PGXC'ers.

Enjoy.
----------
Koichi Suzuki

---
Koichi Suzuki

[Postgres-xc-announce] New Project page is out

[Koichi S. <koi...@gm...>]

Hello!

Postgres-XC project page was renewed.   New page is now redirected to
sourceforge MediaWiki, which is much more flexible for frequent updates.

Enjoy;
---
Koichi Suzuki

[Postgres-xc-announce] Fwd: [Postgres-xc-general] Postgres-XC 1.1 RPMs

[鈴木 幸市 <ko...@in...>]

Good news from Mason!
---
Koichi Suzuki

Begin forwarded message:

差出人: Mason Sharp <ma...@st...<mailto:ma...@st...>>
件名: [Postgres-xc-general] Postgres-XC 1.1 RPMs
日時: 2013年9月5日 10:16:29 JST
宛先: postgres-xc-general <pos...@li...<mailto:pos...@li...>>

StormDB has released RPMs for Postgres-XC version 1.1 here:

http://yum.stormdb.com/repos/Postgres-XC/1.1.0/

Enjoy!

--
Mason Sharp

StormDB - http://www.stormdb.com<http://www.stormdb.com/>
The Database Cloud
Postgres-XC Support and Services
------------------------------------------------------------------------------
Learn the latest--Visual Studio 2012, SharePoint 2013, SQL 2012, more!
Discover the easy way to master current and previous Microsoft technologies
and advance your career. Get an incredible 1,500+ hours of step-by-step
tutorial videos with LearnDevNow. Subscribe today and save!
http://pubads.g.doubleclick.net/gampad/clk?id=58041391&iu=/4140/ostg.clktrk_______________________________________________
Postgres-xc-general mailing list
Pos...@li...
https://lists.sourceforge.net/lists/listinfo/postgres-xc-general

Re: [Postgres-xc-announce] [Postgres-xc-core] Postgres-XC 1.1 is out

[Ahsan H. <ahs...@en...>]

Congratulation. This is a major achievement.




On Thu, Aug 22, 2013 at 10:13 AM, Koichi Suzuki <koi...@gm...>wrote:

> Please copy this announcement to you channel.
>
> Thank you;
> ---
> Koichi Suzuki
>
> ---
> Koichi Suzuki
>
>
> 2013/8/22 Koichi Suzuki <koi...@gm...>
>
>> Postgres-XC development group is proud to announce the release of
>> Postgres-XC version 1.1.   This is the second major release and comes with
>> many useful features.
>>
>> Source tarball will be available at
>> http://sourceforge.net/projects/postgres-xc/files/Version_1.1/pgxc-v1.1.tar.gz/downloadwhich comes with HTML documentation and man pages.
>>
>>
>> Please visit the project page http://postgres-xc.sourceforge.net and
>> development page https://sourceforge.net/projects/postgres-xc/ for more
>> materials.
>>
>> New features of Postgres-XC 1.1 include:
>>
>> * Node addition and removal while Postgres-XC cluster is in operation.
>> * Added --restoremode option to pg_ctl to import catalog information from
>> other coordinator/datanode, used when adding new node.
>> * Added --include-nodes option to pg_dump and pg_dumpall to export node
>> information as well. Mainly for node addition.
>> * pgxc_lock_for_backup() function to disable DDLs while new node is going
>> to be added and catalog is exported to the new node.
>> * Row TRIGGER support.
>> * RETURNING support.
>> * pgxc_ctl tool for Postgres-XC cluster configuration and operation
>> (contrib module).
>> * Backup GTM restart point with CREATE BARRIER statement.
>> * Merged with PostgreSQL 9.2.4.
>> * ALTER TABLE statement to redistribute tables
>>
>> Also we have number of improvements in the planner for better performance
>> as:
>>
>> * Push down sorting operation to the datanodes by using ORDER BY clause
>> in queries to sent to the datanodes.
>> * Push down LIMIT clause to datanodes.
>> * Pushdown outer joins to datanodes.
>> * Improve fast query shipping to ship queries containing subqueries.
>> * Push GROUP BY clause to the datanodes when there is ORDER BY, LIMIT and
>> other clauses in the query.
>>
>> It also comes with number of another improvements and fixes.
>>
>>
>> The group appreciate all the members who provided valuable codes and
>> fruitful discussions.
>>
>> Best Regards;
>> ---
>> Koichi Suzuki
>>
>
>
>
> ------------------------------------------------------------------------------
> Introducing Performance Central, a new site from SourceForge and
> AppDynamics. Performance Central is your source for news, insights,
> analysis and resources for efficient Application Performance Management.
> Visit us today!
> http://pubads.g.doubleclick.net/gampad/clk?id=48897511&iu=/4140/ostg.clktrk
> _______________________________________________
> Postgres-xc-core mailing list
> Pos...@li...
> https://lists.sourceforge.net/lists/listinfo/postgres-xc-core
>
>


-- 
Ahsan Hadi
Snr Director Product Development
EnterpriseDB Corporation
The Enterprise Postgres Company

Phone: +92-51-8358874
Mobile: +92-333-5162114

Website: www.enterprisedb.com
EnterpriseDB Blog: http://blogs.enterprisedb.com/
Follow us on Twitter: http://www.twitter.com/enterprisedb

This e-mail message (and any attachment) is intended for the use of the
individual or entity to whom it is addressed. This message contains
information from EnterpriseDB Corporation that may be privileged,
confidential, or exempt from disclosure under applicable law. If you are
not the intended recipient or authorized to receive this for the intended
recipient, any use, dissemination, distribution, retention, archiving, or
copying of this communication is strictly prohibited. If you have received
this e-mail in error, please notify the sender immediately by reply e-mail
and delete this message.

Re: [Postgres-xc-announce] Postgres-XC 1.1 is out

[Koichi S. <koi...@gm...>]

Please copy this announcement to you channel.

Thank you;
---
Koichi Suzuki

---
Koichi Suzuki


2013/8/22 Koichi Suzuki <koi...@gm...>

> Postgres-XC development group is proud to announce the release of
> Postgres-XC version 1.1.   This is the second major release and comes with
> many useful features.
>
> Source tarball will be available at
> http://sourceforge.net/projects/postgres-xc/files/Version_1.1/pgxc-v1.1.tar.gz/downloadwhich comes with HTML documentation and man pages.
>
>
> Please visit the project page http://postgres-xc.sourceforge.net and
> development page https://sourceforge.net/projects/postgres-xc/ for more
> materials.
>
> New features of Postgres-XC 1.1 include:
>
> * Node addition and removal while Postgres-XC cluster is in operation.
> * Added --restoremode option to pg_ctl to import catalog information from
> other coordinator/datanode, used when adding new node.
> * Added --include-nodes option to pg_dump and pg_dumpall to export node
> information as well. Mainly for node addition.
> * pgxc_lock_for_backup() function to disable DDLs while new node is going
> to be added and catalog is exported to the new node.
> * Row TRIGGER support.
> * RETURNING support.
> * pgxc_ctl tool for Postgres-XC cluster configuration and operation
> (contrib module).
> * Backup GTM restart point with CREATE BARRIER statement.
> * Merged with PostgreSQL 9.2.4.
> * ALTER TABLE statement to redistribute tables
>
> Also we have number of improvements in the planner for better performance
> as:
>
> * Push down sorting operation to the datanodes by using ORDER BY clause in
> queries to sent to the datanodes.
> * Push down LIMIT clause to datanodes.
> * Pushdown outer joins to datanodes.
> * Improve fast query shipping to ship queries containing subqueries.
> * Push GROUP BY clause to the datanodes when there is ORDER BY, LIMIT and
> other clauses in the query.
>
> It also comes with number of another improvements and fixes.
>
>
> The group appreciate all the members who provided valuable codes and
> fruitful discussions.
>
> Best Regards;
> ---
> Koichi Suzuki
>

[Postgres-xc-announce] Postgres-XC 1.1 is out

[Koichi S. <koi...@gm...>]

Postgres-XC development group is proud to announce the release of
Postgres-XC version 1.1.   This is the second major release and comes with
many useful features.

Source tarball will be available at
http://sourceforge.net/projects/postgres-xc/files/Version_1.1/pgxc-v1.1.tar.gz/downloadwhich
comes with HTML documentation and man pages.


Please visit the project page http://postgres-xc.sourceforge.net and
development page https://sourceforge.net/projects/postgres-xc/ for more
materials.

New features of Postgres-XC 1.1 include:

* Node addition and removal while Postgres-XC cluster is in operation.
* Added --restoremode option to pg_ctl to import catalog information from
other coordinator/datanode, used when adding new node.
* Added --include-nodes option to pg_dump and pg_dumpall to export node
information as well. Mainly for node addition.
* pgxc_lock_for_backup() function to disable DDLs while new node is going
to be added and catalog is exported to the new node.
* Row TRIGGER support.
* RETURNING support.
* pgxc_ctl tool for Postgres-XC cluster configuration and operation
(contrib module).
* Backup GTM restart point with CREATE BARRIER statement.
* Merged with PostgreSQL 9.2.4.
* ALTER TABLE statement to redistribute tables

Also we have number of improvements in the planner for better performance
as:

* Push down sorting operation to the datanodes by using ORDER BY clause in
queries to sent to the datanodes.
* Push down LIMIT clause to datanodes.
* Pushdown outer joins to datanodes.
* Improve fast query shipping to ship queries containing subqueries.
* Push GROUP BY clause to the datanodes when there is ORDER BY, LIMIT and
other clauses in the query.

It also comes with number of another improvements and fixes.


The group appreciate all the members who provided valuable codes and
fruitful discussions.

Best Regards;
---
Koichi Suzuki

[Postgres-xc-announce] Bad fraud under my name

[Koichi S. <koi...@gm...>]

Hello;

My e-mail account was hacked this morning and bad fraud message was sent to
some of my e-mail recipients.   It's asking your help to me.   Please
ignore it.

I regained control over my e-mail account and will change the account for
security.   Please allow me a couple of days for this.

Thank you very much;
----------
Koichi Suzuki

[Postgres-xc-announce] Postgres-XC 1.1 beta is out

[Koichi S. <koi...@gm...>]

Postgres-XC 1.1 beta is now out.   Thank you very much for waiting long.

Source tarball is available at
https://sourceforge.net/projects/postgres-xc/files/Version_1.1/

Document hage is at http://postgres-xc.sourceforge.net/docs/1_1_beta/

Release note is at
http://postgres-xc.sourceforge.net/docs/1_1_beta/release-xc-1-1.html

Enjoy.
----------
Koichi Suzuki

[Postgres-xc-announce] Postgres-XC 1.0.3 is out

[Koichi S. <koi...@gm...>]

Postgres-XC development group release postgres-xc 1.0.3 with some
fixes/improvement as well as upgrade the base code to PostgreSQL
9.1.9.

You will find resources at:
http://postgres-xc.sourceforge.net/
http://postgres-xc.sourceforge.net/docs/
https://sourceforge.net/projects/postgres-xc/files/Version_1.0/

Enjoy.

Upgrading base PostgreSQL version to 9.2 will be included in the next
major release.

----
Postgres-XC is a symmetric PostgreSQL cluster which provides both read
and write scalability using mixture of table sharding and replication.

Each Postgres-XC cluster node provides single database view, where
application can connect to any cluster node and run any transactions.
Result of transactions are visible from all the cluster nodes without
delay.
----------
Koichi Suzuki

Re: [Postgres-xc-announce] [Postgres-xc-general] Using Postgres-XC as a key-value store

[鈴木 幸市 <ko...@in...>]

Thanks Mason;

I will look into it and share with surrounding people.
---
Koichi Suzuki



On 2013/04/21, at 20:53, Mason Sharp <ma...@st...> wrote:

> Hi Leo,
> 
> The presentation can be found here:
> 
> http://www.slideshare.net/stormdb_cloud_database/postgres-xc-askeyvaluestorevsmongodb
> 
> I had previously loaded up a version in March. I just updated it based on new measurements that I presented about a week ago in Philadelphia.  I would like to do more measurements and update it again when I can, in particular I would like to measure insert performance with differing amounts of concurrency.
> 
> Regards,
> 
> Mason
> 
> 
> 
> 
> On Sun, Apr 21, 2013 at 7:18 AM, Leo R. Lundgren <le...@fi...> wrote:
> Hi,
> 
> I'm curious if there's any material from this talk online yet? Really
> looks like an interesting one :)
> 
> Is there possibly also a recording of it to watch somewhere?
> 
> Regards, Leo
> 
> 
> On 14 Apr 2013, at 2:02, Mason Sharp wrote:
> 
> > Hi Ashutosh,
> >
> > I will post a link to the updated slide deck next week.
> >
> > Regards,
> >
> > Mason
> >
> >
> > On Fri, Apr 12, 2013 at 4:19 AM, Ashutosh Bapat <
> > ash...@en...> wrote:
> >
> >> This is interesting.
> >> I have been pondering over this. Can you please share some more
> >> details?
> >>
> >>
> >> On Thu, Apr 11, 2013 at 12:25 PM, Mason Sharp
> >> <mas...@gm...>wrote:
> >>
> >>> I will be presenting on Monday April 15th in Philadelphia at the
> >>> Philly
> >>> PUG about using Postgres-XC as a key-value store.
> >>>
> >>> I will discuss hstore, XML and JSON, and include performance
> >>> comparisons
> >>> to MongoDB.
> >>>
> >>> More information can be found here:
> >>>
> >>> http://www.phlpug.org/events/112128082/?eventId=112128082&action=detail
> >>>
> >>> Thanks,
> >>>
> >>> Mason Sharp
> >>>
> >>>
> >>> ------------------------------------------------------------------------------
> >>> Precog is a next-generation analytics platform capable of advanced
> >>> analytics on semi-structured data. The platform includes APIs for
> >>> building
> >>> apps and a phenomenal toolset for data science. Developers can use
> >>> our toolset for easy data analysis & visualization. Get a free
> >>> account!
> >>> http://www2.precog.com/precogplatform/slashdotnewsletter
> >>> _______________________________________________
> >>> postgres-xc-announce mailing list
> >>> pos...@li...
> >>> https://lists.sourceforge.net/lists/listinfo/postgres-xc-announce
> >>>
> >>>
> >>
> >>
> >> --
> >> Best Wishes,
> >> Ashutosh Bapat
> >> EntepriseDB Corporation
> >> The Enterprise Postgres Company
> >>
> > ------------------------------------------------------------------------------
> > Precog is a next-generation analytics platform capable of advanced
> > analytics on semi-structured data. The platform includes APIs for
> > building
> > apps and a phenomenal toolset for data science. Developers can use
> > our toolset for easy data analysis & visualization. Get a free
> > account!
> > http://www2.precog.com/precogplatform/slashdotnewsletter_______________________________________________
> > postgres-xc-announce mailing list
> > pos...@li...
> > https://lists.sourceforge.net/lists/listinfo/postgres-xc-announce
> 
> ------------------------------------------------------------------------------
> Precog is a next-generation analytics platform capable of advanced
> analytics on semi-structured data. The platform includes APIs for building
> apps and a phenomenal toolset for data science. Developers can use
> our toolset for easy data analysis & visualization. Get a free account!
> http://www2.precog.com/precogplatform/slashdotnewsletter
> _______________________________________________
> postgres-xc-announce mailing list
> pos...@li...
> https://lists.sourceforge.net/lists/listinfo/postgres-xc-announce
> 
> 
> 
> -- 
> Mason Sharp
> 
> StormDB - http://www.stormdb.com
> The Database Cloud
> Postgres-XC Support and Services
> ------------------------------------------------------------------------------
> Precog is a next-generation analytics platform capable of advanced
> analytics on semi-structured data. The platform includes APIs for building
> apps and a phenomenal toolset for data science. Developers can use
> our toolset for easy data analysis & visualization. Get a free account!
> http://www2.precog.com/precogplatform/slashdotnewsletter_______________________________________________
> Postgres-xc-general mailing list
> Pos...@li...
> https://lists.sourceforge.net/lists/listinfo/postgres-xc-general

Re: [Postgres-xc-announce] Using Postgres-XC as a key-value store

[Mason S. <ma...@st...>]

On Sun, Apr 21, 2013 at 8:22 AM, Leo R. Lundgren <le...@fi...>wrote:

> Hi,
>
> Very cool, thanks to both of you (Mason, Robert) for the links!
>
> Does anyone know if there's any recording of the talk though? I imagine
> that would be awesome.



Sorry, there is no recording. As the speaker I can assure you first hand
that the verbal part was uninspiring. :-)

Regards,

Mason




>


>
>
> On 21 Apr 2013, at 13:53, Mason Sharp wrote:
>
>  Hi Leo,
>>
>> The presentation can be found here:
>>
>> http://www.slideshare.net/**stormdb_cloud_database/**postgres-xc-**
>> askeyvaluestorevsmongodb<http://www.slideshare.net/stormdb_cloud_database/postgres-xc-askeyvaluestorevsmongodb>
>>
>> I had previously loaded up a version in March. I just updated it based on
>> new measurements that I presented about a week ago in Philadelphia.  I
>> would like to do more measurements and update it again when I can, in
>> particular I would like to measure insert performance with differing
>> amounts of concurrency.
>>
>> Regards,
>>
>> Mason
>>
>>
>>
>>
>> On Sun, Apr 21, 2013 at 7:18 AM, Leo R. Lundgren <le...@fi...
>> >wrote:
>>
>>  Hi,
>>>
>>> I'm curious if there's any material from this talk online yet? Really
>>> looks like an interesting one :)
>>>
>>> Is there possibly also a recording of it to watch somewhere?
>>>
>>> Regards, Leo
>>>
>>>
>>> On 14 Apr 2013, at 2:02, Mason Sharp wrote:
>>>
>>>  Hi Ashutosh,
>>>>
>>>> I will post a link to the updated slide deck next week.
>>>>
>>>> Regards,
>>>>
>>>> Mason
>>>>
>>>>
>>>> On Fri, Apr 12, 2013 at 4:19 AM, Ashutosh Bapat <
>>>> ashutosh.bapat@enterprisedb.**com <ash...@en...>>
>>>> wrote:
>>>>
>>>>  This is interesting.
>>>>> I have been pondering over this. Can you please share some more
>>>>> details?
>>>>>
>>>>>
>>>>> On Thu, Apr 11, 2013 at 12:25 PM, Mason Sharp
>>>>> <mas...@gm...>wrote:
>>>>>
>>>>>  I will be presenting on Monday April 15th in Philadelphia at the
>>>>>> Philly
>>>>>> PUG about using Postgres-XC as a key-value store.
>>>>>>
>>>>>> I will discuss hstore, XML and JSON, and include performance
>>>>>> comparisons
>>>>>> to MongoDB.
>>>>>>
>>>>>> More information can be found here:
>>>>>>
>>>>>>
>>>>>>  http://www.phlpug.org/events/**112128082/?eventId=112128082&**
>>> action=detail<http://www.phlpug.org/events/112128082/?eventId=112128082&action=detail>
>>>
>>>>
>>>>>> Thanks,
>>>>>>
>>>>>> Mason Sharp
>>>>>>
>>>>>>
>>>>>>
>>>>>>  ------------------------------**------------------------------**
>>> ------------------
>>>
>>>> Precog is a next-generation analytics platform capable of advanced
>>>>>> analytics on semi-structured data. The platform includes APIs for
>>>>>> building
>>>>>> apps and a phenomenal toolset for data science. Developers can use
>>>>>> our toolset for easy data analysis & visualization. Get a free
>>>>>> account!
>>>>>> http://www2.precog.com/**precogplatform/**slashdotnewsletter<http://www2.precog.com/precogplatform/slashdotnewsletter>
>>>>>> ______________________________**_________________
>>>>>> postgres-xc-announce mailing list
>>>>>> postgres-xc-announce@lists.**sourceforge.net<pos...@li...>
>>>>>> https://lists.sourceforge.net/**lists/listinfo/postgres-xc-**announce<https://lists.sourceforge.net/lists/listinfo/postgres-xc-announce>
>>>>>>
>>>>>>
>>>>>>
>>>>>
>>>>> --
>>>>> Best Wishes,
>>>>> Ashutosh Bapat
>>>>> EntepriseDB Corporation
>>>>> The Enterprise Postgres Company
>>>>>
>>>>>
>>>>  ------------------------------**------------------------------**
>>> ------------------
>>>
>>>> Precog is a next-generation analytics platform capable of advanced
>>>> analytics on semi-structured data. The platform includes APIs for
>>>> building
>>>> apps and a phenomenal toolset for data science. Developers can use
>>>> our toolset for easy data analysis & visualization. Get a free
>>>> account!
>>>>
>>>>  http://www2.precog.com/**precogplatform/**
>>> slashdotnewsletter____________**______________________________**_____<http://www2.precog.com/precogplatform/slashdotnewsletter_______________________________________________>
>>>
>>>> postgres-xc-announce mailing list
>>>> postgres-xc-announce@lists.**sourceforge.net<pos...@li...>
>>>> https://lists.sourceforge.net/**lists/listinfo/postgres-xc-**announce<https://lists.sourceforge.net/lists/listinfo/postgres-xc-announce>
>>>>
>>>
>>>
>>> ------------------------------**------------------------------**
>>> ------------------
>>> Precog is a next-generation analytics platform capable of advanced
>>> analytics on semi-structured data. The platform includes APIs for
>>> building
>>> apps and a phenomenal toolset for data science. Developers can use
>>> our toolset for easy data analysis & visualization. Get a free account!
>>> http://www2.precog.com/**precogplatform/**slashdotnewsletter<http://www2.precog.com/precogplatform/slashdotnewsletter>
>>> ______________________________**_________________
>>> postgres-xc-announce mailing list
>>> postgres-xc-announce@lists.**sourceforge.net<pos...@li...>
>>> https://lists.sourceforge.net/**lists/listinfo/postgres-xc-**announce<https://lists.sourceforge.net/lists/listinfo/postgres-xc-announce>
>>>
>>>
>>
>>
>> --
>> Mason Sharp
>>
>> StormDB - http://www.stormdb.com
>> The Database Cloud
>> Postgres-XC Support and Services
>>
>


-- 
Mason Sharp

StormDB - http://www.stormdb.com
The Database Cloud
Postgres-XC Support and Services

Re: [Postgres-xc-announce] Using Postgres-XC as a key-value store

[Leo R. L. <le...@fi...>]

Hi,

Very cool, thanks to both of you (Mason, Robert) for the links!

Does anyone know if there's any recording of the talk though? I imagine 
that would be awesome.

Regards, Leo


On 21 Apr 2013, at 13:53, Mason Sharp wrote:

> Hi Leo,
>
> The presentation can be found here:
>
> http://www.slideshare.net/stormdb_cloud_database/postgres-xc-askeyvaluestorevsmongodb
>
> I had previously loaded up a version in March. I just updated it based 
> on
> new measurements that I presented about a week ago in Philadelphia.  I
> would like to do more measurements and update it again when I can, in
> particular I would like to measure insert performance with differing
> amounts of concurrency.
>
> Regards,
>
> Mason
>
>
>
>
> On Sun, Apr 21, 2013 at 7:18 AM, Leo R. Lundgren 
> <le...@fi...>wrote:
>
>> Hi,
>>
>> I'm curious if there's any material from this talk online yet? Really
>> looks like an interesting one :)
>>
>> Is there possibly also a recording of it to watch somewhere?
>>
>> Regards, Leo
>>
>>
>> On 14 Apr 2013, at 2:02, Mason Sharp wrote:
>>
>>> Hi Ashutosh,
>>>
>>> I will post a link to the updated slide deck next week.
>>>
>>> Regards,
>>>
>>> Mason
>>>
>>>
>>> On Fri, Apr 12, 2013 at 4:19 AM, Ashutosh Bapat <
>>> ash...@en...> wrote:
>>>
>>>> This is interesting.
>>>> I have been pondering over this. Can you please share some more
>>>> details?
>>>>
>>>>
>>>> On Thu, Apr 11, 2013 at 12:25 PM, Mason Sharp
>>>> <mas...@gm...>wrote:
>>>>
>>>>> I will be presenting on Monday April 15th in Philadelphia at the
>>>>> Philly
>>>>> PUG about using Postgres-XC as a key-value store.
>>>>>
>>>>> I will discuss hstore, XML and JSON, and include performance
>>>>> comparisons
>>>>> to MongoDB.
>>>>>
>>>>> More information can be found here:
>>>>>
>>>>>
>> http://www.phlpug.org/events/112128082/?eventId=112128082&action=detail
>>>>>
>>>>> Thanks,
>>>>>
>>>>> Mason Sharp
>>>>>
>>>>>
>>>>>
>> ------------------------------------------------------------------------------
>>>>> Precog is a next-generation analytics platform capable of advanced
>>>>> analytics on semi-structured data. The platform includes APIs for
>>>>> building
>>>>> apps and a phenomenal toolset for data science. Developers can use
>>>>> our toolset for easy data analysis & visualization. Get a free
>>>>> account!
>>>>> http://www2.precog.com/precogplatform/slashdotnewsletter
>>>>> _______________________________________________
>>>>> postgres-xc-announce mailing list
>>>>> pos...@li...
>>>>> https://lists.sourceforge.net/lists/listinfo/postgres-xc-announce
>>>>>
>>>>>
>>>>
>>>>
>>>> --
>>>> Best Wishes,
>>>> Ashutosh Bapat
>>>> EntepriseDB Corporation
>>>> The Enterprise Postgres Company
>>>>
>>>
>> ------------------------------------------------------------------------------
>>> Precog is a next-generation analytics platform capable of advanced
>>> analytics on semi-structured data. The platform includes APIs for
>>> building
>>> apps and a phenomenal toolset for data science. Developers can use
>>> our toolset for easy data analysis & visualization. Get a free
>>> account!
>>>
>> http://www2.precog.com/precogplatform/slashdotnewsletter_______________________________________________
>>> postgres-xc-announce mailing list
>>> pos...@li...
>>> https://lists.sourceforge.net/lists/listinfo/postgres-xc-announce
>>
>>
>> ------------------------------------------------------------------------------
>> Precog is a next-generation analytics platform capable of advanced
>> analytics on semi-structured data. The platform includes APIs for 
>> building
>> apps and a phenomenal toolset for data science. Developers can use
>> our toolset for easy data analysis & visualization. Get a free 
>> account!
>> http://www2.precog.com/precogplatform/slashdotnewsletter
>> _______________________________________________
>> postgres-xc-announce mailing list
>> pos...@li...
>> https://lists.sourceforge.net/lists/listinfo/postgres-xc-announce
>>
>
>
>
> -- 
> Mason Sharp
>
> StormDB - http://www.stormdb.com
> The Database Cloud
> Postgres-XC Support and Services

Re: [Postgres-xc-announce] Using Postgres-XC as a key-value store

[Mason S. <ma...@st...>]

Hi Leo,

The presentation can be found here:

http://www.slideshare.net/stormdb_cloud_database/postgres-xc-askeyvaluestorevsmongodb

I had previously loaded up a version in March. I just updated it based on
new measurements that I presented about a week ago in Philadelphia.  I
would like to do more measurements and update it again when I can, in
particular I would like to measure insert performance with differing
amounts of concurrency.

Regards,

Mason




On Sun, Apr 21, 2013 at 7:18 AM, Leo R. Lundgren <le...@fi...>wrote:

> Hi,
>
> I'm curious if there's any material from this talk online yet? Really
> looks like an interesting one :)
>
> Is there possibly also a recording of it to watch somewhere?
>
> Regards, Leo
>
>
> On 14 Apr 2013, at 2:02, Mason Sharp wrote:
>
> > Hi Ashutosh,
> >
> > I will post a link to the updated slide deck next week.
> >
> > Regards,
> >
> > Mason
> >
> >
> > On Fri, Apr 12, 2013 at 4:19 AM, Ashutosh Bapat <
> > ash...@en...> wrote:
> >
> >> This is interesting.
> >> I have been pondering over this. Can you please share some more
> >> details?
> >>
> >>
> >> On Thu, Apr 11, 2013 at 12:25 PM, Mason Sharp
> >> <mas...@gm...>wrote:
> >>
> >>> I will be presenting on Monday April 15th in Philadelphia at the
> >>> Philly
> >>> PUG about using Postgres-XC as a key-value store.
> >>>
> >>> I will discuss hstore, XML and JSON, and include performance
> >>> comparisons
> >>> to MongoDB.
> >>>
> >>> More information can be found here:
> >>>
> >>>
> http://www.phlpug.org/events/112128082/?eventId=112128082&action=detail
> >>>
> >>> Thanks,
> >>>
> >>> Mason Sharp
> >>>
> >>>
> >>>
> ------------------------------------------------------------------------------
> >>> Precog is a next-generation analytics platform capable of advanced
> >>> analytics on semi-structured data. The platform includes APIs for
> >>> building
> >>> apps and a phenomenal toolset for data science. Developers can use
> >>> our toolset for easy data analysis & visualization. Get a free
> >>> account!
> >>> http://www2.precog.com/precogplatform/slashdotnewsletter
> >>> _______________________________________________
> >>> postgres-xc-announce mailing list
> >>> pos...@li...
> >>> https://lists.sourceforge.net/lists/listinfo/postgres-xc-announce
> >>>
> >>>
> >>
> >>
> >> --
> >> Best Wishes,
> >> Ashutosh Bapat
> >> EntepriseDB Corporation
> >> The Enterprise Postgres Company
> >>
> >
> ------------------------------------------------------------------------------
> > Precog is a next-generation analytics platform capable of advanced
> > analytics on semi-structured data. The platform includes APIs for
> > building
> > apps and a phenomenal toolset for data science. Developers can use
> > our toolset for easy data analysis & visualization. Get a free
> > account!
> >
> http://www2.precog.com/precogplatform/slashdotnewsletter_______________________________________________
> > postgres-xc-announce mailing list
> > pos...@li...
> > https://lists.sourceforge.net/lists/listinfo/postgres-xc-announce
>
>
> ------------------------------------------------------------------------------
> Precog is a next-generation analytics platform capable of advanced
> analytics on semi-structured data. The platform includes APIs for building
> apps and a phenomenal toolset for data science. Developers can use
> our toolset for easy data analysis & visualization. Get a free account!
> http://www2.precog.com/precogplatform/slashdotnewsletter
> _______________________________________________
> postgres-xc-announce mailing list
> pos...@li...
> https://lists.sourceforge.net/lists/listinfo/postgres-xc-announce
>



-- 
Mason Sharp

StormDB - http://www.stormdb.com
The Database Cloud
Postgres-XC Support and Services

Re: [Postgres-xc-announce] Using Postgres-XC as a key-value store

[Leo R. L. <le...@fi...>]

Hi,

I'm curious if there's any material from this talk online yet? Really 
looks like an interesting one :)

Is there possibly also a recording of it to watch somewhere?

Regards, Leo


On 14 Apr 2013, at 2:02, Mason Sharp wrote:

> Hi Ashutosh,
>
> I will post a link to the updated slide deck next week.
>
> Regards,
>
> Mason
>
>
> On Fri, Apr 12, 2013 at 4:19 AM, Ashutosh Bapat <
> ash...@en...> wrote:
>
>> This is interesting.
>> I have been pondering over this. Can you please share some more 
>> details?
>>
>>
>> On Thu, Apr 11, 2013 at 12:25 PM, Mason Sharp 
>> <mas...@gm...>wrote:
>>
>>> I will be presenting on Monday April 15th in Philadelphia at the 
>>> Philly
>>> PUG about using Postgres-XC as a key-value store.
>>>
>>> I will discuss hstore, XML and JSON, and include performance 
>>> comparisons
>>> to MongoDB.
>>>
>>> More information can be found here:
>>>
>>> http://www.phlpug.org/events/112128082/?eventId=112128082&action=detail
>>>
>>> Thanks,
>>>
>>> Mason Sharp
>>>
>>>
>>> ------------------------------------------------------------------------------
>>> Precog is a next-generation analytics platform capable of advanced
>>> analytics on semi-structured data. The platform includes APIs for 
>>> building
>>> apps and a phenomenal toolset for data science. Developers can use
>>> our toolset for easy data analysis & visualization. Get a free 
>>> account!
>>> http://www2.precog.com/precogplatform/slashdotnewsletter
>>> _______________________________________________
>>> postgres-xc-announce mailing list
>>> pos...@li...
>>> https://lists.sourceforge.net/lists/listinfo/postgres-xc-announce
>>>
>>>
>>
>>
>> --
>> Best Wishes,
>> Ashutosh Bapat
>> EntepriseDB Corporation
>> The Enterprise Postgres Company
>>
> ------------------------------------------------------------------------------
> Precog is a next-generation analytics platform capable of advanced
> analytics on semi-structured data. The platform includes APIs for 
> building
> apps and a phenomenal toolset for data science. Developers can use
> our toolset for easy data analysis & visualization. Get a free 
> account!
> http://www2.precog.com/precogplatform/slashdotnewsletter_______________________________________________
> postgres-xc-announce mailing list
> pos...@li...
> https://lists.sourceforge.net/lists/listinfo/postgres-xc-announce

Re: [Postgres-xc-announce] Using Postgres-XC as a key-value store

[Mason S. <mas...@gm...>]

Hi Ashutosh,

I will post a link to the updated slide deck next week.

Regards,

Mason


On Fri, Apr 12, 2013 at 4:19 AM, Ashutosh Bapat <
ash...@en...> wrote:

> This is interesting.
> I have been pondering over this. Can you please share some more details?
>
>
> On Thu, Apr 11, 2013 at 12:25 PM, Mason Sharp <mas...@gm...>wrote:
>
>> I will be presenting on Monday April 15th in Philadelphia at the Philly
>> PUG about using Postgres-XC as a key-value store.
>>
>> I will discuss hstore, XML and JSON, and include performance comparisons
>> to MongoDB.
>>
>> More information can be found here:
>>
>> http://www.phlpug.org/events/112128082/?eventId=112128082&action=detail
>>
>> Thanks,
>>
>> Mason Sharp
>>
>>
>> ------------------------------------------------------------------------------
>> Precog is a next-generation analytics platform capable of advanced
>> analytics on semi-structured data. The platform includes APIs for building
>> apps and a phenomenal toolset for data science. Developers can use
>> our toolset for easy data analysis & visualization. Get a free account!
>> http://www2.precog.com/precogplatform/slashdotnewsletter
>> _______________________________________________
>> postgres-xc-announce mailing list
>> pos...@li...
>> https://lists.sourceforge.net/lists/listinfo/postgres-xc-announce
>>
>>
>
>
> --
> Best Wishes,
> Ashutosh Bapat
> EntepriseDB Corporation
> The Enterprise Postgres Company
>

Re: [Postgres-xc-announce] Using Postgres-XC as a key-value store

[Ashutosh B. <ash...@en...>]

This is interesting.
I have been pondering over this. Can you please share some more details?


On Thu, Apr 11, 2013 at 12:25 PM, Mason Sharp <mas...@gm...> wrote:

> I will be presenting on Monday April 15th in Philadelphia at the Philly
> PUG about using Postgres-XC as a key-value store.
>
> I will discuss hstore, XML and JSON, and include performance comparisons
> to MongoDB.
>
> More information can be found here:
>
> http://www.phlpug.org/events/112128082/?eventId=112128082&action=detail
>
> Thanks,
>
> Mason Sharp
>
>
> ------------------------------------------------------------------------------
> Precog is a next-generation analytics platform capable of advanced
> analytics on semi-structured data. The platform includes APIs for building
> apps and a phenomenal toolset for data science. Developers can use
> our toolset for easy data analysis & visualization. Get a free account!
> http://www2.precog.com/precogplatform/slashdotnewsletter
> _______________________________________________
> postgres-xc-announce mailing list
> pos...@li...
> https://lists.sourceforge.net/lists/listinfo/postgres-xc-announce
>
>


-- 
Best Wishes,
Ashutosh Bapat
EntepriseDB Corporation
The Enterprise Postgres Company

Re: [Postgres-xc-announce] Using Postgres-XC as a key-value store

[Koichi S. <koi...@gm...>]

Wonderful!  It is another are for XC.

As I've just announced, we're going to have XC-Day at Ottawa, May 21st
Tuesday, just after the cluster summit.

I'd like to share your presentation and feedback from the audience there.
----------
Koichi Suzuki


2013/4/11 Mason Sharp <mas...@gm...>

> I will be presenting on Monday April 15th in Philadelphia at the Philly
> PUG about using Postgres-XC as a key-value store.
>
> I will discuss hstore, XML and JSON, and include performance comparisons
> to MongoDB.
>
> More information can be found here:
>
> http://www.phlpug.org/events/112128082/?eventId=112128082&action=detail
>
> Thanks,
>
> Mason Sharp
>
>
> ------------------------------------------------------------------------------
> Precog is a next-generation analytics platform capable of advanced
> analytics on semi-structured data. The platform includes APIs for building
> apps and a phenomenal toolset for data science. Developers can use
> our toolset for easy data analysis & visualization. Get a free account!
> http://www2.precog.com/precogplatform/slashdotnewsletter
> _______________________________________________
> postgres-xc-announce mailing list
> pos...@li...
> https://lists.sourceforge.net/lists/listinfo/postgres-xc-announce
>
>

[Postgres-xc-announce] Using Postgres-XC as a key-value store

[Mason S. <mas...@gm...>]

I will be presenting on Monday April 15th in Philadelphia at the Philly PUG
about using Postgres-XC as a key-value store.

I will discuss hstore, XML and JSON, and include performance comparisons to
MongoDB.

More information can be found here:

http://www.phlpug.org/events/112128082/?eventId=112128082&action=detail

Thanks,

Mason Sharp

[Postgres-xc-announce] Postgres-XC will have user/developer meeting after the cluster summit, Ottawa

[Koichi S. <koi...@gm...>]

Hi, PG-XCers;

Postgres-XC is going to have its first user/developer meeting after the
cluster summit.   Information is as follows:

When: May 21st, Tuesday, 3PM to 6PM.
Where: University of Ottawa.   Room TBD.
Agenda:
* Topics in Version 1.1
* Roadmap toward version 1.2 and beyond
* Development Issues
* Experiences

Also, further discussion could be held on Wednesday, 22nd and/or Saturday,
25th.    Details will be determined on Tuesday.

Information will be found at
https://wiki.postgresql.org/wiki/PgCon2013CanadaClusterSummit#PostgresXC_Summit

I do hope you can join.   Please feel free to register yourself and add our
topics to discuss.   If you have difficulty to do it. please mail to me.

Thank you very much;
----------
Koichi Suzuki

Re: [Postgres-xc-announce] [Postgres-xc-general] Postgres-XC 1.0.2 is out

[Michael P. <mic...@gm...>]

On Thu, Feb 7, 2013 at 6:37 PM, Paulo Pires <pj...@ub...> wrote:

> Hi all,
>
> Is there a changelog? I wanted to know if RETURNING support is merged
> into this version.
>
This is a minor release with only bug fixes. You need to wait for the next
major release, normally 1.1, to get this support. Btw, the feature has been
committed on master branch, so you can already test it by fetching latest
development code.
-- 
Michael

Re: [Postgres-xc-announce] [Postgres-xc-general] Postgres-XC 1.0.2 is out

[Paulo P. <pj...@ub...>]

Hi all,

Is there a changelog? I wanted to know if RETURNING support is merged 
into this version.

Thanks,
PP

On 07-02-2013 07:36, Koichi Suzuki wrote:
> Postgres-XC development group release postgres-xc 1.0.2 with a bunch
> of fixes/improvement as well as upgrade the base code to PostgreSQL
> 9.1.7.
>
> You will find resources at:
> http://postgres-xc.sourceforge.net/
> http://postgres-xc.sourceforge.net/docs/
> https://sourceforge.net/projects/postgres-xc/files/Version_1.0/
>
> Upgrading base PostgreSQL version to 9.2 will be included in the next
> major release.
>
> ----
> Postgres-XC is a symmetric PostgreSQL cluster which provides both read
> and write scalability using mixture of table sharding and replication.
>
> Each Postgres-XC cluster node provides single database view, where
> application can connect to any cluster node and run any transactions.
> Result of transactions are visible from all the cluster nodes without
> delay.
> ----------
> Koichi Suzuki
>
> ------------------------------------------------------------------------------
> Free Next-Gen Firewall Hardware Offer
> Buy your Sophos next-gen firewall before the end March 2013
> and get the hardware for free! Learn more.
> http://p.sf.net/sfu/sophos-d2d-feb
> _______________________________________________
> Postgres-xc-general mailing list
> Pos...@li...
> https://lists.sourceforge.net/lists/listinfo/postgres-xc-general

[Postgres-xc-announce] Postgres-XC 1.0.2 is out

[Koichi S. <koi...@gm...>]

Postgres-XC development group release postgres-xc 1.0.2 with a bunch
of fixes/improvement as well as upgrade the base code to PostgreSQL
9.1.7.

You will find resources at:
http://postgres-xc.sourceforge.net/
http://postgres-xc.sourceforge.net/docs/
https://sourceforge.net/projects/postgres-xc/files/Version_1.0/

Upgrading base PostgreSQL version to 9.2 will be included in the next
major release.

----
Postgres-XC is a symmetric PostgreSQL cluster which provides both read
and write scalability using mixture of table sharding and replication.

Each Postgres-XC cluster node provides single database view, where
application can connect to any cluster node and run any transactions.
Result of transactions are visible from all the cluster nodes without
delay.
----------
Koichi Suzuki