Hi,
We have an environment that has a central repository for lookups, which is
replicated to several databases, ech for different applications.
This has been arranged in a DTAP manner.
Sometimes it is necessary to synchronize the lookups of one of the DTAP
branches with another. But i can't just
Hi,
On 2014-09-29 13:52:52 -0700, p...@cmicdo.com wrote:
I have a question about BDR Global Sequences.
I've been playing with BDR on PG 9.4beta2, built from source from the
2nd Quadrant GIT page (git://git.postgresql.org/git/2ndquadrant_bdr.git).
When trying a 100 row \copy-in,
Hey
yes i'm adding an additional key to each of my tables. First i wanted to use
the primary key as one column in my audit_log table, but in some of my tables
the PK consists of more than one column. Plus it's nice to have one key that is
called the same over all tables.
To get a former
Hi Andres,
Hi,
On 2014-09-29 13:52:52 -0700, p...@cmicdo.com wrote:
I have a question about BDR Global Sequences.
[deleted]
Is there way to increase a global sequence's reservation block for each
node so that I can tell the nodes, I'm going to load 100M rows now so
you should get
Roopeshakumar Narayansa Shalgar (rshalgar) wrote:
Hi,
I am using version 9.3.1 and see the “no space device error” even though there
is enough space (99% free) on my disk.
Just to be sure, check the output of both 'df -h' (for disk blocks) and 'df -hi'
(for inodes). You might have ran
On Fri, Sep 26, 2014 at 1:36 PM, Dev Kumkar devdas.kum...@gmail.com wrote:
Received the database with huge pg_multixact directory of size 21G and
there are ~82,000 files in pg_multixact/members and 202 files in
pg_multixact/offsets directory.
Did run vacuum full on this database and it was
Dev Kumkar wrote:
On Fri, Sep 26, 2014 at 1:36 PM, Dev Kumkar devdas.kum...@gmail.com wrote:
Received the database with huge pg_multixact directory of size 21G and
there are ~82,000 files in pg_multixact/members and 202 files in
pg_multixact/offsets directory.
Did run vacuum full on
Gidday,
There was an interesting presentation at the Portland Postgres Users Group
meeting in early Sept, from a guy who demo'd a Postgres database mounted as a
FUSE filesystem. Not production ready, but with tables manifesting as
directories, databases could be synch'ed using filesystem
Felix, I'd love to see a single, well maintained project. For example, I
just found yours, and gave it a shot today after seeing this post. I found
a bug when an update command is issued, but the old and new values are all
the same. The trigger will blow up. I've got a fix for that, but if we
On Tue, Sep 30, 2014 at 8:50 PM, Alvaro Herrera alvhe...@2ndquadrant.com
wrote:
Did you try decreasing the autovacuum_multixact_freeze_min_age and
autovacuum_multixact_freeze_table_age parameters?
As per the docs this set anywhere from zero to 1 billion for
vacuum_multixact_freeze_min_age
And
Hello.
I was trying to get postgres to return the correct number of rows
inserted for batch inserts to a partitioned table [using the triggers as
suggested here
http://www.postgresql.org/docs/9.1/static/ddl-partitioning.html results in
it always returning 0 by default].
What I ideally wanted it
I'm trying to improve the speed of suite of queries that go across a few
million rows.
They use 2 main filters across a variety of columns:
WHERE (col_1 IS NULL ) AND (col_2 IS NULL) AND ((col_3 IS NULL) OR
(col_3 = col_1))
WHERE (col_1 IS True ) AND (col_2 IS True) AND (col_3
On 9/30/2014 4:50 PM, Jonathan Vanasco wrote:
WHERE (col_1 IS NULL ) AND (col_2 IS NULL) AND ((col_3 IS NULL) OR
(col_3 = col_1))
if col_1 IS NULL, then that OR condition doesn't make much sense.
just saying...
these 4 columns are all nullable booleans, so they can be TRUE,
On Sep 30, 2014, at 8:04 PM, John R Pierce pie...@hogranch.com wrote:
if col_1 IS NULL, then that OR condition doesn't make much sense. just
saying...
I was just making a quick example. There are two commonly used filter sets,
each are mostly on Bool columns that allow null -- but one
On Wednesday, October 1, 2014, Jonathan Vanasco postg...@2xlp.com wrote:
I'm trying to improve the speed of suite of queries that go across a few
million rows.
They use 2 main filters across a variety of columns:
WHERE (col_1 IS NULL ) AND (col_2 IS NULL) AND ((col_3 IS NULL) OR
15 matches
Mail list logo