Re: [PERFORM] how to improve the performance of creating index

On 10/19/07, Yinan Li [EMAIL PROTECTED] wrote: Hi, all I am trying to improve the performance of creating index. I've set shared_buffers = 1024MB Effective_cache_size = 1024MB Work_mem = 1GB

Re: [PERFORM] how to improve the performance of creating index

Please keep the list cc'd so that others can help. Yinan Li wrote: What version of Postgres are you using? 8.2.4 How much RAM does the box have? 2G How big is the table? 256M tuples, each tuple contains 2 integers. How long does the index build take? About 2 hours What kind of an I/O

[PERFORM] need help with a query

Hi, I am updating a big table (90M records) with data from another rather large table (4M entries). Here is my update query: update links set target_size = ( select size from articles where articles.article_id = links.article_to) I have built all the indexes one might need,

Re: [PERFORM] how to improve the performance of creating index

[EMAIL PROTECTED] (Yinan Li) writes: I am trying to improve the performance of creating index.:p I've set shared_buffers = 1024MB:p    Effective_cache_size = 1024MB:p    Work_mem = 1GB:p    Maintenance_work_mem=512MB:p    

Re: [PERFORM] need help with a query

Pavel Velikhov [EMAIL PROTECTED] writes: Got a very different query plan this time, with a hash join between links and articles. At least now postgres is using both shared memory buffers and working mem, but its still completely IO bound, only getting in 5-6% CPU once in a while. I guess I

Re: [PERFORM] need help with a query

Thanks for you help! Got a very different query plan this time, with a hash join between links and articles. At least now postgres is using both shared memory buffers and working mem, but its still completely IO bound, only getting in 5-6% CPU once in a while. I guess I can't squeeze more out

Re: [PERFORM] need help with a query

On 10/19/07, Pavel Velikhov [EMAIL PROTECTED] wrote: Hi, I am updating a big table (90M records) with data from another rather large table (4M entries). Here is my update query: update links set target_size = ( select size from articles where articles.article_id =

Re: [PERFORM] how to improve the performance of creating index

Yinan Li wrote: I am trying to improve the performance of creating index. I've set shared_buffers = 1024MB Effective_cache_size = 1024MB Work_mem = 1GB Maintenance_work_mem=512MB (I'm sure that the

[PERFORM] how to improve the performance of creating index

Hi, all I am trying to improve the performance of creating index. I've set shared_buffers = 1024MB Effective_cache_size = 1024MB Work_mem = 1GB Maintenance_work_mem=512MB (I'm sure that the server process