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 writes: > > > Are you saying most people like "Has OIDs: yes", or the idea of just > > > displaying _a_ line if there are OIDs? Based on default_with_oids,

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 Whil

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 tupl

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

[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 (clusters)

[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 us

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 wrote: > On Sun, Mar 9, 2014 at 5:28 PM, Wang, Jing 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 comes from the Postgresql TODO list. >>

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 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 Overflow activity, pi

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 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 pgsql-hackers mailing list (pgsql

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 > 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/ Ah

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 > > 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: > ht

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 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 the regression