Re: [HACKERS] psql \d+ and oid display

2014-03-30 Thread Bruce Momjian
On Sat, Mar 29, 2014 at 06:33:39PM -0400, Bruce Momjian wrote: On Sat, Mar 29, 2014 at 06:16:19PM -0400, Tom Lane wrote: Bruce Momjian br...@momjian.us writes: Are you saying most people like Has OIDs: yes, or the idea of just displaying _a_ line if there are OIDs? Based on

Re: [HACKERS] MultiXactId error after upgrade to 9.3.4

2014-03-30 Thread Stephen Frost
All, * Stephen Frost (sfr...@snowman.net) wrote: Looks like we might not be entirely out of the woods yet regarding MultiXactId's. After doing an upgrade from 9.2.6 to 9.3.4, we saw the following: ERROR: MultiXactId 6849409 has not been created yet -- apparent wraparound While

Re: [HACKERS] MultiXactId error after upgrade to 9.3.4

2014-03-30 Thread Stephen Frost
* Stephen Frost (sfr...@snowman.net) wrote: I have the pre-upgrade database and can upgrade/rollback/etc that pretty easily. Note that the table contents weren't changed during the upgrade, of course, and so the 9.2.6 instance has HEAP_XMAX_IS_MULTI set while t_xmax is 6849409 for the tuple

Re: [HACKERS] Securing make check (CVE-2014-0067)

2014-03-30 Thread Christoph Berg
Re: Noah Misch 2014-03-30 20140330014531.ge170...@tornado.leadboat.com On Sat, Mar 29, 2014 at 10:04:55AM +0100, Christoph Berg wrote: Fwiw, to relocate the pg_regress socket dir, there is already the possibility to run make check EXTRA_REGRESS_OPTS=--host=/tmp. (With the pending fix I sent

[HACKERS] GSoC 2014 proposal

2014-03-30 Thread Иван Парфилов
Hello, hackers! This is my GSoC proposal. *Short description:* Cluster analysis or clustering is the task of grouping a set of objects in such a way that objects in the same group (called a cluster) are more similar (in some sense or another) to each other than to those in other groups

[HACKERS] GSoC project suggestion: PIVOT ?

2014-03-30 Thread Craig Ringer
Hi all The thought just occurred to me that a PIVOT feature might be a respectable GSoC project. tablefunc/crosstab works, but it's very clumsy to use, and difficult to consume the data from. Going by Stack Overflow activity, pivot/crosstab is second only to upsert when it comes to things that

Re: [HACKERS] issue log message to suggest VACUUM FULL if a table is nearly empty

2014-03-30 Thread Amit Kapila
On Wed, Mar 26, 2014 at 11:32 AM, Robert Haas robertmh...@gmail.com wrote: On Sun, Mar 9, 2014 at 5:28 PM, Wang, Jing ji...@fast.au.fujitsu.com wrote: Enclosed is the patch to implement the requirement that issue log message to suggest VACUUM FULL if a table is nearly empty. The requirement

Re: [HACKERS] GSoC project suggestion: PIVOT ?

2014-03-30 Thread Fabrízio de Royes Mello
On Sun, Mar 30, 2014 at 11:30 PM, Craig Ringer cr...@2ndquadrant.com wrote: Hi all The thought just occurred to me that a PIVOT feature might be a respectable GSoC project. tablefunc/crosstab works, but it's very clumsy to use, and difficult to consume the data from. Going by Stack

Re: [HACKERS] GSoC project suggestion: PIVOT ?

2014-03-30 Thread Michael Paquier
On Mon, Mar 31, 2014 at 1:36 PM, Fabrízio de Royes Mello fabriziome...@gmail.com wrote: It's a nice idea, but the deadline to students send a proposal was 21th April. 21st of March. All the details are here: http://www.postgresql.org/developer/summerofcode/ -- Michael -- Sent via

Re: [HACKERS] GSoC project suggestion: PIVOT ?

2014-03-30 Thread Craig Ringer
On 03/31/2014 12:49 PM, Michael Paquier wrote: On Mon, Mar 31, 2014 at 1:36 PM, Fabrízio de Royes Mello fabriziome...@gmail.com wrote: It's a nice idea, but the deadline to students send a proposal was 21th April. 21st of March. All the details are here:

Re: [HACKERS] GSoC project suggestion: PIVOT ?

2014-03-30 Thread Fabrízio de Royes Mello
Em segunda-feira, 31 de março de 2014, Michael Paquier michael.paqu...@gmail.com escreveu: On Mon, Mar 31, 2014 at 1:36 PM, Fabrízio de Royes Mello fabriziome...@gmail.com javascript:; wrote: It's a nice idea, but the deadline to students send a proposal was 21th April. 21st of March. All

Re: [HACKERS] B-Tree support function number 3 (strxfrm() optimization)

2014-03-30 Thread Peter Geoghegan
On Wed, Mar 26, 2014 at 8:08 PM, Peter Geoghegan p...@heroku.com wrote: The API I envisage is a new support function 3 that operator class authors may optionally provide. I've built a prototype patch, attached, that extends SortSupport and tuplesort to support poor man's normalized keys. All