[GENERAL] Implementing DB2's "distinct" types

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

Re: [GENERAL] Implementing DB2's "distinct" types

Sent from my iPad On 21-Apr-2013, at 16:47, Thomas Kellerer 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 _not_ comparab

Re: [GENERAL] Roadmap for Postgres on AIX

On 04/17/2013 07:45 PM, Thomas Munro wrote: > On 19 March 2013 01:00, Tom Lane > wrote: > > Wasim Arif mailto:wasima...@gmail.com>> writes: > > What is the road map for Postgres on the AIX platform? I > understand that > > the pg build farm contains an A

Re: [GENERAL] Memory usage after upgrade to 9.2.4

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 m

Re: [GENERAL] Memory usage after upgrade to 9.2.4

Tomas Vondra 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 indexes. G

Re: [GENERAL] Memory usage after upgrade to 9.2.4

2013/4/21 Tom Lane > Tomas Vondra 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

Re: [GENERAL] Memory usage after upgrade to 9.2.4

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

Re: [GENERAL] Memory usage after upgrade to 9.2.4

On 04/21/2013 06:37 AM, Daniel Cristian Cruz wrote: 2013/4/21 Tom Lane mailto:t...@sss.pgh.pa.us>> Tomas Vondra 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. The only thing that seems

Re: [GENERAL] Memory usage after upgrade to 9.2.4

On 21.4.2013 15:14, Tom Lane wrote: > Tomas Vondra 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

Re: [GENERAL] Memory usage after upgrade to 9.2.4

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

Re: [GENERAL] Memory usage after upgrade to 9.2.4

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

Re: [GENERAL] Memory usage after upgrade to 9.2.4

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

Fwd: [GENERAL] Memory usage after upgrade to 9.2.4

Sorry, I answered to Tomas only... -- Forwarded message -- From: Daniel Cristian Cruz Date: 2013/4/21 Subject: Re: [GENERAL] Memory usage after upgrade to 9.2.4 To: Tomas Vondra I had the same environment, almost: 2013/4/21 Tomas Vondra > > 2) What are the hardware specs fo

Fwd: [GENERAL] Memory usage after upgrade to 9.2.4

And this one only to Adrian. Sorry to all. -- Forwarded message -- From: Daniel Cristian Cruz Date: 2013/4/20 Subject: Re: [GENERAL] Memory usage after upgrade to 9.2.4 To: Adrian Klaver 2013/4/20 Adrian Klaver > On 04/20/2013 04:30 PM, Daniel Cristian Cruz wrote: > >> >>

Re: [GENERAL] Memory usage after upgrade to 9.2.4

On 04/21/2013 09:29 AM, Daniel Cristian Cruz wrote: 2013/4/21 Adrian Klaver 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 9.1.4 and 9.2.4 When