[GENERAL] Implementing DB2's distinct types

2013-04-21 Thread Thomas Kellerer
Hi, I recently stumbled upon a really cool feature in DB2: distinct types. DB2 lets you define your own types (just as Postgres) but with the added benefit that you can mark them such that they are _not_ comparable, e.g. to avoid comparing apples to oranges. Take the following example:

Re: [GENERAL] Implementing DB2's distinct types

2013-04-21 Thread Atri Sharma
Sent from my iPad On 21-Apr-2013, at 16:47, Thomas Kellerer spam_ea...@gmx.net wrote: Hi, I recently stumbled upon a really cool feature in DB2: distinct types. DB2 lets you define your own types (just as Postgres) but with the added benefit that you can mark them such that they are

Re: [GENERAL] Roadmap for Postgres on AIX

2013-04-21 Thread Stefan Kaltenbrunner
On 04/17/2013 07:45 PM, Thomas Munro wrote: On 19 March 2013 01:00, Tom Lane t...@sss.pgh.pa.us mailto:t...@sss.pgh.pa.us wrote: Wasim Arif wasima...@gmail.com mailto:wasima...@gmail.com writes: What is the road map for Postgres on the AIX platform? I understand that the

Re: [GENERAL] Memory usage after upgrade to 9.2.4

2013-04-21 Thread Tomas Vondra
Hi, we got a report of (probably) the same issue on a local mailing list. Maybe it'll help in finding the root cause, so I'm resending the info here too. On 21.4.2013 01:19, Adrian Klaver wrote: On 04/20/2013 04:08 PM, Daniel Cristian Cruz wrote: I think I didn't make it clear: the session

Re: [GENERAL] Memory usage after upgrade to 9.2.4

2013-04-21 Thread Tom Lane
Tomas Vondra t...@fuzzy.cz writes: I do have a log with the memory context info printed after the OOM killed the session - see it attached. The only thing that seems rather bloated is the CacheMemoryContext, which seems to be because the backend has cached info about several thousand tables and

Re: [GENERAL] Memory usage after upgrade to 9.2.4

2013-04-21 Thread Daniel Cristian Cruz
2013/4/21 Tom Lane t...@sss.pgh.pa.us Tomas Vondra t...@fuzzy.cz writes: I do have a log with the memory context info printed after the OOM killed the session - see it attached. The only thing that seems rather bloated is the CacheMemoryContext, which seems to be because the backend has

Re: [GENERAL] Memory usage after upgrade to 9.2.4

2013-04-21 Thread Adrian Klaver
On 04/20/2013 05:19 PM, Daniel Cristian Cruz wrote: Copying to list to fill in blanks. 2013/4/20 Adrian Klaver adrian.kla...@gmail.com mailto:adrian.kla...@gmail.com On 04/20/2013 04:30 PM, Daniel Cristian Cruz wrote: 2013/4/20 Adrian Klaver adrian.kla...@gmail.com

Re: [GENERAL] Memory usage after upgrade to 9.2.4

2013-04-21 Thread Adrian Klaver
On 04/21/2013 06:37 AM, Daniel Cristian Cruz wrote: 2013/4/21 Tom Lane t...@sss.pgh.pa.us mailto:t...@sss.pgh.pa.us Tomas Vondra t...@fuzzy.cz mailto:t...@fuzzy.cz writes: I do have a log with the memory context info printed after the OOM killed the session - see it attached.

Re: [GENERAL] Memory usage after upgrade to 9.2.4

2013-04-21 Thread Tomas Vondra
On 21.4.2013 15:14, Tom Lane wrote: Tomas Vondra t...@fuzzy.cz writes: I do have a log with the memory context info printed after the OOM killed the session - see it attached. The only thing that seems rather bloated is the CacheMemoryContext, which seems to be because the backend has

Re: [GENERAL] Memory usage after upgrade to 9.2.4

2013-04-21 Thread Daniel Cristian Cruz
2013/4/21 Adrian Klaver adrian.kla...@gmail.com On 04/21/2013 06:37 AM, Daniel Cristian Cruz wrote: 2013/4/21 Tom Lane t...@sss.pgh.pa.us mailto:t...@sss.pgh.pa.us Tomas Vondra t...@fuzzy.cz mailto:t...@fuzzy.cz writes: I do have a log with the memory context info printed after

Re: [GENERAL] Memory usage after upgrade to 9.2.4

2013-04-21 Thread Adrian Klaver
On 04/21/2013 07:50 AM, Daniel Cristian Cruz wrote: 2013/4/21 Adrian Klaver adrian.kla...@gmail.com mailto:adrian.kla...@gmail.com On 04/21/2013 06:37 AM, Daniel Cristian Cruz wrote: 2013/4/21 Tom Lane t...@sss.pgh.pa.us mailto:t...@sss.pgh.pa.us

Re: [GENERAL] Memory usage after upgrade to 9.2.4

2013-04-21 Thread Daniel Cristian Cruz
2013/4/21 Adrian Klaver adrian.kla...@gmail.com On 04/21/2013 07:50 AM, Daniel Cristian Cruz wrote: 2013/4/21 Adrian Klaver adrian.kla...@gmail.com mailto:adrian.klaver@gmail.**com adrian.kla...@gmail.com On 04/21/2013 06:37 AM, Daniel Cristian Cruz wrote: 2013/4/21 Tom

Fwd: [GENERAL] Memory usage after upgrade to 9.2.4

2013-04-21 Thread Daniel Cristian Cruz
Sorry, I answered to Tomas only... -- Forwarded message -- From: Daniel Cristian Cruz danielcrist...@gmail.com Date: 2013/4/21 Subject: Re: [GENERAL] Memory usage after upgrade to 9.2.4 To: Tomas Vondra t...@fuzzy.cz I had the same environment, almost: 2013/4/21 Tomas Vondra

Fwd: [GENERAL] Memory usage after upgrade to 9.2.4

2013-04-21 Thread Daniel Cristian Cruz
And this one only to Adrian. Sorry to all. -- Forwarded message -- From: Daniel Cristian Cruz danielcrist...@gmail.com Date: 2013/4/20 Subject: Re: [GENERAL] Memory usage after upgrade to 9.2.4 To: Adrian Klaver adrian.kla...@gmail.com 2013/4/20 Adrian Klaver

Re: [GENERAL] Memory usage after upgrade to 9.2.4

2013-04-21 Thread Adrian Klaver
On 04/21/2013 09:29 AM, Daniel Cristian Cruz wrote: 2013/4/21 Adrian Klaver adrian.kla...@gmail.com mailto:adrian.kla...@gmail.com 1) Major upgrade from 9.1.4 to 9.2.4. Used pg_upgrade Tested on VM with 9.2.4 and no problems. Same machine used for production server