From: | Brian Ghidinelli <brian(at)pukkasoft(dot)com> |
---|---|
To: | sfpug(at)postgresql(dot)org |
Subject: | Re: running aggregates entirely in SQL? |
Date: | 2004-05-11 20:39:49 |
Message-ID: | 40A13A15.5050106@pukkasoft.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | sfpug |
Josh Berkus wrote:
> I have. I find it really, really fast for "in branch" queries (which other
> trees suck at) but really, really slow to update. So it's a good model for
> a tree which will be modified, say, once every 10,000 reads.
Same here. I've used it in a Sybase/MSSQL environment with Transact-SQL
stored procedures but my postgres kung-fu is nowhere near adequate to
replicate that functionality. I have used it for a message board system
that allowed deep threading successfully. I think it would also be good
for large organizational charts or family tree type models but I don't
have any of those really in my current project (motorsport event
management software).
Cheers,
Brian
From | Date | Subject | |
---|---|---|---|
Next Message | Fred Moyer | 2004-05-11 21:26:29 | May Meeting details on website... |
Previous Message | Aditya | 2004-05-11 20:37:08 | Re: running aggregates entirely in SQL? |