Re: Storing a tree

From: Micah Yoder <yodermk(at)home(dot)com>
To: "Christian Meunier" <jelan(at)magelo(dot)com>, pgsql-general(at)postgresql(dot)org
Subject: Re: Storing a tree
Date: 2001-11-10 05:07:25
Message-ID: 20011110080720.PEDL11705.femail8.sdc1.sfba.home.com@there
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general pgsql-jdbc

> This approach will be two to three orders of magnitude faster than the
> adjacency list model for subtree and aggregate operations.

That's great, thanks for posting that!

I take it this would NOT work well on things that are updated often, like
threaded Net message boards with hundreds of thousands of messages...

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Jan Poslusny 2001-11-10 10:06:18 Re: How to view the functions that exists
Previous Message Jorge Sarmiento 2001-11-10 01:52:58 psql -f backup.out || file too big

Browse pgsql-jdbc by date

  From Date Subject
Next Message Justin Clift 2001-11-10 05:47:49 Re: MD5-based passwords
Previous Message Bruce Momjian 2001-11-10 05:04:00 Remember to register PostgreSQL for JDJ 2002 awards (fwd)