Postgres Pro
Downloads
Home   >   mailing lists

waiting for harddisk - Mailing list pgsql-performance

From petchimuthu lingam
Subject waiting for harddisk
Date
Msg-id cd233fc30803240605k2a7ae66w90487449ae07d051@mail.gmail.com
Whole thread Raw
Responses Re: waiting for harddisk  (PFC <lists@peufeu.com>)
Re: waiting for harddisk  ("Scott Marlowe" <scott.marlowe@gmail.com>)
List pgsql-performance
Tree view
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 comes later,

i am using normal select query ( select * from table_name ).

table has more then 6 million records.



--
With Best Regards,
Petchimuthulingam S

pgsql-performance by date:

Previous
From: Thomas Pundt
Date:
Subject: Re: slow pg_connect()
Next
From: PFC
Date:
Subject: Re: waiting for harddisk