Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtp (Exim 4.80) (envelope-from ) id 1YTz2j-00076J-RN for pgsql-students@arkaria.postgresql.org; Fri, 06 Mar 2015 20:40:21 +0000 Received: from localhost ([127.0.0.1] helo=postgresql.org) by malur.postgresql.org with smtp (Exim 4.80) (envelope-from ) id 1YTz2j-000823-BK for pgsql-students@arkaria.postgresql.org; Fri, 06 Mar 2015 20:40:21 +0000 Received: from makus.postgresql.org ([2001:4800:1501:1::229]) by malur.postgresql.org with esmtps (TLS1.2:DHE_RSA_AES_256_CBC_SHA256:256) (Exim 4.80) (envelope-from ) id 1YTz2i-00081r-Nj for pgsql-students@postgresql.org; Fri, 06 Mar 2015 20:40:20 +0000 Received: from tamriel.snowman.net ([2001:4830:167b::11]) by makus.postgresql.org with esmtp (Exim 4.80) (envelope-from ) id 1YTz2f-0000mF-5W for pgsql-students@postgresql.org; Fri, 06 Mar 2015 20:40:18 +0000 Received: by tamriel.snowman.net (Postfix, from userid 1000) id 7B8355F79F; Fri, 6 Mar 2015 15:40:16 -0500 (EST) Date: Fri, 6 Mar 2015 15:40:16 -0500 From: Stephen Frost To: Camelia C Cc: pgsql-students@postgresql.org Subject: Re: Fwd: [GSoC] Optimization tasks Message-ID: <20150306204016.GW29780@tamriel.snowman.net> References: MIME-Version: 1.0 Content-Type: multipart/signed; micalg=pgp-sha512; protocol="application/pgp-signature"; boundary="RBD83sV6py9qOE/b" Content-Disposition: inline In-Reply-To: X-Editor: Vim http://www.vim.org/ X-Info: http://www.snowman.net X-Operating-System: Linux/3.13.0-45-generic (x86_64) X-Uptime: 15:38:25 up 43 days, 20:27, 12 users, load average: 0.14, 0.21, 0.22 User-Agent: Mutt/1.5.21 (2010-09-15) X-Pg-Spam-Score: -1.9 (-) List-Archive: List-Help: List-ID: List-Owner: List-Post: List-Subscribe: List-Unsubscribe: X-Mailing-List: pgsql-students Precedence: bulk Sender: pgsql-students-owner@postgresql.org --RBD83sV6py9qOE/b Content-Type: text/plain; charset=us-ascii Content-Disposition: inline Content-Transfer-Encoding: quoted-printable Camelia, While that provides a guideline for what you'll want to include in your proposal, I believe you have some amount of freedom both in how much you cover each of those topic areas and the ordering of them. You are also welcome to include any other information which is relevant and supports your proposal. Thanks! Stephen * Camelia C (camelia13c@gmail.com) wrote: > Hello, >=20 > For my second question, I guess that [1] provides the information of the > expected parts of the project proposal. >=20 > However, I expect some feedback from your part about the topic chosen > before I jump into writing the project proposal. >=20 > Thanks! >=20 > Have a nice week-end, > Camelia >=20 > [1] http://www.postgresql.org/developer/summerofcode/#proposals >=20 >=20 > ---------- Forwarded message ---------- > From: Camelia C > Date: Thu, Mar 5, 2015 at 3:54 AM > Subject: [GSoC] Optimization tasks > To: pgsql-students@postgresql.org >=20 >=20 > Hello, >=20 > My name is Camelia, I carry out Doctoral/PhD research in the field of > database query processing and I'd like to contribute with PostgreSQL > optimization tasks during this year's GSoC: >=20 > - Optimization- add to the join removal code the ability to remove joi= ns > to tables when the join is on a foreign key column (where all entries = must > exist in the parent anyway) > - Optimization- Check the set of conditionals on a WHERE clause against > CHECK constraints on the table being queried and remove any conditiona= ls > which *must* be true due to the CHECK constraints >=20 > and others that may appear interesting along my review of the source code. >=20 > I'm very excited about this opportunity and I hope that the results will = be > as good! >=20 > Will the aforementioned subjects be open for work or do other committers > have them under work already? > Do you have a specific template for the project proposal? >=20 > Thank you very much! >=20 > Best regards, > Camelia --RBD83sV6py9qOE/b Content-Type: application/pgp-signature; name="signature.asc" Content-Description: Digital signature -----BEGIN PGP SIGNATURE----- Version: GnuPG v1 iQIcBAEBCgAGBQJU+hCwAAoJEO1sijiDR2RVLiYQAJvQYefOS6v7/3t2XsHNf8yF 3cDMrEAHn2OP5PSVtDwNXszZhxbniblx4inu8WKJou8QpcgNio931FGjZTWwqqwJ E0SzlUFMUJC9eQMDNyOBvynVKPjTgb9fLr5Vg4W6qtBva9hjl7UYOXKhEKtzLwPn IOH8kLHBrgxDGijgqU1nNm4ba1wq1qA/YCfzgdsBSYA4o/KMgslyDDWcDWoThD14 Amp608fhqj9fJswP1pgqzUw9mZ0+gPPIBsdrvE42DplGKEvDSIjXnP6DXw7hf7+a gcrOFUpWZ73hQ8+cg4L/HfpFPZdgvTE+C7Mx7VmxwoYGfYIx9ldmIjoMwlWKGLhL U/aE/2VVWJ7wWZKiyzDsx3k9tPR+xCAd09P/WzXlbseISQVEmRTFKbGKkeIpyJ3x yajLuPx9gsbwXhIC5spQvYEIv5vQNBLNR6QRQTg51mlhQb1iFTCRX59ZKgwFVIbq 9XzPqUKRtRBTXrnQgk4AadHQ56WsDCiAlAVBaCVu50tsQV5i+k2ncVjWfSDG7VtE Jg7WnBvCvmENntFtQoX1jBSq9kdfq2xBIDPR682uJM/4HHHAmLxg3Oz+EFDVqBdY Sj5A5mbpEwZKz3w2g3LngE1lZTqxOQjhDXtYel2OXujUw69cud34NJvOARdJXC1d YtMrP4ImqtYUx6P+isX3 =u5xy -----END PGP SIGNATURE----- --RBD83sV6py9qOE/b--