I think its caused by hard reboots (may b hyper visor itself is rebooted!)
. Is there any setting which can reduce such problems ?
On Tue, Jun 7, 2016 at 5:30 PM, Craig Ringer wrote:
> On 7 June 2016 at 18:24, Nikhil wrote:
>
>> I am getting below error in my 2 node BDR setup. postgres going do
On Sat, Jun 11, 2016 at 9:03 PM, Christian Ohler wrote:
> we have a use case similar to auditing packages like pgMemento or Audit
> Trigger 91plus – we are looking to keep an ordered history of certain write
> transactions. I'm trying to understand the trade-offs between different
> ways of gett
On Tue, Jun 14, 2016 at 12:51 AM, Edson Richter
wrote:
> Em 14/06/2016 01:33, David G. Johnston escreveu:
>
> On Monday, June 13, 2016, Edson Richter <
> edsonrich...@hotmail.com> wrote:
>
>> Em 13/06/2016 23:36, Edson Richter escreveu:
>>
>> Em 13/06/2016 23:18, rob stone escreveu:
>>
>> On Mon
Dear PostgreSQL users,
I have a stored procedure defined as:
CREATE OR REPLACE FUNCTION words_merge_users(
IN in_users jsonb,
IN in_ip inet,
OUT out_uid integer)
RETURNS integer AS
$func$
...
$func$ LANGUAGE plpgsql;
Which I can successfully call at ps
On Tue, Jun 14, 2016 at 9:33 AM, Alexander Farber <
alexander.far...@gmail.com> wrote:
> Dear PostgreSQL users,
>
> I have a stored procedure defined as:
>
> CREATE OR REPLACE FUNCTION words_merge_users(
> IN in_users jsonb,
> IN in_ip inet,
> OUT out_uid integer)
>
> On Jun 14, 2016, at 7:33 AM, Alexander Farber
> wrote:
>
> Dear PostgreSQL users,
>
> I have a stored procedure defined as:
>
> CREATE OR REPLACE FUNCTION words_merge_users(
> IN in_users jsonb,
> IN in_ip inet,
> OUT out_uid integer)
> RETURNS integer AS
>
Please don't top-post.
On Tue, Jun 14, 2016 at 10:44 AM, Alexander Farber <
alexander.far...@gmail.com> wrote:
> Thank you, David -
>
> PreparedStatement st = mDatabase.prepareStatement("SELECT out_uid FROM
> words_merge_users(?::jsonb, ?::inet)");
>
> seems to work. Is it ok to call setStri
Thank you, David -
PreparedStatement st = mDatabase.prepareStatement("SELECT out_uid FROM
words_merge_users(?::jsonb, ?::inet)");
seems to work. Is it ok to call setString() then below?
String str1 = JSON.toString(users);
String str2 =
mSession.getRemoteAddress().getAddress()
Em 14/06/2016 10:32, David G. Johnston escreveu:
On Tue, Jun 14, 2016 at 12:51 AM, Edson Richter
mailto:edsonrich...@hotmail.com>>wrote:
Em 14/06/2016 01:33, David G. Johnston escreveu:
On Monday, June 13, 2016, Edson Richter mailto:edsonrich...@hotmail.com>> wrote:
Em 13/06/2
Hi Team ,
We have been trying to insert data (batch inserts) using a JAVA app which
uses prepared statements with parameterized queries to insert data .We are
able to insert data with small batch size however when we increase the
batch size to a higher value data ingestion fails . We are using
Hi,
I was working on a PgQ installation and found something odd which I'd
like to see if others here have bumped into regarding using pg_dump on a
database that has the pgq schema created by the extension.
If PgQ is installed as an extension (by executing CREATE EXTENSION pgq)
all the objects cre
Update on this –
Thanks for the feedback.
We just completed this process successfully. One thing we noticed was,
after creating the view and having the code start to read from it instead
of the table, we saw a significant postgres memory spike. It lasted until
we dropped the view and renamed the ta
On 06/14/2016 09:33 AM, Rupesh Choudhary wrote:
Hi Team ,
We have been trying to insert data (batch inserts) using a JAVA app
which uses prepared statements with parameterized queries to insert
data .We are able to insert data with small batch size however when we
increase the batch size to a
when I recreate a VIEW or
FUNCTION with a small change I get:
Query
returned successfully with no result in 03:58 minutes.
we
have pg 9.4
--
Best regards,
Catalin Maftei
www.plationline.eu
www.livrarionline.ro
www.c-soluti
On 06/14/2016 02:59 PM, Catalin Maftei wrote:
when I recreate a VIEW or FUNCTION with a small change I get:
What are the actual statements you are running?
What program are you running them from?
Is the server you are running the command against local or remote?
Query returned successful
Hi Adrian,
Please find anwer in line :
What is the SQL you are running?
-We have a table with about 167 columns and we are trying to run batch
updates on the table . I am attaching the part of code for your reference .
How is that being run in the code?
Yes , it is runs as a part of the code .
D
Dear All,
Thanks in advance.
I have doubt regarding release notes of all versions.
As per release notes, below change logs are mentioned in all versions.
"(8.3.8,8.4.1,8.2.14) Make LOAD of an already-loaded loadable module into a
no-op (Tom Lane)"
1. What is meaning of above lines?
2. This chan
17 matches
Mail list logo
