Search Postgresql Archives

Re: Are indexes blown?

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

 



On Sat, Feb 16, 2008 at 12:38:04PM +0800, Phoenix Kiula wrote:

> My hosting provider tells me that the Postgresql server is taking up a
> lot of memory but I've been running the same db with the same config
> for over 2 years. Yes we have been growing but what happened in the
> last 3 days to warrant a sudden spike in memory consumption??!!

Maybe your database has just grown big enough that it no longer all fits in
memory, and your disk hardware is flakey?  Or maybe the disk is flakey?  Or
maybe the data itself is now different enough that the planner is changing
what it's doing?  There are lots of explanations.

But I have to agree with someone upthread: you have to stop the crashes and
clean the system up before you try to debug this stuff.  Your problem is
likely there.

A

---------------------------(end of broadcast)---------------------------
TIP 6: explain analyze is your friend

[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