Talk About Network

Google


Register and Login
Nick
Password
Register create new account Sign up is FREE and you can post replies, new topics, bookmark posts and more!
Recover lost password


Data Bases > Pgsql Performance > two memory-cons...
Latest [ Topics | Posts ] Archive Post A New Topic Post a Reply
<< Topic < Post Post 1 of 21 Topic 4044 of 4159
 Post > Topic >>

two memory-consuming postgres processes

by deliverable@[EMAIL PROTECTED] (Alexy Khrabrov) May 2, 2008 at 12:24 PM

Greetings -- I have an UPDATE query updating a 100 million row table,  
and allocate enough memory via shared_buffers=1500MB.  However, I see  
two processes in top, the UPDATE process eating about 850 MB and the  
writer process eating about 750 MB.  The box starts paging.   Why is  
there the writer taking almost as much space as the UPDATE, and how  
can I shrink it?

Cheers,
Alexy

-- 
Sent via pgsql-performance mailing list (pgsql-performance@[EMAIL PROTECTED]
)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-performance




 21 Posts in Topic:
two memory-consuming postgres processes
 deliverable@[EMAIL PROTEC  2008-05-02 12:24:35 
Re: two memory-consuming postgres processes
 scott.marlowe@[EMAIL PROT  2008-05-02 13:30:38 
Re: two memory-consuming postgres processes
 deliverable@[EMAIL PROTEC  2008-05-02 12:38:37 
Re: two memory-consuming postgres processes
 scott.marlowe@[EMAIL PROT  2008-05-02 13:53:56 
Re: two memory-consuming postgres processes
 tgl@[EMAIL PROTECTED] (T  2008-05-02 16:13:37 
Re: two memory-consuming postgres processes
 deliverable@[EMAIL PROTEC  2008-05-02 13:26:47 
Re: two memory-consuming postgres processes
 gsmith@[EMAIL PROTECTED]   2008-05-02 16:22:29 
Re: two memory-consuming postgres processes
 deliverable@[EMAIL PROTEC  2008-05-02 13:28:42 
Re: two memory-consuming postgres processes
 deliverable@[EMAIL PROTEC  2008-05-02 13:35:32 
Re: two memory-consuming postgres processes
 scott.marlowe@[EMAIL PROT  2008-05-02 14:40:51 
Re: two memory-consuming postgres processes
 deliverable@[EMAIL PROTEC  2008-05-02 13:51:44 
Re: two memory-consuming postgres processes
 craig_james@[EMAIL PROTEC  2008-05-02 14:02:24 
Re: two memory-consuming postgres processes
 deliverable@[EMAIL PROTEC  2008-05-02 14:09:52 
Re: two memory-consuming postgres processes
 lists@[EMAIL PROTECTED]   2008-05-02 23:30:44 
Re: two memory-consuming postgres processes
 gsmith@[EMAIL PROTECTED]   2008-05-02 17:23:45 
Re: two memory-consuming postgres processes
 deliverable@[EMAIL PROTEC  2008-05-02 14:30:17 
Re: two memory-consuming postgres processes
 Kevin.Grittner@[EMAIL PRO  2008-05-02 16:43:58 
Re: two memory-consuming postgres processes
 deliverable@[EMAIL PROTEC  2008-05-02 15:03:12 
Re: two memory-consuming postgres processes
 Kevin.Grittner@[EMAIL PRO  2008-05-02 17:29:00 
Re: two memory-consuming postgres processes
 matthew@[EMAIL PROTECTED]  2008-05-03 10:25:28 
Re: two memory-consuming postgres processes
 mmoncure@[EMAIL PROTECTED  2008-05-03 11:07:11 

Post A Reply:
  Go here to Signup

AddThis Feed Button


About - Advertising - Contact - Frequently Asked Questions - Privacy Policy - Terms of Use - Signup
Contact
tan13V112 Tue Jul 8 23:41:45 CDT 2008.