Re: [HACKERS] Google SoC--Idea Request

2006-08-14 Thread Tom Lane
Martijn van Oosterhout writes: > On Mon, Aug 14, 2006 at 08:09:36AM -0400, Tom Lane wrote: >> It's like a two-line patch, so hardly worth putting in TODO ... might >> as well just do it. IIRC the motivation is mostly to silence a >> Coverity warning? > Well sort of. I can also just tick a box an

Re: [HACKERS] Google SoC--Idea Request

2006-08-14 Thread Martijn van Oosterhout
On Mon, Aug 14, 2006 at 08:09:36AM -0400, Tom Lane wrote: > > Any thoughts on this? Make it a TODO item, document it, or simply > > ignore it? > > It's like a two-line patch, so hardly worth putting in TODO ... might > as well just do it. IIRC the motivation is mostly to silence a > Coverity warn

Re: [HACKERS] Google SoC--Idea Request

2006-08-14 Thread Tom Lane
Martijn van Oosterhout writes: > On Thu, Apr 20, 2006 at 11:56:32AM -0400, Tom Lane wrote: >> I wonder if we shouldn't just remove the hash_destroy calls in >> hash_create's failure paths. hash_destroy is explicitly not gonna >> work on a shared-memory hashtable, and in all other cases I'd expect

Re: [HACKERS] Google SoC--Idea Request

2006-08-14 Thread Martijn van Oosterhout
On Thu, Apr 20, 2006 at 11:56:32AM -0400, Tom Lane wrote: > Martijn van Oosterhout writes: > > About the only thing in the backend I found interesting was this: > > src/backend/utils/hash/dynahash.c function hash_create > > I wonder if we shouldn't just remove the hash_destroy calls in > hash_cre

Re: [HACKERS] Google SoC--Idea Request

2006-05-02 Thread Jonah H. Harris
You need to submit this through Google. Student FAQ: http://code.google.com/soc/studentfaq.html Student Sign-up: http://code.google.com/soc/student_step1.html On 5/2/06, Nikolay Samokhvalov <[EMAIL PROTECTED]> wrote: Proposal: XMLType for PostgreSQL. *** Minimum: *** to have special type supp

Re: [HACKERS] Google SoC--Idea Request

2006-05-02 Thread Nikolay Samokhvalov
Proposal: XMLType for PostgreSQL. *** Minimum: *** to have special type support for storing XML data and working with it. This means following: - ability to define any column of a table as of XMLType; internally, all data is stored as VARCHAR; - auto validation of documents against XML schema, if

Re: [HACKERS] Google SoC--Idea Request

2006-04-25 Thread Jim C. Nasby
On Tue, Apr 25, 2006 at 08:39:57AM -0400, Jonah H. Harris wrote: > On 4/25/06, Bort, Paul <[EMAIL PROTECTED]> wrote: > > Maybe the SoC project here is just such a tuning advisor tool? Something > > that can run pgbench repeatedly, try different settings, and compare > > results. > > IIRC, that alr

Re: [HACKERS] Google SoC--Idea Request

2006-04-25 Thread Bruce Momjian
Tom Lane wrote: > "Jonah H. Harris" <[EMAIL PROTECTED]> writes: > > On 4/25/06, Andrew Dunstan <[EMAIL PROTECTED]> wrote: > >> Personally I would much rather see a tuning advisor tool in more general > >> use than just provide small/medium/large config setting files. > > > True dat. > > One thing

Re: [HACKERS] Google SoC--Idea Request

2006-04-25 Thread Jonah H. Harris
On 4/25/06, Bort, Paul <[EMAIL PROTECTED]> wrote: > Maybe the SoC project here is just such a tuning advisor tool? Something > that can run pgbench repeatedly, try different settings, and compare > results. IIRC, that already exists. I think it was called pg_autotune or something similar. -- Jo

Re: [HACKERS] Google SoC--Idea Request

2006-04-25 Thread Bort, Paul
> > Personally I would much rather see a tuning advisor tool in > more general > > use than just provide small/medium/large config setting files. > > True dat. Maybe the SoC project here is just such a tuning advisor tool? Something that can run pgbench repeatedly, try different settings, and co

Re: [HACKERS] Google SoC--Idea Request

