Re: [Ledger-smb-devel] Persistent connections to database?

2007-11-19 Thread Chris Travers
BTW, one concrete recommendation I would make on this list for anyone who wants to look at helping businesses use LedgerSMB in environments where you have more than a few concurrent connections is that the pgsql-perform and pgsql-general email lists (see www.postgresql.org) are really great places

Re: [Ledger-smb-devel] Persistent connections to database?

2007-11-19 Thread Chris Travers
Just to clarify this discussion, I think Joshua's points were somewhat misunderstood. They are mostly important when you are running a dedicated database server and/or expect to have a large number of concurrent requests. On Nov 19, 2007 3:54 PM, Gene Ets <[EMAIL PROTECTED]> wrote: > Well as it

Re: [Ledger-smb-devel] Persistent connections to database?

2007-11-19 Thread Gene Ets
Joshua D. Drake wrote: > As far as your conf... it is a bloody mess :). It appears that someone > just installed PostgreSQL without actually reviewing the configuration > files. No offense, but that is a seriously bad idea with something as > critical as your accounting system. Well as it happens,

[Ledger-smb-devel] Proposed New Name for DB access architecture

2007-11-19 Thread Chris Travers
Hi all; I have been thinking about various objections to calling our stored-proc-discovery-based relation<->object interface an ORM. The basic thing is that we are not really doing ORM stuff even though we are tackling the same impedance mismatch issues that ORMS have to deal with. Also, I suspe

Re: [Ledger-smb-devel] Persistent connections to database?

2007-11-19 Thread Joshua D. Drake
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 On Fri, 16 Nov 2007 19:09:53 -0600 Charley Tiggs <[EMAIL PROTECTED]> wrote: > > Bingo :)... > > > > increase your max_fsm_pages to 25 > > > > What about the rest of your conf (please attach)... shared_memory, > > work_mem, fsync, wal_sync_metho