PostgreSQL tiene varios tipos de índices: B-tree, Hash, GiST, Gin y SP-GiST. Obviamente cada uno de ellos cubre una necesidad específica. Por ejemplo, la documentación de PostgreSQL dice sobre los índices GIN: Los índices GIN son índices invertidos que pueden manejar valores que contienen más de una clave, arreglos, por ejemplo. Como GiST y SP-GiST, […]
Compiling and debugging PostgreSQL’s PgJDBC under Eclipse
/2 Comments/in Craig's PlanetPostgreSQL /by craig.ringerI’ve always worked on PgJDBC, the JDBC Type 4 driver for PostgreSQL, with just a terminal, ant and vim. I recently had occasion to do some PgJDBC debugging work on Windows specifics so I set up Eclipse to avoid having to work on the Windows command prompt. As the process isn’t completely obvious, here’s how […]
pg_sysdatetime: a simple cross-platform PostgreSQL extension
/0 Comments/in Craig's PlanetPostgreSQL /by craig.ringerA while ago I wrote about compiling PostgreSQL extensions under Visual Studio – without having to recompile the whole PostgreSQL source tree. I just finished the pg_sysdatetime extension, which is mainly for Windows but also supports compilation with PGXS on *nix. It’s small enough that it serves as a useful example of how to support […]
Announcing BDR RPMs for 9.4
/0 Comments/in Craig's PlanetPostgreSQL /by craig.ringerRPMs for BDR (Bi-Directional Replication for PostgreSQL) are now available for testing. They contain BDR release 0.7.1, which is based on PostgreSQL 9.4beta2. Because there may be an on-disk format change (catversion bump) before PostgreSQL 9.4.0 final, and because these RPMs are quite new, this should be considered a test release. RPMs are available for […]
Detecting smelly backups with Barman
/0 Comments/in Barman, Gabriele's PlanetPostgreSQL /by Gabriele Bartolini“Ooooh that smell! Can’t you smell that smell?“. That’s a classic rock song by legends Lynyrd Skynyrd, I know. But also a warning that your new Barman 1.3.3 installation can now emit.
Announcing Barman 1.3.3
/1 Comment/in Barman, International News /by Gabriele BartoliniVersion 1.3.3 of Barman, Backup and Recovery Manager for PostgreSQL, has been released.
PostgreSQL anti-patterns: read-modify-write cycles
/28 Comments/in Craig's PlanetPostgreSQL /by craig.ringerShaun Thomas’s recent post about client-side loops as an SQL anti-pattern is well worth a read if you’re relatively new to SQL-based application development. It’s reminded me of another SQL coding anti-pattern that I see quite a lot: the naïve read-modify-write cycle. Here I’ll explain what this common development mistake is, how to identify it, […]
PostgreSQL’s CTEs are optimisation fences
/35 Comments/in Craig's PlanetPostgreSQL /by craig.ringerAs part of AXLE project work I recently found myself re-examining issues around optimisation fencing and non-semantic query execution changes in PostgreSQL. One key issue was the inability to use a CTE where optimisation (inlining, push-up/pull-down, flattening, etc) was desired. I’d like to explain that in more detail, as it’s something that can surprise new […]
Putting a PostgreSQL tablespace on a ramdisk risks ALL your data
/15 Comments/in Craig's PlanetPostgreSQL /by craig.ringerI periodically see people being advised to put their tablspaces on RAM disks or tempfs volumes. This is very bad advice. Do not put a PostgreSQL TABLESPACE on a RAM disk or tempfs. Why you shouldn’t put a tablespace on a ramdisk Unlike MySQL and some other databases, PostgreSQL tablespaces are not completely independent of […]
Announcing Barman 1.3.1
/0 Comments/in Barman, International News /by Gabriele BartoliniVersion 1.3.1 of Barman, Backup and Recovery Manager for PostgreSQL, has been released. Barman now supports concurrent backup from PostgreSQL 9.2 and 9.3 servers, using the pgespresso extension, allowing users to issue backups from a streaming replicated standby server. Read the full announcement at http://www.pgbarman.org/barman-1-3-1-released/. Many thanks for funding towards the development of this release […]
Indexando ando: Índices GIN
/0 Comments/in El Planeta PostgreSQL de Jaime, PostgreSQL /by Jaime CasanovaPostgreSQL tiene varios tipos de índices: B-tree, Hash, GiST, Gin y SP-GiST. Obviamente cada uno de ellos cubre una necesidad específica. Por ejemplo, la documentación de PostgreSQL dice sobre los índices GIN: Los índices GIN son índices invertidos que pueden manejar valores que contienen más de una clave, arreglos, por ejemplo. Como GiST y SP-GiST, […]