Search Postgresql Archives

Re: Postgresql with max_connections=4096

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



With the last test I made, the database is swapping but in a very slow way... 100K every 10 minutes and that seems to not be a problem... in the sense that the server doesn't slow down...

Today I'll make other tests and let you know.

Thank you,
Denis


Scott Marlowe wrote:

On Wed, 2005-07-27 at 12:53, Jim C. Nasby wrote:
On Wed, Jul 27, 2005 at 04:46:56PM +0200, denis@xxxxxxxxxxx wrote:
I'm now testing with pg_pool installed on each apache frontend with 260 pg_pool preforked clients in each machine.

The database seems to work better. At least when it goes to swap it doesn't stop working...
Wait, are you saying your database server is swapping? You'll never get
any kind of performance if that's the case.

IF it swaps out unused code / data and leaves it, that's fine, but if
it's constantly swapping out then yeah, that's a VERY bad thing.



---------------------------(end of broadcast)---------------------------
TIP 9: In versions below 8.0, the planner will ignore your desire to
      choose an index scan if your joining column's datatypes do not
      match

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux