OmniPITR

Solution for HOT replication/backup/restore.

Links:

  • github repo
  • blog posts
  • docs

explain.depesz.com

Tool for helping understanding explain analyze outputs from PostgreSQL.

Links:

  • website
  • blog posts
  • github page
  • Underlying library for parsing plans (github repo)

Pg::SQL::Parser

Perl library/class for parsing SQL queries.

Links:

  • blog posts
  • github page

Versioning

Set of functions to provide versioning of tables, functions or other objects in PostgreSQL database.

Links:

  • github page with sources
  • blog posts
  • usage docs

Curo

Addon to psql to make administrator life easier by providing set of queries/tools to monitor and check database status.

Links:

  • github repo
  • Documentation
  • blog posts

system_monitoring

Scheduler for commands with precision of up to 1 second (vs. 1 minute in standard cron). Used primarily to monitor and log state of server and PostgreSQL.

Links:

  • github repo
  • blog posts

  • Popular Posts

    • Waiting for 9.3 – Create a psql command \gset to store query results into psql variables 0 comment(s) | 546 view(s)
    • Jak obsłużyć klienta, na przykładzie firmy Kurtmedia 9 comment(s) | 262 view(s)
    • Why is UPSERT so complicated? 0 comment(s) | 235 view(s)
    • Adding plans to explain.depesz.com from your psql 2 comment(s) | 217 view(s)
    • “FATAL: Ident authentication failed”, or how cool ideas get bad usage schemas 0 comment(s) | 187 view(s)
    • CHAR(x) vs. VARCHAR(x) vs. VARCHAR vs. TEXT – UPDATED 2010-03-03 0 comment(s) | 178 view(s)
    • Index on (a,b) vs. (b,a)? 0 comment(s) | 149 view(s)
    • Understanding postgresql.conf : log* 0 comment(s) | 148 view(s)
    • Write Ahead Log + Understanding postgresql.conf: checkpoint_segments, checkpoint_timeout, checkpoint_warning 0 comment(s) | 115 view(s)
    • Waiting for 8.4 – RETURN QUERY EXECUTE and cursor_tuple_fraction 0 comment(s) | 107 view(s)

  • postgresql

    • Documentation
    • Explain Analyze analyzer
    • IRC help channel
    • Mailing Lists search
    • PG Planet
    • PostgreSQL Home Page

  • About me

    • CPAN
    • Hardware for tests
    • LinkedIn
    • StackOverflow

  • Theme

    • Related searches:
    comment github explain translate depesz
    gipoco.com is neither affiliated with the authors of this page nor responsible for its contents. This is a safe-cache copy of the original web site.