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

2012-08-20 Thread Gavin Flower
On 19/08/12 17:50, Chris Travers wrote: On Sat, Aug 18, 2012 at 9:30 PM, Gavin Flower gavinflo...@archidevsys.co.nz 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

[GENERAL] Schemas vs partitioning vs multiple databases for archiving

2012-08-18 Thread Bartel Viljoen
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 become very slow. The reason memory. I don't

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

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

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 bar...@ncc.co.za 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

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

2012-08-18 Thread Tom Lane
Craig Ringer ring...@ringerc.id.au 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

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 bar...@ncc.co.za 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

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 Chris Travers
On Sat, Aug 18, 2012 at 9:30 PM, Gavin Flower 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 think you meant phase! (Spell checkers can be quite stupid!) Could