{
    "info": {
        "author": "Timur Isanov",
        "author_email": "tisanov@yahoo.com",
        "bugtrack_url": null,
        "classifiers": [
            "Environment :: Console",
            "License :: OSI Approved :: MIT License",
            "Programming Language :: Python :: 2.6",
            "Programming Language :: Python :: 2.7",
            "Programming Language :: Python :: 3",
            "Topic :: Database"
        ],
        "description": "pg\\_hotcache\r\n============\r\n\r\nLimiter for loading into cache is the value of \"effective\\_cache\\_size\".\r\n\r\nIt makes sense to use after restarting the server!\r\n\r\nBefore using, you need to connect to the database as superuser and add\r\nthe extension 'pg\\_prewarm' (added to PostgreSQL since version 9.4):\r\n\r\n::\r\n\r\n    create extension pg_prewarm;\r\n\r\nUsage:\r\n\r\n::\r\n\r\n    pg_hotcache [-?] [-h HOST] [-p PORT] [-U USERNAME] [-W PASSWORD] -d DBNAME\r\n\r\nOptional arguments:\r\n\r\n::\r\n\r\n    -?, --help            show this help message and exit\r\n    -h HOST, --host HOST  database server host or socket directory (default:\r\n                          \"local socket\")\r\n    -p PORT, --port PORT  database server port (default: \"5432\")\r\n    -U USERNAME, --username USERNAME\r\n                          database user name (default: \"unix user\")\r\n    -W PASSWORD, --password PASSWORD\r\n                          force password prompt (should happen automatically)\r\n    -d DBNAME, --dbname DBNAME\r\n                          database name for caching\r\n\r\nExamples:\r\n\r\n::\r\n\r\n    sudo -u postgres pg_hotcache -d dbname\r\n    pg_hotcache -h 127.0.0.1 -p 5432 -U username -d dbname",
        "description_content_type": null,
        "docs_url": null,
        "download_url": "UNKNOWN",
        "downloads": {
            "last_day": -1,
            "last_month": -1,
            "last_week": -1
        },
        "home_page": "https://github.com/xtimon/pg_hotcache",
        "keywords": "",
        "license": "MIT",
        "maintainer": "",
        "maintainer_email": "",
        "name": "pg_hotcache",
        "package_url": "https://pypi.org/project/pg_hotcache/",
        "platform": "UNKNOWN",
        "project_url": "https://pypi.org/project/pg_hotcache/",
        "project_urls": {
            "Download": "UNKNOWN",
            "Homepage": "https://github.com/xtimon/pg_hotcache"
        },
        "release_url": "https://pypi.org/project/pg_hotcache/0.2.1/",
        "requires_dist": null,
        "requires_python": null,
        "summary": "Loading into cache from said PostgreSQL database the tables, which are most frequently scanned.",
        "version": "0.2.1"
    },
    "last_serial": 2007568,
    "releases": {
        "0.2.1": [
            {
                "comment_text": "",
                "digests": {
                    "md5": "8110adeb84800c22e70a81ed68d1d0c7",
                    "sha256": "c1c216f4f698a38c26b196da13cf3ce3c0e9910adfcda901ce6716cff500c28a"
                },
                "downloads": -1,
                "filename": "pg_hotcache-0.2.1.tar.gz",
                "has_sig": false,
                "md5_digest": "8110adeb84800c22e70a81ed68d1d0c7",
                "packagetype": "sdist",
                "python_version": "source",
                "requires_python": null,
                "size": 3565,
                "upload_time": "2016-03-02T16:00:27",
                "url": "https://files.pythonhosted.org/packages/fe/d4/6f4462a73f59dd67c0e1f115b453e6cfe6dd2ee927560ca7caec25a90050/pg_hotcache-0.2.1.tar.gz"
            }
        ]
    },
    "urls": [
        {
            "comment_text": "",
            "digests": {
                "md5": "8110adeb84800c22e70a81ed68d1d0c7",
                "sha256": "c1c216f4f698a38c26b196da13cf3ce3c0e9910adfcda901ce6716cff500c28a"
            },
            "downloads": -1,
            "filename": "pg_hotcache-0.2.1.tar.gz",
            "has_sig": false,
            "md5_digest": "8110adeb84800c22e70a81ed68d1d0c7",
            "packagetype": "sdist",
            "python_version": "source",
            "requires_python": null,
            "size": 3565,
            "upload_time": "2016-03-02T16:00:27",
            "url": "https://files.pythonhosted.org/packages/fe/d4/6f4462a73f59dd67c0e1f115b453e6cfe6dd2ee927560ca7caec25a90050/pg_hotcache-0.2.1.tar.gz"
        }
    ]
}