Postgres SSD optimization

If you’re running your database on an SSD instead of a spinning disk, you might want to optimize postgres table space cost:


-- Change the tablespace cost
ALTER TABLESPACE pg_default SET ( seq_page_cost = 20, random_page_cost = 1 );
-- Verifiy the change
SELECT * FROM pg_tablespace;

-- Undo the tablespace cost
ALTER TABLESPACE pg_default RESET ( seq_page_cost, random_page_cost);
-- Verifiy the change
SELECT * FROM pg_tablespace;

0 Replies to “Postgres SSD optimization”

  1. Online Pharmacy Slimex Cheap Erectile Dysfunction Pills Buy Cheap Kamagra Uk viagra Cash On Delivery Doxycycline 10mg Zithromax Prescription Venta De Priligy En Argentina

Leave a Reply

Your email address will not be published. Required fields are marked *


7 + three =