2006-04-24 Thread ipig
"Jonah H. Harris" <[EMAIL PROTECTED]> Cc: "Andrew Dunstan" <[EMAIL PROTECTED]>; "Jim C. Nasby" <[EMAIL PROTECTED]>; "John DeSoi" <[EMAIL PROTECTED]>; "Pgsql Hackers" Sent: Tuesday, April 25, 2006 2:16 PM Subject: Re: [HACKERS]

Re: [HACKERS] Google SoC--Idea Request

2006-04-24 Thread Tom Lane
"Jonah H. Harris" <[EMAIL PROTECTED]> writes: > On 4/25/06, Andrew Dunstan <[EMAIL PROTECTED]> wrote: >> Personally I would much rather see a tuning advisor tool in more general >> use than just provide small/medium/large config setting files. > True dat. One thing that has to be figured out befo

Re: [HACKERS] Google SoC--Idea Request

2006-04-24 Thread Andrew Dunstan
Jim C. Nasby wrote: On Mon, Apr 24, 2006 at 11:05:18PM -0400, Tom Lane wrote: "Jonah H. Harris" <[EMAIL PROTECTED]> writes: While the student could do some benchmarking on relatively new hardware and make suggestions, I agree with Tom. Having to keep support for older platforms doesn'

Re: [HACKERS] Google SoC--Idea Request

2006-04-24 Thread Jonah H. Harris
On 4/25/06, Andrew Dunstan <[EMAIL PROTECTED]> wrote: > We have already done some initdb tuning improvements for 8.2 Cool, I hadn't looked at this. > I would have liked to increase max_connections too, but that would have > caused problems on OSX, apparently. See previous discussion. Yeah, their

Re: [HACKERS] Google SoC--Idea Request

2006-04-24 Thread Jim C. Nasby
On Mon, Apr 24, 2006 at 11:05:18PM -0400, Tom Lane wrote: > "Jonah H. Harris" <[EMAIL PROTECTED]> writes: > > While the student could do some benchmarking on relatively new > > hardware and make suggestions, I agree with Tom. Having to keep > > support for older platforms doesn't leave much flexib

Re: [HACKERS] Google SoC--Idea Request

2006-04-24 Thread Jonah H. Harris
On 4/24/06, Tom Lane <[EMAIL PROTECTED]> wrote: > We've talked more than once about offering multiple alternative > starting-point postgresql.conf files to give people an idea of what to > do for small/medium/large installations. MySQL have done that for years > and it doesn't seem that users are

Re: [HACKERS] Google SoC--Idea Request

2006-04-24 Thread Tom Lane
"Jonah H. Harris" <[EMAIL PROTECTED]> writes: > While the student could do some benchmarking on relatively new > hardware and make suggestions, I agree with Tom. Having to keep > support for older platforms doesn't leave much flexibility to change > the defaults. Another point here is that the de

Re: [HACKERS] Google SoC--Idea Request

2006-04-24 Thread Jonah H. Harris
On 4/24/06, Tom Lane <[EMAIL PROTECTED]> wrote: > I doubt this is SoC material, simply because the issues have little to > do with coding and a lot to do with persuading people to drop default > support for old platforms. Which is not something a student is likely > to succeed at. While the stude

Re: [HACKERS] Google SoC--Idea Request

2006-04-24 Thread Tom Lane
"Jim C. Nasby" <[EMAIL PROTECTED]> writes: > Where do we stand with getting much more reasonable default values in > postgresql.conf? Maybe that should be a SoC project, or is it too small? Define "much more reasonable". I doubt this is SoC material, simply because the issues have little to do wi

Re: [HACKERS] Google SoC--Idea Request

2006-04-24 Thread Jim C. Nasby
Where do we stand with getting much more reasonable default values in postgresql.conf? Maybe that should be a SoC project, or is it too small? -- Jim C. Nasby, Sr. Engineering Consultant [EMAIL PROTECTED] Pervasive Software http://pervasive.comwork: 512-231-6117 vcard: http://jim.nas

Re: [HACKERS] Google SoC--Idea Request

2006-04-23 Thread Jonah H. Harris
Cool... will get them added. On 4/23/06, Alvaro Herrera <[EMAIL PROTECTED]> wrote: > I hope I'm not too late. > > Jonah H. Harris wrote: > > On 4/19/06, John DeSoi <[EMAIL PROTECTED]> wrote: > > > Alvaro indicated he would be willing to provide direction on this > > > with testing support from me.

Re: [HACKERS] Google SoC--Idea Request

