Re: [GENERAL] Schemas vs partitioning vs multiple databases for archiving

2012-08-19 Thread Gavin Flower
On 19/08/12 17:50, Chris Travers wrote: On Sat, Aug 18, 2012 at 9:30 PM, Gavin Flower mailto:gavinflo...@archidevsys.co.nz>> wrote: On 18/08/12 20:05, Bartel Viljoen wrote: [...] I’m in the design faze of a new GUI and DB layout, what are my options. [...] I thin

Re: [GENERAL] Schemas vs partitioning vs multiple databases for archiving

2012-08-18 Thread Chris Travers
On Sat, Aug 18, 2012 at 9:30 PM, Gavin Flower wrote: > On 18/08/12 20:05, Bartel Viljoen wrote: > > [...] > > > I’m in the design faze of a new GUI and DB layout, what are my options. > > [...] > I think you meant phase! > (Spell checkers can be quite stupid!) > Could be worse See the

Re: [GENERAL] Schemas vs partitioning vs multiple databases for archiving

2012-08-18 Thread Gavin Flower
On 18/08/12 20:05, Bartel Viljoen wrote: [...] I'm in the design faze of a new GUI and DB layout, what are my options. [...] I think you meant phase! (Spell checkers can be quite stupid!) Cheers, Gavin

Re: [GENERAL] Schemas vs partitioning vs multiple databases for archiving

2012-08-18 Thread Jeff Janes
On Sat, Aug 18, 2012 at 1:05 AM, Bartel Viljoen wrote: > Dear mailing list. > > ** ** > > My current application make use of partitioning by creating a new child > table which holds transaction records for every month. I’ve notice that > after a couple of months depending on the hardware at s

Re: [GENERAL] Schemas vs partitioning vs multiple databases for archiving

2012-08-18 Thread Tom Lane
Craig Ringer writes: > On 08/18/2012 04:05 PM, Bartel Viljoen wrote: >> My current application make use of partitioning by creating a new child >> table which holds transaction records for every month. I’ve notice that >> after a couple of months depending on the hardware at some of our >> clients

Re: [GENERAL] Schemas vs partitioning vs multiple databases for archiving

2012-08-18 Thread Chris Travers
On Sat, Aug 18, 2012 at 1:05 AM, Bartel Viljoen wrote: > Dear mailing list. > > ** ** > > My current application make use of partitioning by creating a new child > table which holds transaction records for every month. I’ve notice that > after a couple of months depending on the hardware at s

Re: [GENERAL] Schemas vs partitioning vs multiple databases for archiving

2012-08-18 Thread Craig Ringer
On 08/18/2012 04:05 PM, Bartel Viljoen wrote: Dear mailing list. My current application make use of partitioning by creating a new child table which holds transaction records for every month. I’ve notice that after a couple of months depending on the hardware at some of our clients the inserts b

Re: [GENERAL] Schemas vs partitioning vs multiple databases for archiving

2012-08-18 Thread John R Pierce
On 08/18/12 1:05 AM, Bartel Viljoen wrote: Dear mailing list. My current application make use of partitioning by creating a new child table which holds transaction records for every month. I’ve notice that after a couple of months depending on the hardware at some of our clients the inserts