Re: [HACKERS] Planning aggregates which require sorted or distinct
Stefan Kaltenbrunner wrote: > Karen Hill wrote: > > Gavin Sherry wrote: > >> Recenly, I've been researching and putting together a proposal for window > >> functions. > > > > Implementing NULLS FIRST and NULLS LAST appears like another > > challenging step to getting window functions wrapped up. Has your > > research lead you to any ideas on what your strategy for NULLS FIRST > > and NULLS LAST likely would be? > > maybe I'm missunderstanding your question but tom implemented that > already in -HEAD: > Cool. I missed that. :-) ---(end of broadcast)--- TIP 7: You can help support the PostgreSQL project by donating at http://www.postgresql.org/about/donate
Re: [HACKERS] Planning aggregates which require sorted or distinct input
Gavin Sherry wrote: > Recenly, I've been researching and putting together a proposal for window > functions. Implementing NULLS FIRST and NULLS LAST appears like another challenging step to getting window functions wrapped up. Has your research lead you to any ideas on what your strategy for NULLS FIRST and NULLS LAST likely would be? ---(end of broadcast)--- TIP 7: You can help support the PostgreSQL project by donating at http://www.postgresql.org/about/donate
Re: [HACKERS] Release Notes: Major Changes in 8.2
Simon Riggs wrote: > > SQL:2003 Analytical functions (Sergey, Tom, Neil) > > All statistical aggregate functions defined by SQL:2003 are now > supported and user-defined aggregates now can take multiple columns as > inputs. > Could this be a good starting point for SQL:2003 Window functions as now the work on SQL:2003 statistical functions are done? As experienced postgres developers what would be your roadmap to implement window functions? ---(end of broadcast)--- TIP 2: Don't 'kill -9' the postmaster
[HACKERS] DTrace?
I skimmed the thread "Spinlocks, yet again: analysis and proposed patches". Wouldn't Solaris 10's DTrace be helpful in seeing what's going on? It seems DTrace was meant for these types of problems. __ Yahoo! FareChase: Search multiple travel sites in one click. http://farechase.yahoo.com ---(end of broadcast)--- TIP 3: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faq
[HACKERS] PostgreSQL roadmap for 8.2 and beyond.
Autovacuum is getting put into the 8.1 release which is awesome. A lot of us are wondering now that PostgreSQL has all the features that many of us need, what are the features being planned for future releases? What do you see for 8.2 and beyond? What type of features are you devs planning for 9.0? It would be good if you could put up a place on your site so we mortals can drool over up-coming postgresql features. __ Start your day with Yahoo! - Make it your home page! http://www.yahoo.com/r/hs ---(end of broadcast)--- TIP 2: Don't 'kill -9' the postmaster