Обсуждение: commercial adaptation of postgres
I once talked to a company that made a custome version of Postgres. It split tables up on columns and also by rows, had someother custome features. It was enormously faster from what I gathered. I could of sworn it began with the letter 'T', but maybe not. I don't see anything like that on the commercial page of theposgres site. Does anyone know what it is out there in enterprise commercially modified postgres servers? (on 64 bit machines, preferably) Dennis Gearon Signature Warning ---------------- EARTH has a Right To Life I agree with Bolivian President Evo Morales # The right to life: "The right for no ecosystem to be eliminated by the irresponsible acts of human beings." # The right of biosystems to regenerate themselves: "Development cannot be infinite. There's a limit on everything." # The right to a clean life: "The right for Mother Earth to live without contamination, pollution. Fish and animals and treeshave rights." # The right to harmony and balance between everyone and everything: "We are all interdependent." See the movie - 'Inconvenient Truth' See the movie - 'Syriana'
On Jul 20, 2009, at 6:56 PM, Dennis Gearon wrote:
>
> I once talked to a company that made a custome version of Postgres.
> It split tables up on columns and also by rows, had some other
> custome features. It was enormously faster from what I gathered.
>
> I could of sworn it began with the letter 'T', but maybe not. I
> don't see anything like that on the commercial page of the posgres
> site.
Truviso?
http://truviso.com/
On Jul 20, 2009, at 8:56 PM, Dennis Gearon wrote: > > I once talked to a company that made a custome version of Postgres. > It split tables up on columns and also by rows, had some other > custome features. It was enormously faster from what I gathered. > > I could of sworn it began with the letter 'T', but maybe not. I > don't see anything like that on the commercial page of the posgres > site. > > Does anyone know what it is out there in enterprise commercially > modified postgres servers? (on 64 bit machines, preferably) Yahoo did that, they where planning to open source it, that's all I know....
Greenplum uses a modified version of PostgreSQL for their MPP product. http://www.greenplum.com/ On Mon, Jul 20, 2009 at 6:56 PM, Dennis Gearon<gearond@sbcglobal.net> wrote: > > I once talked to a company that made a custome version of Postgres. It split tables up on columns and also by rows, hadsome other custome features. It was enormously faster from what I gathered. > > I could of sworn it began with the letter 'T', but maybe not. I don't see anything like that on the commercial page ofthe posgres site. > > Does anyone know what it is out there in enterprise commercially modified postgres servers? (on 64 bit machines, preferably) > > > Dennis Gearon > > Signature Warning > ---------------- > EARTH has a Right To Life > > I agree with Bolivian President Evo Morales > > # The right to life: "The right for no ecosystem to be eliminated by the irresponsible acts of human beings." > > # The right of biosystems to regenerate themselves: "Development cannot be infinite. There's a limit on everything." > > # The right to a clean life: "The right for Mother Earth to live without contamination, pollution. Fish and animals andtrees have rights." > > # The right to harmony and balance between everyone and everything: "We are all interdependent." > > > See the movie - 'Inconvenient Truth' > See the movie - 'Syriana' > > -- > Sent via pgsql-general mailing list (pgsql-general@postgresql.org) > To make changes to your subscription: > http://www.postgresql.org/mailpref/pgsql-general >
Thanks Bricklen Dennis Gearon --- On Tue, 7/21/09, bricklen <bricklen@gmail.com> wrote: > From: bricklen <bricklen@gmail.com> > Subject: Re: [GENERAL] commercial adaptation of postgres > To: "Dennis Gearon" <gearond@sbcglobal.net> > Cc: pgsql-general@postgresql.org > Date: Tuesday, July 21, 2009, 7:33 AM > Greenplum uses a modified version of > PostgreSQL for their MPP product. > http://www.greenplum.com/ > > On Mon, Jul 20, 2009 at 6:56 PM, Dennis Gearon<gearond@sbcglobal.net> > wrote: > > > > I once talked to a company that made a custome version > of Postgres. It split tables up on columns and also by rows, > had some other custome features. It was enormously faster > from what I gathered. > > > > I could of sworn it began with the letter 'T', but > maybe not. I don't see anything like that on the commercial > page of the posgres site. > > > > Does anyone know what it is out there in enterprise > commercially modified postgres servers? (on 64 bit machines, > preferably) > > > > > > Dennis Gearon > > > > Signature Warning > > ---------------- > > EARTH has a Right To Life > > > > I agree with Bolivian President Evo Morales > > > > # The right to life: "The right for no ecosystem to be > eliminated by the irresponsible acts of human beings." > > > > # The right of biosystems to regenerate themselves: > "Development cannot be infinite. There's a limit on > everything." > > > > # The right to a clean life: "The right for Mother > Earth to live without contamination, pollution. Fish and > animals and trees have rights." > > > > # The right to harmony and balance between everyone > and everything: "We are all interdependent." > > > > > > See the movie - 'Inconvenient Truth' > > See the movie - 'Syriana' > > > > -- > > Sent via pgsql-general mailing list (pgsql-general@postgresql.org) > > To make changes to your subscription: > > http://www.postgresql.org/mailpref/pgsql-general > > >
On Mon, Jul 20, 2009 at 9:56 PM, Dennis Gearon<gearond@sbcglobal.net> wrote: > > I once talked to a company that made a custome version of Postgres. It split tables up on columns and also by rows, hadsome other custome features. It was enormously faster from what I gathered. Faster at some things :-). column oriented db is a tradeoff...it's less work to get one or two columns but your record is not guaranteed to be in one place on disk...which has obvious downsides. I don't have any evidence other than my gut, but I betcha column db being an 'evolutionary step' above current methods is mostly hype. However for certain workloads I'm sure it's great... merlin
On Mon, 20 Jul 2009, Christophe wrote: > On Jul 20, 2009, at 6:56 PM, Dennis Gearon wrote: >> >> I once talked to a company that made a custome version of Postgres. It >> split tables up on columns and also by rows, had some other custome >> features. It was enormously faster from what I gathered. >> >> I could of sworn it began with the letter 'T', but maybe not. I don't see >> anything like that on the commercial page of the posgres site. > > Truviso? http://truviso.com/ We don't do any column-oriented stuff at Truviso. From the description Dennis gave, I'm guess he's thinking of the Petabyte database at Yahoo: http://it.toolbox.com/blogs/database-soup/2-petabyte-postgresql-24848 -- * Greg Smith gsmith@gregsmith.com http://www.gregsmith.com Baltimore, MD
Also try Netezza, one data warehouse appliance originally based on Postgres. Although this is not the only such Postgresderivative. Cheers, Brent Wood Brent Wood DBA/GIS consultant NIWA, Wellington New Zealand >>> Greg Smith <gsmith@gregsmith.com> 07/24/09 9:10 AM >>> On Mon, 20 Jul 2009, Christophe wrote: > On Jul 20, 2009, at 6:56 PM, Dennis Gearon wrote: >> >> I once talked to a company that made a custome version of Postgres. It >> split tables up on columns and also by rows, had some other custome >> features. It was enormously faster from what I gathered. >> >> I could of sworn it began with the letter 'T', but maybe not. I don't see >> anything like that on the commercial page of the posgres site. > > Truviso? http://truviso.com/ We don't do any column-oriented stuff at Truviso. From the description Dennis gave, I'm guess he's thinking of the Petabyte database at Yahoo: http://it.toolbox.com/blogs/database-soup/2-petabyte-postgresql-24848 -- * Greg Smith gsmith@gregsmith.com http://www.gregsmith.com Baltimore, MD -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general NIWA is the trading name of the National Institute of Water & Atmospheric Research Ltd.