Re: [PERFORM]Is it possible to start two instances of postgresql?

2006-06-15 Thread Nis Jorgensen
[EMAIL PROTECTED] wrote: > both of the two database are live but use for two different web app. > my company don't want to spend more to buy a new server, so then I think of > to implement both under the same server and one instance.. > but then my superior don't want to do that way. > they want

Re: [PERFORM] 64-bit vs 32-bit performance ... backwards?

2006-06-13 Thread Nis Jorgensen
J. Andrew Rogers wrote: > We have been using PostgreSQL on Opteron servers almost since the > Opteron was first released, running both 32-bit and 64-bit versions of > Linux. Both 32-bit and 64-bit versions have been bulletproof for us, > with the usual stability I've become accustomed to with bot

Re: [PERFORM] Speedup hint needed, if available? :)

2006-05-31 Thread Nis Jorgensen
Mario Splivalo wrote: Hello again. I have to track user subscriptions to certain mailinglists, and I also need to track credits users have on those mailinglists. On one side I have procedures that add credits, on other side I have procedures that subtract available credits. Add/subtract is prett

Re: [HACKERS] [PERFORM] Big IN() clauses etc : feature proposal

2006-05-10 Thread Nis Jorgensen
Martijn van Oosterhout wrote: > On Wed, May 10, 2006 at 04:38:31PM +0200, PFC wrote: >> You need to do some processing to know how many rows the function >> would return. >> Often, this processing will be repeated in the function itself. >> Sometimes it's very simple (ie. the

Re: [PERFORM] Question about explain-command...

2006-05-10 Thread Nis Jorgensen
I will try answering your questions. Please note that I am a newbie myself. Clemens Eisserer wrote > All primary keys are indixed, and this is what explain tells me: > Unique (cost=15.67..16.69 rows=34 width=115) > -> Sort (cost=15.67..15.75 rows=34 width=115) > Sort Key: customer.em