Re: [GENERAL] Best practice on inherited tables

2013-05-18 Thread Chris Travers
In general, I find table inheritance most helpful when one wants to re-use interfaces over multiple independent tables. For example instead of a global notes table, a bunch of notes tables attached to things, but with centralized schema management. In general in these cases you want something ide

Re: [GENERAL] Best practice on inherited tables

2013-05-18 Thread Julian
On 17/05/13 22:46, Frank Lanitz wrote: > Hi folkes, > > I'm looking for a nice way to build this scenario: > I've got a lot of locations with some special types. For example I've > got workplaces, places like real laboratories and virtual places like > maybe parcel service. For each of the differe

Re: [GENERAL] Vacuum problem

2013-05-18 Thread S H
I confirmed that there is no bloating unfortunately. Did some experiment and it seems that connection open are always slow in case of vacuuming.. - Experiment done are as follows:-- Do frequent vacuuming.- Execute xx connections every min and close after one sec.- when vacuum is running connec

Re: [GENERAL] cal I pass arguments directly to final function in aggregates

2013-05-18 Thread Tom Lane
=?UTF-8?B?Tmlja2xhcyBBdsOpbg==?= writes: > I am trying to create an aggregate function. > One of the arguments is static and is not needed until the final function. > From the doc I see that the final function " must take a single > argument of typestate_data_type" > Is it not possible to just

[GENERAL] cal I pass arguments directly to final function in aggregates

2013-05-18 Thread Nicklas Avén
Hallo I am trying to create an aggregate function. One of the arguments is static and is not needed until the final function. From the doc I see that the final function " must take a single argument of typestate_data_type" Is it not possible to just pass this arguments directly to the final

Re: [GENERAL] Why does row estimation on nested loop make no sense to me

2013-05-18 Thread hubert depesz lubaczewski
Not sure if it helps, but it's apparently not a very rare thing. Quick analysis on data from explain.depesz.com showed that > 12% of plans with nested loop have such estimate. Couple of examples: http://explain.depesz.com/s/Qm4 http://explain.depesz.com/s/qmW http://explain.depesz.com/s/qnG http:

Re: [GENERAL] Regarding Postgres Plus Associate Certification

2013-05-18 Thread Raghavendra
On Fri, May 17, 2013 at 1:16 AM, Oscar Calderon < ocalde...@solucionesaplicativas.com> wrote: > Hi to everybody, i just wanna ask you if somebody that already has the > certification or if is studying to get it knows if there's a book (or a set > of books) that you recommend me that contains most