2017 © Pedro Peláez
 

library pgsql-indexes

Dbmover plugin for PostgreSQL-specific index handling

image

dbmover/pgsql-indexes

Dbmover plugin for PostgreSQL-specific index handling

  • Monday, April 17, 2017
  • by monomelodies
  • Repository
  • 1 Watchers
  • 0 Stars
  • 67 Installations
  • PHP
  • 1 Dependents
  • 0 Suggesters
  • 0 Forks
  • 0 Open issues
  • 5 Versions
  • 18 % Grown

The README.md

Dbmover\PgsqlIndexes

PostgreSQL-specific index (re)creation plugin, (*1)

Installation

$ composer require dbmover/pgsql-indexes
This package is part of the `dbmover/pgsql` meta-package.

Usage

See dbmover/core for general DbMover usage., (*2)

The plugin scans your schemas for CREATE [UNIQUE] INDEX statements, compares them to existing indexes and if necessary (re)creates them. It also drops any indexes no longer mentioned in your schemas., (*3)

Caveats

PostgreSQL indexes are named implicitly, but using named indexes makes it easier for DbMover to determine if an index is new (or removed). You can use the dbmover/force-named-indexes plugin if you're too lazy to explicitly name your indexes (like us)., (*4)

Indexes containing a WHERE clause - and particularly complex indexes, due to naming length restrictions - should always be explicitly named for best results., (*5)

Contributing

See dbmover/core., (*6)

The Versions

17/04 2017

dev-master

9999999-dev

Dbmover plugin for PostgreSQL-specific index handling

  Sources   Download

MIT

The Requires

 

by Marijn Ophorst

17/04 2017

0.6.3

0.6.3.0

Dbmover plugin for PostgreSQL-specific index handling

  Sources   Download

MIT

The Requires

 

by Marijn Ophorst

16/04 2017

0.6.2

0.6.2.0

Dbmover plugin for PostgreSQL-specific index handling

  Sources   Download

MIT

The Requires

 

by Marijn Ophorst

15/04 2017

0.6.1

0.6.1.0

Dbmover plugin for PostgreSQL-specific index handling

  Sources   Download

MIT

The Requires

 

by Marijn Ophorst

10/04 2017

0.6.0

0.6.0.0

Dbmover plugin for PostgreSQL-specific index handling

  Sources   Download

MIT

by Marijn Ophorst