Editor
348
edits
Difference between revisions of "Performance tuning"
Jump to navigation
Jump to search
m
Add SQLite documentation
m (Add SQLite documentation) |
|||
| Line 201: | Line 201: | ||
Make separate datasets for PostgreSQL's data and WAL. Set recordsize=8K on both to avoid expensive partial record writes. Set logbias=throughput on PostgreSQL's data to avoid writing twice. | Make separate datasets for PostgreSQL's data and WAL. Set recordsize=8K on both to avoid expensive partial record writes. Set logbias=throughput on PostgreSQL's data to avoid writing twice. | ||
=== SQLite === | |||
Make a separate dataset for the database. Set the recordsize to 64K. Set the SQLite page size to 65536 bytes[https://www.sqlite.org/pragma.html#pragma_page_size]. | |||
Note that SQLite databases typically are not exercised enough to merit special tuning, but this will provide it. Note the side effect on cache size mentioned at SQLite.org[https://www.sqlite.org/pgszchng2016.html]. | |||
== File servers == | == File servers == | ||