Search the Community
Showing results for tags 'performance'.
-
I migrated a Postgres database 9.1 doing 300K transactions/hour from a server with Red Hat OS, Intel(R) Xeon(R) CPU E5-2670 0 @ 2.60GHz / 16 Core, 64 GB RAM, 240 GB x 4 Intel SSD TO Intel(R) Xeon(R) CPU E5-2680 v4 @ 2.40GHz / 56 Core, 128 GB RAM, 2TB nvme PCI SSD, RANDOM READ 450000 iops, RANDOM WRITE 56000 iops. CentOS 6.9. Over a period of time the server slows down and the amount of data processed get reduced. If I clear the cache manually (sync; echo 3 > /proc/sys/vm/drop_caches) then the data processing resume to maximum level. Again after some time with load, the performance deteriorates in terms of an amount of data processed. The cache memory shows it has been fully consumed. pg configuration : datestyle = 'redwood,show_time' db_dialect = 'redwood' default_text_search_config = 'pg_catalog.english' edb_dynatune = 90 edb_redwood_date = on edb_redwood_strings = on lc_messages = 'en_US.UTF-8' lc_monetary = 'en_US.UTF-8' lc_numeric = 'en_US.UTF-8' lc_time = 'en_US.UTF-8' shared_preload_libraries = '$libdir/dbms_pipe,$libdir/edb_gen,$libdir/plugins/plugin_debugger,$libdir/plugins/plugin_spl_debugger' timed_statistics = off archive_command = 'rsync -a %p slave:/opt/PostgresPlus/9.1AS/wals/%f' archive_mode = on listen_addresses = '*' log_destination = 'syslog' syslog_facility = 'LOCAL0' logging_collector = on log_line_prefix = '%t' max_wal_senders = 4 port = 6432 wal_keep_segments = 128 wal_level = hot_standby temp_buffers='50MB' constraint_exclusion = on autovacuum = on enable_bitmapscan = off max_connections = 200 shared_buffers = 32GB effective_cache_size = 96GB work_mem = 167772kB maintenance_work_mem = 2GB checkpoint_segments = 64 checkpoint_completion_target = 0.9 wal_buffers = 16MB default_statistics_target = 100 Thank you
-
- postgresql
- cache
-
(and 1 more)
Tagged with:
-
Using 4.10 Starting with a long, single clip (e.g. 6 hr), add it to the sequence, and pan thru it on the timeline. When I find a section that I want to include in the final product, I copy/paste the clip so I now have two copies. I drag the clip boundaries to the time that I want included, then repeat for multiple clips (e.g. ~50). Then I play back the video using the main arrow under the Sequence Preview window. So far, so good. The problem occurs at some of the clip boundaries: the audio plays back unimpeded, but the video stalls with a "building preview" message. I can understand it happening once per transition, but it occurs multiple times when I play back thru the same transition. This can occur on several of the transitions, but not all of them. And not in sequence - some of the earlier transitions stall, while the later ones play back properly. Further, sometimes a transition plays properly one time, but then falters when I play through it a second time. No recognizable pattern to how it reacts. I've tried "scrubbing" thru the clips when zoomed in tightly, and scrubbing thru the Sequence. Sometimes it helps, other times it makes no difference. I've "clear cache of all unused clips", but it did not make a difference. There is lots of available space on the drive, and the maximum cache size is set to 100000 MB in Tools > Options > Disk. The cache is currently about 7.5 GB for the current project with one source file. The cache had previously been about 18 GB for another similar sized project, and about 28 GB when two projects were cached. It never grew beyond about 28 GB, even after starting a third project. Is there some technique to ensure smooth preview playback?
-
I'm using version 3.04 Unlicensed Free of VideoPad. A great piece of software I plan to purchase in August. In the meantime I am having some difficulty, however. I have a Phenom II Athlon X4 965 BE @ 3.4GHz but the program shows 100% CPU utilization in Task Manager no matter what I do. Is there an advisable core affinity I should set that might improve performance? I have a fairly robust system with lots of memory and I would not expect the program to be this taxing for my processor. If this is normal, please disregard. If not, any advice from fellow users would be greatly appreciated. Thanks!
- 2 replies
-
- Performance
- Crashes
-
(and 3 more)
Tagged with: