Re: [GENERAL] Best practice on inherited tables

2013-05-19 Thread Frank Lanitz
Am 17.05.2013 21:21, schrieb Alfonso Afonso: > Hi Frank > > Although you are thinking in OOP, the SQL is itself one definition > model that you should not ignore and, IMHO, try to follow the > normalization statements. > > You can build a robust and normalized schema (table primarylocation , > ta

Re: [GENERAL] Best practice on inherited tables

2013-05-19 Thread Julian
On 19/05/13 13:02, Chris Travers wrote: > > I actually think that bringing some object-oriented principles into > database design can result in some very useful things, provided that one > remembers that applications are modelling behavior while databases are > modelling information (and so the tw

Re: [GENERAL] Best practice on inherited tables

2013-05-19 Thread Chris Travers
On Sun, May 19, 2013 at 4:44 AM, Julian wrote: > On 19/05/13 13:02, Chris Travers wrote: > > > > I actually think that bringing some object-oriented principles into > > database design can result in some very useful things, provided that one > > remembers that applications are modelling behavior

Re: [GENERAL] Deploying PostgreSQL on CentOS with SSD and Hardware RAID

2013-05-19 Thread Toby Corkindale
On 11/05/13 02:25, Merlin Moncure wrote: On Fri, May 10, 2013 at 11:11 AM, Evan D. Hoffman wrote: Not sure of your space requirements, but I'd think a RAID 10 of 8x or more Samsung 840 Pro 256/512 GB would be the best value. Using a simple mirror won't get you the reliability that you want sin

[GENERAL] C function fails afeter create extension but ok after reconnect

2013-05-19 Thread Stephen Woodbridge
Hi all, I have a C function that works fine in all cases except if I try to run it after create extension without reconnecting to the database. So this fails: createdb -U postgres -h localhost ttt psql -U postgres -h localhost ttt create extension postgis; create extension pgrouting; -- creat

Re: [GENERAL] Deploying PostgreSQL on CentOS with SSD and Hardware RAID

2013-05-19 Thread Toby Corkindale
On 13/05/13 11:23, David Boreham wrote: btw we deploy on CentOS6. The only things we change from the default are: 1. add "relatime,discard" options to the mount (check whether the most recent CentOS6 does this itself -- it didn't back when we first deployed on 6.0). While it is important to l

Re: [GENERAL] C function fails afeter create extension but ok after reconnect

2013-05-19 Thread Tom Lane
Stephen Woodbridge writes: > I have a C function that works fine in all cases except if I try to run > it after create extension without reconnecting to the database. There's not nearly enough info here to diagnose the problem, but if I had to bet I'd bet on a memory-management bug that just acc

Re: [GENERAL] Deploying PostgreSQL on CentOS with SSD and Hardware RAID

2013-05-19 Thread David Boreham
On 5/19/2013 7:19 PM, Toby Corkindale wrote: On 13/05/13 11:23, David Boreham wrote: btw we deploy on CentOS6. The only things we change from the default are: 1. add "relatime,discard" options to the mount (check whether the most recent CentOS6 does this itself -- it didn't back when we first