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
>Maintenance_work_
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 gue
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 o
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 =
> link
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, increase
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 a
[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_me
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
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 h
