On Friday, December 06, 2013 11:06:58 PM chidamparam muthusamy wrote: > hi, > Registered with PostgreSQL Help Forum to identify and resolve the Postgres > DB performance issue, received suggestions but could not improve the > speed/response time. Please help. > > Details: > Postgres Version 9.3.1 > Server configuration: > Processor: 2 x Intel Quad core E5620 @ 2.40GHz > RAM: 16 GB > > Postgres configuration: > Effective cache size = 10 GB > shared Buffer = 1250 MB > random page cost = 4 > > Table size = 60 GB > Number of records = 44 million > Carried out Vacuum Analyze after inserting new records and also after > creating Index, > 6 months data, every month around 10 GB will get added. Expecting good > performance with 3 years data. > DB Will be used for Reporting/Read, will not be used for transaction. Daily > records will be inserted through bulk insertion every day. Suggestions: Partition by month. Add many more disks, in RAID-10. or move to SSD. Add a lot more RAM. -- Sent via pgsql-performance mailing list (pgsql-performance@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance
