[PERFORM] Keeping processes open for re-use

2006-11-09 Thread Hilary Forbes
rt up time for a process must add to their perceived response time. Thanks Hilary Hilary Forbes DMR Limited (UK registration 01134804) A DMR Information and Technology Group company (www.dmr.co.uk) Direct tel 01689 889950 Fax 01689 860330 DMR is a UK registered trade mark of DMR Limited **

[PERFORM] Slow update

2005-09-12 Thread Hilary Forbes
uery being driveb by tableB and it is taking forever. Surely I must be able to force the system to read down tableB in preference to reading down tableA? (Please don't ask why tableA and tableB are not amalgamated - that's another story altogether!!!) Many thanks in advance Hilary H

[PERFORM] Processors vs Memory

2003-10-22 Thread Hilary Forbes
loads of memory. The OS is Red Hat Linux. How long is a piece of string I guess but all comments welcome! TAI Hilary Hilary Forbes - DMR Computer Limited: http://www.dmr.co.uk/ Direct line: 01689 889950 Switchboard: (44) 1689 86 Fax: (44) 1689 860330 E-mail: [

Re: [PERFORM] count(*) slow on large tables

2003-10-03 Thread Hilary Forbes
.ntlug.org/~cbbrowne/finances.html >> Rules of the Evil Overlord #74. "When I create a multimedia >> presentation of my plan designed so that my five-year-old advisor can >> easily understand the details, I will not label the disk "Project >> Ove

Fwd: Re: [PERFORM] postgresql.conf

2003-08-05 Thread Hilary Forbes
mistake of putting Mr Gates firewall in between the two to add to my woes!!) Looking forward to seeing the outcome of your documentation immensely. Many thanks Hilary Hilary Forbes - DMR Computer Limited: http://www.dmr.co.uk/ Direct line: 01689 889950 Switchboard: (44) 16

[PERFORM] Config file problem

2003-07-08 Thread Hilary Forbes
o say I've restored the default postgresql.conf file and am ok) :-( Obviously I've fouled up somewhere - advice awaited :-) As a point of interest, I searched the documentation fo pg_recvbuf and the search returned no results. Thanks Hilary Hilary Forbes - DMR Comp

[PERFORM] Version 7 question

2003-07-01 Thread Hilary Forbes
being written about later versions I suspect that this is far too low. Would I be fairly safe in making the no of shared buffers larger? Also is there an equivalent of effective_cache_size that I can set for version 7? Many thanks in advance Hilary Hilary Forbes - DMR Computer Li

Re: [PERFORM] Performance advice

2003-06-25 Thread Hilary Forbes
cumentation? Areas of >confusion? Was it difficult to find the information in question, or was >it simply unavailable? > >-- >Rod Taylor <[EMAIL PROTECTED]> > >PGP Key: http://www.rbt.ca/rbtpub.asc Hilary Forbes - DMR Computer Limited: http://www.dmr.co.uk