852 karma · joined August 7, 2011
Select "Show only Verified Purchases" to get rid of most of fake reviews according to this 96% of "Incentivized Reviews" are not verified purchases
http://reviewmeta.com/blog/what-can-we-do-about-the-problem-...
Another tip is finding products with most reviews so you get more overall rating even it has some paid/sponsor reviews. "Most reviews" sort option is hidden in most of the categories but there is a way to do it. Here is my detailed writing about this. Disclosure: I am the author of medium story and http://www.jeviz.com which provides more sort options including "most reviews" to Amazon searches.
https://medium.com/@ceyhunkazel/amazon-search-hack-eliminate...
https://hackernoon.com/users-are-not-programmers-amazon-expe...
I started with bootstraptour and it was pretty good on desktop and it is even fine with ajax DOM change while tour. Shame on me I did not test my site after adding tour on mobile then I announced jeviz.com on hackernews, a user commented about scrolling issue on mobile. Tour did not automatically scrolled down on mobile and it also prevent me scroll-down manually. Maybe it is because of dynamic content issue and I tried to fix it without success so I searched for another tour library which was intro.js
Intro.js at first seemed to be more polished than bootstraptour and I liked how it highlights on target element and gray out remaining parts. It has problems with ajax DOM change so I changed my tour without using ajax. It worked good on chrome then I tested on firefox and internet explorer, both with same issue: first step was fine but after that, in second step and so on tour popup and most of the site content turned to be invisible as shown below:
https://s13.postimg.org/4xd0f731j/introjs2.png
Then I googled for another alternative and found Hopscotch which is Linkedin open source project. It is very solid with best scrolling experience. It does not support DOM changes but found a workaround in issue page https://github.com/linkedin/hopscotch/issues/56
my tour code: http://www.jeviz.com/static/js/tour.js
1)for debian use: pg_createcluster instead of initdb
pg_createcluster 9.5 main -D /data/9.5/main -E UTF8 --locale=en_US.UTF-8 -- -k
https://wiki.debian.org/PostgreSql
https://makandracards.com/makandra/18643-how-the-change-the-...
2) Create a separate database volume partition for data. do not put version number in the mountpoint (/data, not /data/9.5) then create a folder with version number EXT4 or XFS for filesystem (ZFS is extra for experts) EXT4 on average a litter faster than XFS but standard deviation is higher than XFS
3) postgresql.conf - most server settings pg_hba.conf - who gets to log in to what databases?
4) Important parameters:
a) Logging
b) Memory
c) Checkpoints
d) Planner
5) log use csvlog format
http://cheng.logdown.com/posts/2016/04/08/enable-logging-in-...http://bonesmoses.org/2014/08/05/on-postgresql-logging-verbo...
log_destination = 'csvlog' logging_collector = on log_min_duration_statement = 250ms log_checkpoints = on log_lock_waits = on log_temp_files = 0
https://wiki.postgresql.org/wiki/Tuning_Your_PostgreSQL_Serv...
6) shared_buffers (cache for data) Sets the amount of memory the database server uses for shared memory buffers. Below 64GB set to %25 of total system memory above 64GB set to 16GB
7) work_mem (affect slow joins) Specifies the amount of memory to be used by internal sort operations and hash tables before writing to temporary disk files. The value defaults to four megabytes (4MB). Note that for a complex query, several sort or hash operations might be running in parallel; each operation will be allowed to use as much memory as this value specifies before it starts to write data into temporary files. Also, several running sessions could be doing such operations concurrently. Therefore, the total memory used could be many times the value of work_mem; it is necessary to keep this fact in mind when choosing the value. Sort operations are used for ORDER BY, DISTINCT, and merge joins. Hash tables are used in hash joins, hash-based aggregation, and hash-based processing of IN subqueries.
Start low: 32-64MB. Look for 'temporary file' lines in logs Set to 2-3x the largest temp file you see. Can cause a huge speed-up if set properly! But be careful: It can use that amount of memory per planner node.
8)maintenance_work_mem (integer) Specifies the maximum amount of memory to be used by maintenance operations, such as VACUUM, CREATE INDEX, and ALTER TABLE ADD FOREIGN KEY. It defaults to 64 megabytes (64MB). Since only one of these operations can be executed at a time by a database session, and an installation normally doesn't have many of them running concurrently, it's safe to set this value significantly larger than work_mem. Larger settings might improve performance for vacuuming and for restoring database dumps.
Note that when autovacuum runs, up to autovacuum_max_workers times this memory may be allocated, so be careful not to set the default value too high. It may be useful to control for this by separately setting autovacuum_work_mem.
* 10% of system memory, up to 1 GB. Maybe even higher if you are having VACUUM problems.
9) effective_cache_size effective_cache_size should be set to an estimate of how much memory is available for disk caching by the operating system and within the database itself, after taking into account what's used by the OS itself and other applications. This is a guideline for how much memory you expect to be available in the OS and PostgreSQL buffer caches, not an allocation! This value is used only by the PostgreSQL query planner to figure out whether plans it's considering would be expected to fit in RAM or not. If it's set too low, indexes may not be used for executing queries the way you'd expect. The setting for shared_buffers is not taken into account here--only the effective_cache_size value is, so it should include memory dedicated to the database too. Setting effective_cache_size to 1/2 of total memory would be a normal conservative setting, and 3/4 of memory is a more aggressive but still reasonable amount. You might find a better estimate by looking at your operating system's statistics. On UNIX-like systems, add the free+cached numbers from free or top to get an estimate. * Set to the amount of file system cache available. * If you don't know set it to 75% of total system memory free -m
1-) Choose sort by Most Reviews, which is an sort option Amazon generally hides
2-) From Average Customer Review choose 4 stars and & up
this will sort all products that are 4 or above stars but in most reviews order.