2006-04-23 Thread Alvaro Herrera
I hope I'm not too late. Jonah H. Harris wrote: > On 4/19/06, John DeSoi <[EMAIL PROTECTED]> wrote: > > Alvaro indicated he would be willing to provide direction on this > > with testing support from me. He also said there are several other > > possible PL/PHP issues that would warrant a SoC proje

Re: [HACKERS] Google SoC--Idea Request

2006-04-21 Thread Andreas Pflug
Jim C. Nasby wrote: Same with pgAdmin3. Is there a list of specific projects? I'm pretty sure we can't just say "work on (pgp)PgAdmin... Our TODO list has some. Regards, Andreas ---(end of broadcast)--- TIP 1: if posting/reading thr

Re: [HACKERS] Google SoC--Idea Request

2006-04-21 Thread Jim C. Nasby
On Fri, Apr 21, 2006 at 05:48:33PM -0400, Robert Treat wrote: > On Friday 21 April 2006 14:11, Jim C. Nasby wrote: > > On Fri, Apr 21, 2006 at 10:27:48AM +0200, Andreas Pflug wrote: > > > Christopher Kings-Lynne wrote: > > > >>I think Martin Oosterhout's nearby email on coverity bug reports might >

Re: [HACKERS] Google SoC--Idea Request

2006-04-21 Thread Robert Treat
On Friday 21 April 2006 14:11, Jim C. Nasby wrote: > On Fri, Apr 21, 2006 at 10:27:48AM +0200, Andreas Pflug wrote: > > Christopher Kings-Lynne wrote: > > >>I think Martin Oosterhout's nearby email on coverity bug reports might > > >>make a good SoC project, but should it also be added to the TODO

Re: [HACKERS] Google SoC--Idea Request

2006-04-21 Thread Jonah H. Harris
Robert and I are working on updating it ASAP. On 4/21/06, Jim C. Nasby <[EMAIL PROTECTED]> wrote: > On Fri, Apr 21, 2006 at 10:27:48AM +0200, Andreas Pflug wrote: > > Christopher Kings-Lynne wrote: > > >>I think Martin Oosterhout's nearby email on coverity bug reports might > > >>make a good SoC p

Re: [HACKERS] Google SoC--Idea Request

2006-04-21 Thread Jim C. Nasby
On Fri, Apr 21, 2006 at 10:27:48AM +0200, Andreas Pflug wrote: > Christopher Kings-Lynne wrote: > >>I think Martin Oosterhout's nearby email on coverity bug reports might > >>make a good SoC project, but should it also be added to the TODO list? > > > > > >I may as well put up phpPgAdmin for it.

Re: [HACKERS] Google SoC--Idea Request

2006-04-21 Thread Andreas Pflug
Christopher Kings-Lynne wrote: I think Martin Oosterhout's nearby email on coverity bug reports might make a good SoC project, but should it also be added to the TODO list? I may as well put up phpPgAdmin for it. We have plenty of projects available in phpPgAdmin... Same with pgAdmin3. R

Re: [HACKERS] Google SoC--Idea Request

2006-04-20 Thread Christopher Kings-Lynne
I think Martin Oosterhout's nearby email on coverity bug reports might make a good SoC project, but should it also be added to the TODO list? I may as well put up phpPgAdmin for it. We have plenty of projects available in phpPgAdmin... Chris ---(end of broadcast)--

Re: [HACKERS] Google SoC--Idea Request

2006-04-20 Thread Martijn van Oosterhout
On Sat, Apr 15, 2006 at 03:05:20PM -0400, Jonah H. Harris wrote: > Hey everyone, > > I know we started a discussion a month or so ago regarding ideas for > SoC projects. However, after reading through the thread, I didn't see > us nail down any actual items. Here's an idea: Get the ECPG test pro

Re: [HACKERS] Google SoC--Idea Request

2006-04-20 Thread Jim C. Nasby
Another idea; add the ability for buildfarm machines to do a pgbench run to stress-test the code. Such a test would probably have found the windows pgbench issue I reported some time ago. This would have to be optional, as not all buildfarm machines/owners would tolerate the benchmark. -- Jim C.

Re: [HACKERS] Google SoC--Idea Request

2006-04-20 Thread Tom Lane
Martijn van Oosterhout writes: > About the only thing in the backend I found interesting was this: > src/backend/utils/hash/dynahash.c function hash_create I wonder if we shouldn't just remove the hash_destroy calls in hash_create's failure paths. hash_destroy is explicitly not gonna work on a s

