32 Pirrama Road, Pyrmont NSW 2009
> *P *(+61) 2 8099 9000 <(+61)%202%208099%209000> *W* www.jirotech.com
> *F *(+61) 2 8099 9099 <(+61)%202%208099%209000>
>
> On Fri, Apr 28, 2017 at 3:33 AM, Jacob Scott
> wrote:
>
>> When reviewing execution statistics, I am f
When reviewing execution statistics, I am frequently interested in the
behavior of "classes" of queries, rather than individual queries, for
example queries which
- Contain a join
- Touch a specific column
- Use POSIX regular expressions
AFAIK this sort of summary/rollup information can'
Hi,
Many packages in the Postgres apt repository (
https://wiki.postgresql.org/wiki/Apt) are named with a PG major version
postfix such as postgresql-client-9.5. Is there a reason why libpq-dev is
not?
Specifically, I'm interested installing Postgres 9.5 on Ubuntu 14.04, which
is made very easy t
Arg, should have included this in my initial email :-(
9.3.11
On Thu, May 5, 2016 at 7:46 AM, Alvaro Herrera
wrote:
> On Wed, May 04, 2016 at 11:52:47PM -0700, Jacob Scott wrote:
> > Hi,
> >
> > I'm seeing a "tuple concurrently updated" error thrown while e
ay 5, 2016 at 8:13 AM, Alvaro Herrera
wrote:
> Jacob Scott wrote:
> > Arg, should have included this in my initial email :-(
> >
> > 9.3.11
>
> OK. So what are the updates doing? Are there any FKs involved?
>
> --
> Álvaro Herrerahttp://www.2
Hi,
I'm seeing a "tuple concurrently updated" error thrown while executing
UPDATE statements. I've attempted to diligently review previous threads on
this error (e.g.,
https://www.google.com/webhp?ie=UTF-8#q=tuple+concurrently+updated+update+site:postgresql.org)
but am confused about what classes
Hi,
Does upgrading a a disk being used by postgres (9.1, on Ubuntu) with the
following process sound safe?
1. pg_start_backup
2. Take a filesystem snapshot (of a volume containing postgres data but
not pg_xlog)
3. Bring a new higher performing disk online from snapshot
4. pg_ctl s
