Postgresql disable sequence scan
To optimize some query, sometime we need to disable sequence scan, run this before query:
Set enable_seqscan = off;
Then do analyze to your query
Set enable_seqscan = off;
Then do analyze to your query
Optimize SSD on Linux
After installing the SSD on your laptop, there are some adjustments that need to be done so that it is optimal . I'm using Fedora 30 File system My Partition is: Disk /dev/sda: 465.8 GiB, 500107862016 bytes, 976773168 sectors Disk model: Samsung SSD 860 Units: sectors of 1 * 512 = 512 bytes Sector size (logical/physical): 512 bytes / 512 bytes I/O size (minimum/optimal): 512 bytes / 512 bytes Disklabel type: gpt Disk identifier: DF4E716F-F00A-40F3-8176-C97A52F36998 Device Start End Sectors Size Type /dev/sda1 2048 253951 251904 123M EFI System /dev/sda2 253952 976773119 976519168 465.7G Linux LVM And logical volume are: Root, Home, Archive, VM, Games Format as ext4 with default block size (4096 best for SSD), and set reserved block to 1% # mkfs.ext4 -L Home -m 1 /dev/VG/YourHome Copying I did not reinstall lin...
Comments