-BEGIN PGP SIGNED MESSAGE-
Could anyone explain about the max_connections in postgres?
We ran into the connection limit on one of our production servers. One reason
is that we have more apps that use postgres running on it (RT3 and Webcollab
were added not long ago). Webcollab, for inst
Hi,I have this server that I use as db database. It's decent box Ubuntu, 2GB,
AMD Barton 2.8Gb L2 2Mb. DB version is 7.4.7 - that version was the only one
available at that time. I have it for about 2 years in similar configuration.
Lately I've notices that a pack of postmaster(4-22) process
Anyone ?From: [EMAIL PROTECTED]: [EMAIL PROTECTED]: [GENERAL] Postmaster
processes taking all the CPUDate: Fri, 8 Jun 2007 13:23:00 -0500
Hi,I have this server that I use as db server. It's decent box Ubuntu, 2GB, AMD
Barton 2.8Gb L2 2Mb. DB version is 7.4.7 - that version was the
On Fri, Jun 08, 2007 at 03:20:28PM -0500, MC Moisei wrote:
>
> pack of postmaster(4-22) processes ran by postgres user are taking
> over almost all the CPU.
What else is the box doing? If it doesn't have any other work to do,
why shouldn't postgres use the CPU time? (This is a way of saying,
"
Have you done a full vacuum and not just a reqular vacuum?
- Ericson Smith
Developer
http://www.funadvice.com
On 6/8/07, Andrew Sullivan <[EMAIL PROTECTED]> wrote:
On Fri, Jun 08, 2007 at 03:20:28PM -0500, MC Moisei wrote:
>
> pack of postmaster(4-22) processes ran by postgres user are taking
>
n 2007
16:35:40 -0400> From: [EMAIL PROTECTED]> To: pgsql-general@postgresql.org>
Subject: Re: [GENERAL] Postmaster processes taking all the CPU> > On Fri, Jun
08, 2007 at 03:20:28PM -0500, MC Moisei wrote:> > > > pack of postmaster(4-22)
processes ran by postgres user a
I did that remotely, thru the psqladmin. How do I do it from that box ?> Date:
Fri, 8 Jun 2007 16:41:57 -0400> From: [EMAIL PROTECTED]> Subject: Re: [GENERAL]
Postmaster processes taking all the CPU> CC: pgsql-general@postgresql.org> >
Have you done a full vacuum and not jus
problems.
Hope this provide more insight.
MC
> Date: Fri, 8 Jun 2007 16:35:40 -0400
> From: [EMAIL PROTECTED]
> To: pgsql-general@postgresql.org
> Subject: Re: [GENERAL] Postmaster processes taking all the CPU
>
> On Fri, Jun 08, 2007 at 03:20:28PM -0500, MC Moisei wrote:
>
First, your mail is coming through really garbled. Maybe you need to
add some linebreaks or something? Anyway
On Fri, Jun 08, 2007 at 03:58:40PM -0500, MC Moisei wrote:
>
> I'm not sure I understand the question. What else runs on it ?I
> have an Apache that fronts a Tomcat (Java Enterprise App
Marc
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of MC Moisei
Sent: Friday, June 08, 2007 11:11 PM
To: pgsql-general@postgresql.org
Subject: Re: [GENERAL] Postmaster processes taking all the CPU
I did that remotely, thru the psqladmin. How do I do it from tha
On Fri, Jun 08, 2007 at 05:11:44PM -0400, Ericson Smith wrote:
>
> Also, if you're updating that table frequently, lots of dead tuples
> will remain in there if you don't do a VACUUM FULL regularly.
No, they won't. No well-tuned postgres installation has needed
VACUUM FULL in a long time. VACUU
l@postgresql.org> Subject: Re: [GENERAL] Postmaster
processes taking all the CPU> > First, your mail is coming through really
garbled. Maybe you need to> add some linebreaks or something? Anyway> > On
Fri, Jun 08, 2007 at 03:58:40PM -0500, MC Moisei wrote:> > > > I
On Fri, Jun 08, 2007 at 05:08:26PM -0500, MC Moisei wrote:
> Yes all the connection are coming from within the box so no network
> latency.Well, isn't the swap can be because too many process
> postmaster are requiring more memory.
But why are they requring more memory? Do you maybe have (e.g.)
times
more traffic without problems.Hope this provide more insight.MC> Date: Fri, 8
Jun 2007 16:35:40 -0400> From: [EMAIL PROTECTED]> To:
pgsql-general@postgresql.org> Subject: Re: [GENERAL] Postmaster processes
taking all the CPU> > On Fri, Jun 08, 2007 at 03:20:28PM -0500, MC M
w what you
think.MCPs.I heard people complaining about my posting format. I use the
hotmail web interface and the way they send the message is beyond my control
;-|> Date: Fri, 8 Jun 2007 18:13:02 -0400> From: [EMAIL PROTECTED]> To:
pgsql-general@postgresql.org> Subject: Re: [GENERAL] Postma
I promised that I will get back to the group with the reason. Well, of
course was a query :). I do use a search engine file system
based(lucene) that will take any desired entity saved into the database
and find the primary keys and then do a select * from entity where id is
in (:ids)If I
ROTECTED]; pgsql-general@postgresql.org> Subject: Re: [GENERAL]
Postmaster processes taking all the CPU> From: [EMAIL PROTECTED]> > > > I
promised that I will get back to the group with the reason. Well, of > >
course was a query :). I do use a search engine file system >
17 matches
Mail list logo