Re: [PERFORM] Very specific server situation

2007-04-28 Thread Mauro N. Infantino
Tom, Thank you very much for your suggestions. > -Original Message- > From: Tom Lane [mailto:[EMAIL PROTECTED] > > Have you checked to make sure the query plans are reasonable? I've attached the main query and its explain plan. I can't find a way to improve it. Does it make any diff

Re: [PERFORM] Very specific server situation

2007-04-27 Thread Tom Lane
"Mauro N. Infantino" <[EMAIL PROTECTED]> writes: > What we basically have is a site where each user has a box with links to > other randomly selected users. Whenever a box from a user is shown, a SPs is > executed: a credit is added to that user and a credit is substracted from > the accounts of th

[PERFORM] Very specific server situation

2007-04-27 Thread Mauro N. Infantino
Hi, We're facing some perfomance problems with the database for a web site with very specific needs. First of all, we're using version 8.1 in a server with 1GB of RAM. I know memory normally should be more, but as our tables are not so big (as a matter of fact, they are small) I think the solution