PgTune — tuning PostgreSQL performance for a given hardware configuration (online version)

Hello, habrovany. Today I want to talk about such interesting things as PgTune.

image



In 2008 Gregory Smith has created a good tool pgtune. The main objective of this tool was to help newcomers with setting up PostgreSQL. Utility is great, but has a small cons:

the
    the
  • Not updated since 2009 (so the calculations a bit is no longer relevant steel)
    • the
  • Need to download or install from the packages (not a problem in many Linux distributions it is)


So I have created an online version of PgTune. Main advantages:

the
    the
  • Updated count to configuration.
    • the
  • you do Not need to put anything or to pump
    • the
  • Works in offline mode, and it can be used as mobile app


On first boot You will no longer need access to the Internet (only for updates) to use the utility. This is implemented using AppCache technology. That would put it as an app on the iPhone, just log in iOS Safari or Android Chrome and select the menu item "Add to desktop".

And most importantly — utility Open Source.

In conclusion, I want to warn you that this utility is not a "silver bullet" in configuring and tuning PostgreSQL. Many settings depend not only on the hardware configuration, but also on the size of the database, number of clients and complexity of the queries, so that optimally configure the database is only possible taking into account all the system settings and applications (e.g. to consider SSD drives, and if the database fits in memory). But I hope this utility will help you to begin configuring PostgreSQL.

Thank you for your attention. Use on health.
Article based on information from habrahabr.ru

Комментарии

Отправить комментарий

Популярные сообщения из этого блога

Integration of PostgreSQL with MS SQL Server for those who want faster and deeper

Изображение
Recently habré was already published integration PostgreSQL and MSSQL. But, items there is categorically not enough. Therefore, the objectives of this publication are the following: the the to broaden and deepen publicly available information about FDW for MSSQL-called tds_fdw to tell the difference in major versions and describe basic compatibility issues; the to talk about the possibilities of optimization of queries that use the foreign table; the to address the subject of caching external data in a materialized view; the to say a few words about the exotic ways to integrate PostgreSQL and MSSQL. the Installing and configuring TDS FDW The guys from PostgresPro already sufficiently said about this process, I will not repeat. Will leave a few links to the official PostgreSQL documentation and examples from tds_fdw: the the creating an extension (extension) in PG: off.dokumentacija ; the server: off.documentation , example of tds_fdw ; the creating
Далее...

Parse URL in Zend Framework 2

Objective: the Have a method to disassemble the components of the string containing the URL. The string can contain both absolute and relative URLS and both these options should be correctly parsed. the And in the drain, let's say the "wrong" format absolute links without "http://". Further in the text links to the "wrong" format will be called partial absolute references . the Implement support for the "RF" domain. the Example: site.ru/page.php /page.php site.ru/page.php the scheme http the host site.ru site.ru the path page.php page.php page.php Implementation of paragraphs 1 and 2 of our problem In this we should help the class Zend\Uri\Http . He has we need methods parse($uri) , getHost() , getPath() , etc. But! When we parse the URL and type " site.ru/page.php " (without the " http:// ") getHost() will return an empty string and getPath()
Далее...

Custom database queries in MODx Revolution

This topic will certainly be useful for those who have quite a lot of projects on MODx Revolution, as with the usual sites of business cards is enough and the standard working methods of a La $modx- > getObject() , $modx->getCollection() , etc., and these methods are inherently not just a job database, but also with the objects of MODx. When working with large projects methods a La $modx- > getCollection() for us is not the best solution for two reasons: 1. The overexpenditures. These methods are not just getting data from DB, but also create instance of the retrieved objects. In this case, getting information about 10000 documents, we get 10000 objects of modResource that it is not very cool. 2. The task is complicated by the count of records. In addition to the direct difficulties of counting even at the query level, even if you get 10 records of the same document (for example), MODx will return as a result only one object modResource. Although often that will su
Далее...