Thank you Rob,
question is it is the optimal way to run SP from VBA?
Or not?
Best,
Jacek
2018-06-19 1:34 GMT+02:00 Rob Sargent :
>
>
> On Jun 18, 2018, at 9:47 AM, Łukasz Jarych wrote:
>
> Hi Guys,
>
> i have example function :
>
> CREATE OR REPLACE FUNCTION totalRecords ()
> RETURNS integer
Sherrylyn Branchaw writes:
>> Hm ... were these installations built with --enable-cassert? If not,
>> an abort trap seems pretty odd.
> The packages are installed directly from the yum repos for RHEL. I'm not
> aware that --enable-cassert is being used, and we're certainly not
> installing from
I would also add that AWS' I/O capabilities are quite poor and expensive. I
assume that you have tried purchasing additional IOOPs on that setup to see
whether you got an expected speed up? If not you should try that as a
diagnostic tool even if you wouldn't want to pay that on an ongoing basis.
> On Jun 18, 2018, at 4:33 PM, Robert Creager wrote:
>
>> I cannot explain the discrepancy between the runtimes of 85 seconds versus
>> 10857 seconds.
>
> It would be nice if the auto_explain analyze did include the other
> information like the psql analyze does.
Like this. I’ll try
> Hm ... were these installations built with --enable-cassert? If not,
> an abort trap seems pretty odd.
The packages are installed directly from the yum repos for RHEL. I'm not
aware that --enable-cassert is being used, and we're certainly not
installing from source.
> Those "incomplete data"
> On Jun 18, 2018, at 9:47 AM, Łukasz Jarych wrote:
>
> Hi Guys,
>
> i have example function :
>
> CREATE OR REPLACE FUNCTION totalRecords ()
> RETURNS integer AS $total$
> declare
> total integer;
> BEGIN
>SELECT count(*) into total FROM COMPANY;
>RETURN total;
> END;
>
> On Jun 18, 2018, at 9:47 AM, Łukasz Jarych wrote:
>
> CREATE OR REPLACE FUNCTION totalRecords ()
> RETURNS integer AS $total$
> declare
> total integer;
> BEGIN
>SELECT count(*) into total FROM COMPANY;
>RETURN total;
> END;
> $total$ LANGUAGE plpgsql;
> On Jun 18, 2018, at 4:04 PM, Laurenz Albe wrote:
>
> Robert Creager wrote:
>> A different query started showing up as the problem, the auto_explain with
>> analyze shows an oddity,
>> the total query duration is 11k seconds, while the query itself is 3
>> seconds. I captured a ZFS
>>
On 2018-06-18 18:43:06 -0300, Juan Manuel Cuello wrote:
> I'm experiencing high WriteLatency levels in a Postgres server 9.3.20
> hosted in Amazon RDS.
A lot of performance improvements have been made since 9.3, and it'll
soon-ish be out of support.
If you can reproduce the issue on postgres
Robert Creager wrote:
> A different query started showing up as the problem, the auto_explain with
> analyze shows an oddity,
> the total query duration is 11k seconds, while the query itself is 3 seconds.
> I captured a ZFS
> snapshot as soon as the problem was noticed.
>
>
Hi,
I'm experiencing high WriteLatency levels in a Postgres server 9.3.20
hosted in Amazon RDS. So far it's been almost two months of investigation
and people at AWS technical support don't seem to find the cause. I think
it could be related to Postgres and the number of schema/tables in the
On Mon, Jun 18, 2018 at 1:03 PM, Tom Lane wrote:
> Hm, I supposed that Sherrylyn would've noticed any PANIC entries in
> the log. The TRAP message from an assertion failure could've escaped
> notice though, even assuming that her logging setup captured it.
Unhandled C++ exceptions end up
Andres Freund writes:
> On 2018-06-18 12:30:13 -0400, Tom Lane wrote:
>> Sherrylyn Branchaw writes:
>>> LOG: server process (PID 138529) was terminated by signal 6: Aborted
>> Hm ... were these installations built with --enable-cassert? If not,
>> an abort trap seems pretty odd.
> PANIC does
> On Jun 7, 2018, at 4:18 PM, Robert wrote:
>
>> You can capture the execution plan of the bad statement by using
>> auto_explain,
>> that would certainly shed more light on the problem.
>
A different query started showing up as the problem, the auto_explain with
analyze shows an oddity,
On 2018-06-18 12:30:13 -0400, Tom Lane wrote:
> Sherrylyn Branchaw writes:
> > We are using Postgres 9.6.8 (planning to upgrade to 9.6.9 soon) on RHEL 6.9.
> > We recently experienced two similar outages on two different prod
> > databases. The error messages from the logs were as follows:
> >
Sherrylyn Branchaw writes:
> We are using Postgres 9.6.8 (planning to upgrade to 9.6.9 soon) on RHEL 6.9.
> We recently experienced two similar outages on two different prod
> databases. The error messages from the logs were as follows:
> LOG: server process (PID 138529) was terminated by signal
Hi Guys,
i have example function :
CREATE OR REPLACE FUNCTION totalRecords ()
RETURNS integer AS $total$
declare
total integer;
BEGIN
SELECT count(*) into total FROM COMPANY;
RETURN total;
END;
$total$ LANGUAGE plpgsql;
and i want to run it from VBA using odbc connection.
What is the
Greetings,
We are using Postgres 9.6.8 (planning to upgrade to 9.6.9 soon) on RHEL 6.9.
We recently experienced two similar outages on two different prod
databases. The error messages from the logs were as follows:
LOG: server process (PID 138529) was terminated by signal 6: Aborted
LOG:
On 06/18/2018 06:24 AM, Jeremy Finzel wrote:
On Fri, Jun 15, 2018 at 2:57 PM, Adrian Klaver
mailto:adrian.kla...@aklaver.com>> wrote:
On 06/15/2018 12:24 PM, Jeremy Finzel wrote:
Hello!
We often prefer to use timestamptz or "timestamp with time zone"
in our
On Fri, Jun 15, 2018 at 2:57 PM, Adrian Klaver
wrote:
> On 06/15/2018 12:24 PM, Jeremy Finzel wrote:
>
>> Hello!
>>
>> We often prefer to use timestamptz or "timestamp with time zone" in our
>> environment because of its actually storing "objective time" with respect
>> to UTC. But in my own
Hi Bruno,
On Mon, 2018-06-18 at 08:31 -0400, Bruno Lavoie wrote:
>
> Sorry, me too just saw your email...
>
> Issue still persists:
>
> # reposync --repoid=pgdg10 --gpgcheck
> --download_path=/var/www/html/centos7/repos/postgresql/
> Repository 'base' is missing name in configuration, using
Hi Devrim,
Sorry, me too just saw your email...
Issue still persists:
# reposync --repoid=pgdg10 --gpgcheck
--download_path=/var/www/html/centos7/repos/postgresql/
Repository 'base' is missing name in configuration, using id
Removing mysql_fdw_10-2.3.0-3.rhel7.x86_64.rpm due to failed signature
Hi,
I'm researchingon pglogical,performing tests to see the impact on the network
traffic, in comparisonwith streaming replication.
I configured one provider and one subscriber both running on a VM, both on
Postgres 9.6.3 and latest pglogical 2.2.0.
Forcomparison, Ialso have one master and
Hello All,
I am currently using PostgreSQL Community version 10.3 and then using this
instance, I am doing logical replication(using *PGLOGICAL 2.2 *plugin) and
it is working perfectly fine as per my use-case based on PostgreSQL to
PostgreSQL replication.
The use-case here is I want to utilize
24 matches
Mail list logo
