Re: [PERFORM] WAL still kept in pg_xlog even long after heavy workload is done

To get the values right, you have to consider the "unit" column in pg_settings. On mine, it is 16M for both min and max wal size. So it would be 1024 x 1024 x 16 x (pg_settings.min_wal_size or pg_settings.max_wal_size) The result of this formula should be close to what you specified in pos

Re: [PERFORM] performance problem on big tables

Maybe I missed it in this continuous thread activity, but have you tried '''ora2pg"? You can export from Oracle and import to Postgres in parallel jobs. The import commands use the efficient COPY command by default (unless you override it in the ora2pg configuration file). You can do the exp

Re: [PERFORM] performance problem on big tables

Total RAM on your host is 5GB, really? Before touching anything else, increase your RAM. That will be your big performance boost right there. Then, you can "up" your effective_cache_size and maintenance_work_mem. Regards, Michael Vitale Mariel Cherkassky