Hi,
I have a 64 bit Linux box with 32GB RAM and disk space approx 450 GB.
I am running a benchmark using filesystem type ext3 with data=writeback both on Postgres 7 and 8. Time taken for benchmark run is very less compared to the one on Postgres 8. I am esentially trying to get performance improvement by using data=writeback. If I do not use data=writeback both for Postgres 7 and 8, I am getting almost the same numbers for benchmark run. Why is this happening. why data=writeback is giving good results for Postgres7 and not for Postgres 8??
I am using the following settings both for Postgres 7 and 8:
shared_buffers = 3000 work_mem = 100000 maintenance_work_mem = 100000 max_fsm_pages = 200000 bgwriter_percent = 0 wal_buffers = 64 checkpoint_segments = 256 checkpoint_timeout = 1800 effective_cache_size = 250000 random_page_cost = 2 stats_start_collector = true stats_command_string = true stats_row_level = true
Also, I would like to know
- if using a Postgres 7 database dump to restore database on Postgres 8 can cause this
- using Postgres 7 jdbc driver for Postgres 8 can lead to a time performance degradation (I am using postgres 7 driver now since using Postgres 8 driver I am getting an error
java.sql.SQLException: ERROR: operator does not exist: smallint = boolean.
FYI: I have runstats on all tables both for Postgres 7 and 8 after doing a restore.
Regards, Vinita Bansal
_________________________________________________________________
News, views and gossip. http://www.msn.co.in/Cinema/ Get it all at MSN Cinema!
---------------------------(end of broadcast)--------------------------- TIP 7: don't forget to increase your free space map settings