Re: [HACKERS] Google SoC--Idea Request

2006-04-20 Thread Martijn van Oosterhout
On Thu, Apr 20, 2006 at 11:04:31AM -0400, Tom Lane wrote: > Martijn van Oosterhout writes: > > On Thu, Apr 20, 2006 at 08:51:25AM -0400, Robert Treat wrote: > >> I think Martin Oosterhout's nearby email on coverity bug reports might > >> make a > >> good SoC project, but should it also be added t

Re: [HACKERS] Google SoC--Idea Request

2006-04-20 Thread Tom Lane
Martijn van Oosterhout writes: > On Thu, Apr 20, 2006 at 08:51:25AM -0400, Robert Treat wrote: >> I think Martin Oosterhout's nearby email on coverity bug reports might make a >> good SoC project, but should it also be added to the TODO list? > ... > In any case, after you weed out the false-posit

Re: [HACKERS] Google SoC--Idea Request

2006-04-20 Thread Martijn van Oosterhout
On Thu, Apr 20, 2006 at 08:51:25AM -0400, Robert Treat wrote: > On Wednesday 19 April 2006 12:09, Jonah H. Harris wrote: > > On 4/19/06, John DeSoi <[EMAIL PROTECTED]> wrote: > > > Alvaro indicated he would be willing to provide direction on this > > > with testing support from me. He also said the

Re: [HACKERS] Google SoC--Idea Request

2006-04-20 Thread Robert Treat
On Wednesday 19 April 2006 12:09, Jonah H. Harris wrote: > On 4/19/06, John DeSoi <[EMAIL PROTECTED]> wrote: > > Alvaro indicated he would be willing to provide direction on this > > with testing support from me. He also said there are several other > > possible PL/PHP issues that would warrant a S

Re: [HACKERS] Google SoC--Idea Request

2006-04-19 Thread Alvaro Herrera
Joshua D. Drake wrote: > John DeSoi wrote: > >Proposed item: Improve PL/PHP support, especially installation on > >non-Linux platforms. PL/PHP does not currently work on OS X (not sure > >about Windows, but I doubt it). > > It definitely does NOT work on Windows. MacOSX is just a matter of us >

Re: [HACKERS] Google SoC--Idea Request

2006-04-19 Thread Joshua D. Drake
John DeSoi wrote: Proposed item: Improve PL/PHP support, especially installation on non-Linux platforms. PL/PHP does not currently work on OS X (not sure about Windows, but I doubt it). It definitely does NOT work on Windows. MacOSX is just a matter of us having some time. Alvaro indicated

Re: [HACKERS] Google SoC--Idea Request

2006-04-19 Thread Jonah H. Harris
On 4/19/06, John DeSoi <[EMAIL PROTECTED]> wrote: > Alvaro indicated he would be willing to provide direction on this > with testing support from me. He also said there are several other > possible PL/PHP issues that would warrant a SoC project. Cool... let's get 'em all listed here so we can move

Re: [HACKERS] Google SoC--Idea Request

2006-04-19 Thread John DeSoi
Proposed item: Improve PL/PHP support, especially installation on non- Linux platforms. PL/PHP does not currently work on OS X (not sure about Windows, but I doubt it). Alvaro indicated he would be willing to provide direction on this with testing support from me. He also said there are seve

Re: [HACKERS] Google SoC--Idea Request

2006-04-18 Thread Mark Wong
Jonah H. Harris wrote: On 4/18/06, Jim C. Nasby <[EMAIL PROTECTED]> wrote: On Tue, Apr 18, 2006 at 11:27:40AM -0700, Mark Wong wrote: Jim C. Nasby wrote: On Sat, Apr 15, 2006 at 03:05:20PM -0400, Jonah H. Harris wrote: All ideas welcome! I know it's not directly PostgreSQL related, but I'd l

Re: [HACKERS] Google SoC--Idea Request

2006-04-18 Thread Jonah H. Harris
On 4/18/06, Jim C. Nasby <[EMAIL PROTECTED]> wrote: > On Tue, Apr 18, 2006 at 11:27:40AM -0700, Mark Wong wrote: > > Jim C. Nasby wrote: > > >On Sat, Apr 15, 2006 at 03:05:20PM -0400, Jonah H. Harris wrote: > > >>All ideas welcome! > > > > > >I know it's not directly PostgreSQL related, but I'd lov

