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_
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
