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 >
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
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
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
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.)
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: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
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
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
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:
>
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
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
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
>
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,
"
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 only o
15 matches
Mail list logo
