After inlining the data, performance issues have been solved. Thanks for
the help.
On Mon, Sep 3, 2018 at 9:57 PM Mate Varga wrote:
> Thanks,
> 1) we'll try to move stuff out from LOBs
> 2) we might raise a PR for the JDBC driver
>
> Mate
>
> On Mon, 3 Sep 2018, 19:35 Dave Cramer, wrote:
>
>>
>
Hi
On Thu, Sep 6, 2018 at 6:23 AM, jimmy wrote:
> I use PostgreSQL-10.5-1-win64-bigsql.exe to install postgresql database.
> How to install pgAgent on windows for postresql-bigsql-10.5.
> I have been searching some articles to install pgAgent.
> But they do not work.
> I found there has not any
Is EnterpriseDB opensource and free. Has this database some limits and
restrictions ?
At 2018-09-06 15:57:30, "Dave Page" wrote:
Hi
On Thu, Sep 6, 2018 at 6:23 AM, jimmy wrote:
I use PostgreSQL-10.5-1-win64-bigsql.exe to install postgresql database.
How to install pgAgent on windows
Hi
Can you be more explicit how you fixed the problem ?
Thanks
Dave Cramer
da...@postgresintl.com
www.postgresintl.com
On Thu, 6 Sep 2018 at 03:46, Mate Varga wrote:
> After inlining the data, performance issues have been solved. Thanks for
> the help.
>
> On Mon, Sep 3, 2018 at 9:57 PM Mate
On Thu, Sep 6, 2018 at 9:41 AM, jimmy wrote:
> Is EnterpriseDB opensource and free. Has this database some limits and
> restrictions ?
>
The EDB PostgreSQL installers are free, opensource and have no limits or
restrictions. They are the very first option at
https://www.postgresql.org/download/wi
Hi,
summarizing:
we had a table that had an OID column, referencing an object in
pg_largeobject. This was mapped to a (Java) entity with a byte array field,
annotated with @Lob. The problem was that we were fetching thousands of
these entities in one go, and LOB fetching is not batched by Hibernat
Hi Mate,
Thanks for the detailed response. This will help others in the same
situation
Dave Cramer
da...@postgresintl.com
www.postgresintl.com
On Thu, 6 Sep 2018 at 05:03, Mate Varga wrote:
> Hi,
>
> summarizing:
> we had a table that had an OID column, referencing an object in
> pg_largeobj
On 09/03/2018 09:11 AM, Lutz Gehlen wrote:
Hello all,
unfortunately, I have so far not received a reply to my question
below. I am well aware that no one has an obligation to reply; I was
just wondering whether I phrased my question badly or whether there
is anything else I could do to improve i
Hi:
I'm having trouble with this query...
select sr.sqf_id, sr.status, fse.perl_sub_name, fse.end_datetime
from
sqf_runs sr,
(select perl_sub_name, end_datetime from flow_step_events_view where
sqf_id = sr.sqf_id order by 2 limit 1) fse
where sr.userid='foo';
ERROR: invalid referenc
On 09/06/2018 01:59 PM, David Gauthier wrote:
I'm having trouble with this query...
select sr.sqf_id, sr.status, fse.perl_sub_name, fse.end_datetime
from
sqf_runs sr,
(select perl_sub_name, end_datetime from flow_step_events_view
where sqf_id = sr.sqf_id order by 2 limit 1) fse
David Gauthier writes:
> I'm having trouble with this query...
> select sr.sqf_id, sr.status, fse.perl_sub_name, fse.end_datetime
> from
> sqf_runs sr,
> (select perl_sub_name, end_datetime from flow_step_events_view where
> sqf_id = sr.sqf_id order by 2 limit 1) fse
> where sr.userid
Not quite. This returns one value. In the actual "sqf_runs" table, there
are many records with user_id = 'foo'. I want one line for each where the
fse.p-erl_sub_name and fse.end_datetime values are the latest values found
in the flow_step_events_view view where the sqf_ids match.
On Thu, Sep 6,
Wow, I take that back. I thought there were many recs with "foo" but there
wa sonly one.
When I ran this against a value that actually had multiple records, it ran
fine.
Sorry for that.
And Thanks for this query !
On Thu, Sep 6, 2018 at 5:15 PM David Gauthier
wrote:
> Not quite. This returns
Version 10
33.18. SSL Support
The pointers off to hp.com seem to have gone away on or about
28Aug2018. They also fall under the heading of HP OpenVMS Systems Doc
which may explain why they've disappeared.
Sorry. I didn't see the specific form for documentations issues.
On 09/06/2018 04:52 PM, Rob Sargent wrote:
Version 10
33.18. SSL Support
The pointers off to hp.com seem to have gone away on or about
28Aug2018. They also fall under the heading of HP OpenVMS Systems Doc
which may explain
Hi,
Will pgbackrest properly backup and restore the cluster if data/base,
data/pg_xlog and data/pg_log are symlinks?
PGDATA=/var/lib/pgsql/9.6/data
$PGDATA/base -> /Database/9.6/base
$PGDATA/pg_log -> /Database/9.6/pg_log
$PGDATA/pg_xlog -> /Database/9.6/pg_xlog
(I'm not just defining data_di
Hi Michael,
I'm attaching the output of diff .
> If we could prove that sha2-openssl.c is actually
unreliable even if FIPS is enabled system-wide with either SCRAM
authentication or any of the other hashing functions, then I would be
ready to accept a patch. Now, as far as I can see and heard f
17 matches
Mail list logo