Re: [HACKERS] Google SoC--Idea Request

2006-04-18 Thread Jim C. Nasby
On Tue, Apr 18, 2006 at 11:27:40AM -0700, Mark Wong wrote: > Jim C. Nasby wrote: > >On Sat, Apr 15, 2006 at 03:05:20PM -0400, Jonah H. Harris wrote: > >>All ideas welcome! > > > >I know it's not directly PostgreSQL related, but I'd love to see the > >dbt* code improved. Items on my wish-list: > > >

Re: [HACKERS] Google SoC--Idea Request

2006-04-18 Thread Mark Wong
Jim C. Nasby wrote: On Sat, Apr 15, 2006 at 03:05:20PM -0400, Jonah H. Harris wrote: All ideas welcome! I know it's not directly PostgreSQL related, but I'd love to see the dbt* code improved. Items on my wish-list: - make it easy to run the test framework and clients on a seperate machine

Re: [HACKERS] Google SoC--Idea Request

2006-04-17 Thread Jim C. Nasby
On Sat, Apr 15, 2006 at 03:05:20PM -0400, Jonah H. Harris wrote: > All ideas welcome! I know it's not directly PostgreSQL related, but I'd love to see the dbt* code improved. Items on my wish-list: - make it easy to run the test framework and clients on a seperate machine from the database serv

Re: [HACKERS] Google SoC--Idea Request

2006-04-17 Thread Stephen Frost
* Jonah H. Harris ([EMAIL PROTECTED]) wrote: > I know we started a discussion a month or so ago regarding ideas for > SoC projects. However, after reading through the thread, I didn't see > us nail down any actual items. I got an email already for a good idea, actually, which is to work on having

Re: [HACKERS] Google SoC--Idea Request

2006-04-17 Thread Ned Lilly
OpenMFG has done some work on getting PostgreSQL working with the Drupal CMS and the Mantis bugtracker (and also integrating those two, btw). We're in contact with the respective projects about getting our patches worked in, but if anyone's keeping a tally, just wanted you to be aware. Regard

Re: [HACKERS] Google SoC--Idea Request

2006-04-16 Thread Dave Page
-Original Message- From: "Jonah H. Harris"<[EMAIL PROTECTED]> Sent: 15/04/06 20:06:27 To: "Pgsql Hackers" Subject: [HACKERS] Google SoC--Idea Request > As such, we need to quickly put together a list of oh, 15-20 midlevel > project ideas. Anot

Re: [HACKERS] Google SoC--Idea Request

2006-04-15 Thread Robert Treat
On Saturday 15 April 2006 19:25, Jonah H. Harris wrote: > On 4/15/06, Neil Conway <[EMAIL PROTECTED]> wrote: > > Doing the latter is a precondition for implementing the former in a > > reasonable way, I believe. > > > > > > BTW, these two web log entries summarizing Mono and Mozilla's > > experienc

Re: [HACKERS] Google SoC--Idea Request

2006-04-15 Thread Jonah H. Harris
On 4/15/06, Neil Conway <[EMAIL PROTECTED]> wrote: > Doing the latter is a precondition for implementing the former in a > reasonable way, I believe. > BTW, these two web log entries summarizing Mono and Mozilla's > experiences with SoC might make interesting reading: Thanks for the reading mate

Re: [HACKERS] Google SoC--Idea Request

2006-04-15 Thread Neil Conway
On Sat, 2006-04-15 at 21:24 +0100, Dave Page wrote: > one to allow a message to be sent with the notify, and one to move > from a table based design to shared mem/disk. Doing the latter is a precondition for implementing the former in a reasonable way, I believe. BTW, these two web log entries su

Re: [HACKERS] Google SoC--Idea Request

2006-04-15 Thread Dave Page
-Original Message- From: "Jonah H. Harris"<[EMAIL PROTECTED]> Sent: 15/04/06 20:06:27 To: "Pgsql Hackers" Subject: [HACKERS] Google SoC--Idea Request > As such, we need to quickly put together a list of oh, 15-20 midlevel > project ideas. There's

[HACKERS] Google SoC--Idea Request

2006-04-15 Thread Jonah H. Harris
Hey everyone, I know we started a discussion a month or so ago regarding ideas for SoC projects. However, after reading through the thread, I didn't see us nail down any actual items. As such, we need to quickly put together a list of oh, 15-20 midlevel project ideas. I'm sure we can pull some