subject:"\[PERFORM\] waiting for harddisk"

Re: [PERFORM] waiting for harddisk

2008-03-24 Thread Scott Marlowe

On Mon, Mar 24, 2008 at 7:05 AM, petchimuthu lingam <[EMAIL PROTECTED]> wrote: > i am using postgresql 8.1.8, > > Following configurations: >shared_buffers = 5000 > work_mem = 65536 > maintenance_work_mem = 65536 > effective_cache_size = 16000 >

Re: [PERFORM] waiting for harddisk

2008-03-24 Thread PFC

i am using postgresql 8.1.8, Following configurations: shared_buffers = 5000 work_mem = 65536 maintenance_work_mem = 65536 effective_cache_size = 16000 random_page_cost = 0.1 The cpu is waiting percentage goes upto 50%, and query result

[PERFORM] waiting for harddisk

2008-03-24 Thread petchimuthu lingam

i am using postgresql 8.1.8, Following configurations: shared_buffers = 5000 work_mem = 65536 maintenance_work_mem = 65536 effective_cache_size = 16000 random_page_cost = 0.1 The cpu is waiting percentage goes upto 50%, and query result c