| vinita bansal 2005-03-30, 7:04 pm |
| 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_collecto
r = 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
|