Anybody knows if $subject will make it into v11?
--
Andreas Joseph Krogh
På tirsdag 13. mars 2018 kl. 01:08:03, skrev Andreas Kretschmer <
andr...@a-kretschmer.de <mailto:andr...@a-kretschmer.de>>:
On 13 March 2018 00:58:27 CET, Andreas Kretschmer
wrote:
>On 12 March 2018 21:18:22 CET, Andreas Joseph Krogh
> wrote:
>>Anybody knows if $subje
0tc7-visena#VisenaEmail.2b.7dfa64bdab147c49.1600d1d9df0@tc7-visena
-- Andreas Joseph Krogh
om me. The default should be "no fence" for sake of least surprise I
think. Documenting the change would be sufficient.
I hope this will be picked up in the comming V12-cycle.
-- Andreas Joseph Krogh
CTO / Partner - Visena AS
Mobile: +47 909 56 963
andr...@visena.com <mail
På onsdag 27. juni 2018 kl. 11:44:05, skrev Adrien NAYRAT <
adrien.nay...@anayrat.info <mailto:adrien.nay...@anayrat.info>>:
On 06/27/2018 09:58 AM, Andreas Joseph Krogh wrote:
> >
> > but we have to settle on a way of controlling it.
>
> +1 from m
s expected behaviour?
Thanks.
--
Andreas Joseph Krogh
På fredag 03. august 2018 kl. 12:12:33, skrev Andreas Joseph Krogh <
andr...@visena.com <mailto:andr...@visena.com>>:
Version: PG-10.4
I don't (yet) have any replication-slots configured, and hence no standbys are
subscribed, but I have wal_level = logical configured
Any plans to support $subject?
Offloading the primary by replicating from standby would be very useful.
-- Andreas Joseph Krogh
CTO / Partner - Visena AS
Mobile: +47 909 56 963
andr...@visena.com <mailto:andr...@visena.com>
www.visena.com <https://www.visena.com>
<https://www.visena.com>
På torsdag 16. august 2018 kl. 14:18:12, skrev Andres Freund mailto:and...@anarazel.de>>:
On 2018-08-16 13:35:06 +0200, Andreas Joseph Krogh wrote:
> Any plans to support $subject?
There's LOADS of discussion on this on the lists.
I couldn't find anything specifically rega
På torsdag 16. august 2018 kl. 14:50:47, skrev Andres Freund mailto:and...@anarazel.de>>:
Hi,
On 2018-08-16 14:32:34 +0200, Andreas Joseph Krogh wrote:
> På torsdag 16. august 2018 kl. 14:18:12, skrev Andres Freund
<mailto:and...@anarazel.de>>:
> On 2018-08-16 13:35:06
6ubuntu3) 7.3.0, 64-bit │
└────────┘
(1 row)
andreak@[local]:5433 10.4 andreak=# select 'abcd'||chr(8198) ~ 'abcd\s';
┌──┐
│ ?column? │
├──┤
│ t │
└──┘
(1 row)
-- Andreas Joseph Krogh
CTO / Partner - Visena AS
Mobile: +47 909 56 963
andr...@visena.com <mailto:andr...@visena.com>
www.visena.com <https://www.visena.com>
<https://www.visena.com>
På torsdag 16. august 2018 kl. 16:32:40, skrev Adrian Klaver <
adrian.kla...@aklaver.com <mailto:adrian.kla...@aklaver.com>>:
On 08/16/2018 07:04 AM, Andreas Joseph Krogh wrote:
> char(2006) produces the wrong character as 2006 is the hex-value. You
> have to use 8198:
so it outputs only "10.5"?
Thanks in advance.
-- Andreas Joseph Krogh
CTO / Partner - Visena AS
Mobile: +47 909 56 963
andr...@visena.com <mailto:andr...@visena.com>
www.visena.com <https://www.visena.com>
<https://www.visena.com>
På mandag 03. september 2018 kl. 23:03:10, skrev Alvaro Herrera <
alvhe...@2ndquadrant.com <mailto:alvhe...@2ndquadrant.com>>:
On 2018-Sep-03, Andreas Joseph Krogh wrote:
> Hi all, I'm using the Ubuntu-packages and have this in my .psqlrc:
>
> \set PROMPT1
På mandag 03. september 2018 kl. 23:34:48, skrev Christoph Moench-Tegeder <
c...@burggraben.net <mailto:c...@burggraben.net>>:
## Andreas Joseph Krogh (andr...@visena.com):
> This results in this verver_version:
> 10.5 (Ubuntu 10.5-1.pgdg18.04+1)
>
> Is it possibl
På mandag 03. september 2018 kl. 23:43:46, skrev Rob Sargent <
robjsarg...@gmail.com <mailto:robjsarg...@gmail.com>>:
On 09/03/2018 03:42 PM, Alvaro Herrera wrote:
> On 2018-Sep-03, Andreas Joseph Krogh wrote:
>
>> select setting as server_version fro
n logs.
[...]
postgres 33438 1 0 12:41 ? 00:00:03 /u01/postgres/9.5/bin/postgres -D
/u02/pgdata01/9.5/data
[...]
postgres 110181 33438 0 15:30 ? 00:00:00 /u01/postgres/9.5/bin/postgres -D
/u02/pgdata01/9.5/data
Strange, the second is a child of the first... --
Andreas Joseph Krogh
the postgres now.
The installation was done as postgres user. make uninstall -- Andreas Joseph
Krogh CTO / Partner - Visena AS Mobile: +47 909 56 963 andr...@visena.com
<mailto:andr...@visena.com> www.visena.com <https://www.visena.com>
<https://www.visena.com>
På torsdag 05. september 2019 kl. 11:01:25, skrev Sonam Sharma <
sonams1...@gmail.com <mailto:sonams1...@gmail.com>>: It's saying gmake *** No
rule to make Target uninstall. On Thu, Sep 5, 2019, 2:27 PM Andreas Joseph
Krogh mailto:andr...@visena.com>> wrote: På torsdag 05.
al]:5432 11.5 test=# INSERT INTO Test( pKey, Val ) VALUES ( 2, 2 );
INSERT 0 1
andreak@[local]:5432 11.5 test=# UPDATE Test SET pKey = pKey + 1;
UPDATE 2
-- Andreas Joseph Krogh CTO / Partner - Visena AS Mobile: +47 909 56 963
andr...@visena.com <mailto:andr...@visena.com> www.visena
ere a single statement until I saw the Compatibility Remark in
documentation :Also, PostgreSQL checks non-deferrable uniqueness constraints
immediately, not at end of statement as the standard would suggest.
FWIW - PostgreSQL behaves like Oracle in this regard. -- Andreas Joseph Krogh
CTO / Part
rather
than an inherent Postgres issue.
regards, tom lane We experienced quite awful performance when we hosted the
DB on virtual servers (~5 years ago) and it turned out we hit the write-cache
limit (then 8GB), which resulted in ~1MB/s IO thruput. Running iozone might
help tracing down IO-problems. --
Andreas Joseph Krogh
#x27;t say that you can't charge a fee for
distributing (although why anybody would pay you for something they can
download themselves for free I don't know).
hp A rule of thumb is - you can do anything you want with it (the PG software
inc. its source), except claim you wrote it, as lon
På onsdag 18. september 2019 kl. 01:07:41, skrev Rob Sargent <
robjsarg...@gmail.com <mailto:robjsarg...@gmail.com>>: On Sep 17, 2019, at 4:18
PM, Andreas Joseph Krogh mailto:andr...@visena.com>> wrote:
På tirsdag 17. september 2019 kl. 22:55:02, skrev Peter J. Holzer
e start
waiting for server to start/bin/sh: 1: cannot create logfile: Permission
denied
stopped waiting
pg_ctl: could not start server
Examine the log output.
postgres@pc:/home/marco$ Start pg_ctl as postgres user, no need to sudo. --
Andreas Joseph Krogh CTO / Partner - Visena AS Mobile: +47
ot;logfile" in your command) in CWD (/home/macro).
Specify absolute path to somewhere writable for user "postgres". -- Andreas
Joseph Krogh CTO / Partner - Visena AS Mobile: +47 909 56 963 andr...@visena.com
<mailto:andr...@visena.com> www.visena.com <https://www.visena.com>
<https://www.visena.com>
8' negative-prefix is '−'(8722),
not '-'(45), at least in the JAVA-world, but it seems the JDBC-driver must use
lc_numeric='C' when parsing server output. -- Andreas Joseph Krogh CTO / Partner
- Visena AS Mobile: +47 909 56 963 andr...@visena.com
<mailto
På torsdag 26. september 2019 kl. 00:53:28, skrev Tom Lane mailto:t...@sss.pgh.pa.us>>: Andreas Joseph Krogh writes:
> Can anybody shed som light
> on when negative-prefix is supposed to be respected by PG's
> formatting-functions? In lc_numeric='nb_NO.UTF-8'
to do logical replication from standby like I'm looking for in
this thread:
https://www.postgresql.org/message-id/VisenaEmail.15.9f118cec79ac2589.1621cfd8405%40tc7-visena
<https://www.postgresql.org/message-id/VisenaEmail.15.9f118cec79ac2589.1621cfd8405%40tc7-visena>
? Thanks. -- Andreas
-10-08 15:45:29.654 CEST [8829-78] LOG: terminating any other active
server processes
Will running a debug-enabled build slow things noticably down? Is there a way
to make it dump a stack-trace (or back-trace in C-land?) on sig11? -- Andreas
Joseph Krogh CTO / Partner - Visena AS Mobile: +47 909
På tirsdag 08. oktober 2019 kl. 17:24:21, skrev Tom Lane mailto:t...@sss.pgh.pa.us>>: Andreas Joseph Krogh writes:
> Will running a debug-enabled build slow things noticably down?
gcc promises that the generated code is the same with or without debug.
I think clang does too. W
På tirsdag 08. oktober 2019 kl. 17:24:21, skrev Tom Lane mailto:t...@sss.pgh.pa.us>>: Andreas Joseph Krogh writes:
> Will running a debug-enabled build slow things noticably down?
gcc promises that the generated code is the same with or without debug.
I think clang does too. W
På onsdag 09. oktober 2019 kl. 16:16:37, skrev Tom Lane mailto:t...@sss.pgh.pa.us>>: Andreas Joseph Krogh writes:
> Attached is output from "bt full". Is this helpful?
Well, it shows that the failure is occurring while trying to evaluate
a variable in a trigger's WHE
På torsdag 10. oktober 2019 kl. 07:25:26, skrev Andres Freund <
and...@anarazel.de <mailto:and...@anarazel.de>>: On 2019-10-09 10:16:37 -0400,
Tom Lane wrote:
> Andreas Joseph Krogh writes:
> > Attached is output from "bt full". Is this helpful?
>
&g
We had another crash today, and it appears to be the same: #0
slot_deform_heap_tuple (natts=26, offp=0x5598eba0b968,
tuple=, slot=0x5598eba0b920)
at ./build/../src/backend/executor/execTuples.c:895 -- Andreas Joseph Krogh
tch if you're in a position to
build from source ...
regards, tom lane
Yes, we've built a new .deb-package from
f224c7c11ea7be2751e3342e11317070ffb5622d in REL_12_STABLE which we'll deploy
tonight.
Thanks!
--
Andreas Joseph Krogh
a Andreas sent off-list) on the predecessor of
> that commit, but on that commit it's fine.
Cool, and thanks for checking.
No crashes in production after deploying the fix.
--
Andreas Joseph Krogh
m"-messages when restoring a
database, just ignore them.
If it bothers you, just turn autovacuum off by setting this in postgresql.conf:
autovacuum = off
and reload the config (SIGHUP)
--
Andreas Joseph Krogh
BASE
Time: 280,355 ms
--
Andreas Joseph Krogh
CTO / Partner - Visena AS
Mobile: +47 909 56 963
andr...@visena.com <mailto:andr...@visena.com>
www.visena.com <https://www.visena.com>
<https://www.visena.com>
--
Andreas Joseph Krogh
CTO / Partner - Visena AS
Mobile: +47 909 56 963
andr...@visena.com <mailto:andr...@visena.com>
www.visena.com <https://www.visena.com>
<https://www.visena.com>
y restore them in order to start the recovered PostgreSQL
instance:
postgresql.conf
pg_hba.conf
pg_ident.conf
Recovery completed (start time: 2018-12-06 13:14:53.220043, elapsed time: 4
hours, 52 minutes, 47 seconds)
Your PostgreSQL server has been successfully prepared for recovery!
=
rrectly?
2. If I need a 3rd "logical trigger", is it enough to add another trigger
named accordingly, for instance "trigger_1_someotherstuff", and add it's column
to the "UPDATE OF"-list of "trigger_2" (it it uses a column not already listed
there)?
3. Is there some easier way to do this?
Is it clear what I'm asking about? :-)
Thanks.
--
Andreas Joseph Krogh
;
It might be easier to understand if sketch out a schematic version of
what you are trying to achieve.
The point is; I want to functions to be called
- update_company_fts_tf()
- company_parent_no_cycle()
, each only once, as constraint-triggers on the same table. So they are called
by the "level 1 triggers" which must fire first.
Is it clearer now what I'm trying to achieve?
--
Andreas Joseph Krogh
På torsdag 24. oktober 2019 kl. 16:59:42, skrev Adrian Klaver <
adrian.kla...@aklaver.com <mailto:adrian.kla...@aklaver.com>>:
On 10/22/19 8:26 AM, Andreas Joseph Krogh wrote:
> På tirsdag 22. oktober 2019 kl. 17:12:59, skrev Adrian Klaver
> mailto:adrian.kla...@aklaver.
qv3gesl32%40alap3.anarazel.de
<https://www.postgresql.org/message-id/flat/20181212204154.nsxf3gzqv3gesl32%40alap3.anarazel.de>
--
Andreas Joseph Krogh
row_count; raise notice 'deleted % rows', num_rows; exit when num_rows = 0; end
loop; end;$_$;
--
Andreas Joseph Krogh
.com/impossibl/pgjdbc-ng
<https://github.com/impossibl/pgjdbc-ng>
We use it with Blobs/Clobs and it's working good.
It would help us help you if you mention which IDEs you have tried, and
provide configuration-paramteres, error-messages etc.
--
Andreas Joseph Krogh
CTO / Partne
for you? Did you dump
to "directory format" first, then restore? If so, then that requires quite a
bit of temp-space...
--
Andreas Joseph Krogh
CTO / Partner - Visena AS
Mobile: +47 909 56 963
andr...@visena.com <mailto:andr...@visena.com>
www.visena.com <https://www.visena.com>
<https://www.visena.com>
ot rum) for the
exact same reasons as Evergreen (it seems). We have to mix FTS with
domain-specific logic/filtering and that is based on relational data in the
database. I don't see how we could have done that using an external
search-engine. Maybe it's easy, I don't have any expe
this,
then there’s no point and we can wrap this up. But if not, I will happily post
what I have. Thank you.
This is too much prose for the regular programmer, show us the code, and point
out what doesn't work for you, then we can help:-)
--
Andreas Joseph Krogh
e[]. With LOs and java.sql.Blob
(which the standard pgjdbc-dirver doesn't support ,but pgjdbc-ngdoes) it
acutally uses strams and memory is kept down to a minimum.
--
Andreas Joseph Krogh
ay" does not exist
What bigintvarchar_to_text_value_flatten() does is to take the "varchar"-part
out of the BigintVarchar-type and "flatten" the array by that value so that it
sorts nicely.
Any way round this?
--
Andreas Joseph Krogh
På torsdag 28. mai 2020 kl. 14:50:54, skrev Geoff Winkless mailto:pgsqlad...@geoff.dj>>:
On Thu, 28 May 2020 at 13:14, Andreas Joseph Krogh wrote:
> This works:
> select p.firstname, p.lastname, p.firstname || p.lastname as fullname from
onp_crm_person p order by fullname;
&
På torsdag 28. mai 2020 kl. 15:26:42, skrev Tom Lane mailto:t...@sss.pgh.pa.us>>:
Andreas Joseph Krogh writes:
> Is there a way to define "sorting-rules" on custom-types so that I can have
> ORDER BY and PG will pick my custom
odering?
You'd have to write your
gree this would be a huge step in the right
direction for pg-DBAs.
I have absolutely no clue about how much work is required etc., but I think
it's kind of strange that no companies have invested in making this happen.
--
Andreas Joseph Krogh
nient matter, which other RDBMS-vendors seem to provide.
I love PG, have been using it professionally since 6.5, and our company
depends on it, but there are things other RDBMS-vendors do better...
--
Andreas Joseph Krogh
om a few hundred milliseconds
to 5-10 minutes, after which it is deleted.
[...]
In my experience vacuumlo, https://www.postgresql.org/docs/12/vacuumlo.html
<https://www.postgresql.org/docs/12/vacuumlo.html>, is needed to remove large
objects, before vacuum can remove them from pg_largeobject.
but be warned that it would require
non-trivial
> changes to your application.
not really with BDR3 ;-)
Well, BDR, last time I checked, still doesn't support exclusion-constraints,
so it's not a drop-in replacement.
--
Andreas Joseph Krogh
xecute further statements. The java.sql.Connection is "invalid"
after an SQLException and should be rolled back.
--
Andreas Joseph Krogh
actually run out of WAL-space in production because of this.
I see this TODO-entry in RUM:
* Improve GENERIC WAL to support shift (PostgreSQL core changes).
What is the status on this?
--
Andreas Joseph Krogh
CTO / Partner - Visena AS
Mobile: +47 909 56 963
andr...@visena.com
s
user 92m4,833s
sys 2m18,565s
Here are the sizes of all:
7,4G pg_backup (directory with -Fd)
32G visena.dmp
5,8G visena.dmp.bz2
--
Andreas Joseph Krogh
CTO / Partner - Visena AS
Mobile: +47 909 56 963
andr...@visena.com <mailto:andr...@visena.com>
www.visena.com <https://www.visena.com>
<https://www.visena.com>
TE PROCEDURE do_stuff();
I want the trigger to be fired when the column "modified" is NOT specified, is
it possible?
Or - is it possible to check for this in the trigger-function?
--
Andreas Joseph Krogh
CTO / Partner - Visena AS
Mobile: +47 909 56 963
andr...@visena.com <mailto:a
På fredag 25. desember 2020 kl. 17:48:39, skrev Adrian Klaver <
adrian.kla...@aklaver.com <mailto:adrian.kla...@aklaver.com>>:
On 12/25/20 5:52 AM, Andreas Joseph Krogh wrote:
> Hi.
> I need to set a value in a trigger if a column is explicitly NOT
> specified in UPDATE&
s on purpose. PG doesn't store queries you feed it either, nor any other
command. It stores the resulting structure. SQL-scripts, containing DDL/DML
should be versioned using scm like Git, not rely on the DB to store it.
--
Andreas Joseph Krogh
Hi, I have set join_collapse_limit = 12 in production, but I'm thinking about
raising it to 16.
On modern HW is there a “sane maximum” for this value?
I can easily spare 10ms for extra planning per query on our workload, is 16
too high?
Thanks.
--
Andreas Joseph Krogh
CTO / Pa
com#15cbf1c82be9341e551e60e287264380>
We'd be willing to help funding development needed to support Large Object
logical replication.
Anyone interested?
--
Andreas Joseph Krogh
CTO / Partner - Visena AS
Mobile: +47 909 56 963
andr...@visena.com <mailto:andr...@visena.com>
www.
På torsdag 09. juni 2022 kl. 20:24:56, skrev Joshua Drake
mailto:j...@commandprompt.com>>:
Large objects are largely considered a deprecated feature.
Though I like the idea, was there any consensus on -hackers?
Nobody seems interested in it…
--
Andreas Joseph Krogh
CTO / P
org/docs/current/runtime-config-query.html#GUC-EFFECTIVE-CACHE-SIZE>
--
Andreas Joseph Krogh
ll projects, maybe
not... I.e. with real client-case of 3K projects,
that puts an average of only 10GB of lo's per-project (i.e. schema),
which could very well be problematic...
--
Andreas Joseph Krogh
CTO / Partner - Visena AS
Mobile: +47 909 56 963
andr...@visena.com <mailto:andr...@visena.com>
www.visena.com <https://www.visena.com>
<https://www.visena.com>
På onsdag 19. oktober 2022 kl. 12:48:24, skrev Dominique Devienne <
ddevie...@gmail.com <mailto:ddevie...@gmail.com>>:
On Wed, Oct 19, 2022 at 12:17 PM Andreas Joseph Krogh mailto:andr...@visena.com>> wrote:
First advice, don't do it. We started off storing blobs in
På onsdag 19. oktober 2022 kl. 13:21:38, skrev Dominique Devienne <
ddevie...@gmail.com <mailto:ddevie...@gmail.com>>:
On Wed, Oct 19, 2022 at 1:00 PM Andreas Joseph Krogh
wrote:
> Ok, just something to think about;
Thank you. I do appreciate the feedback.
> Will your da
På torsdag 20. oktober 2022 kl. 10:32:44, skrev Dominique Devienne <
ddevie...@gmail.com <mailto:ddevie...@gmail.com>>:
On Wed, Oct 19, 2022 at 5:05 PM Laurenz Albe wrote:
> On Wed, 2022-10-19 at 12:48 +0200, Dominique Devienne wrote:
> > On Wed, Oct 19, 2022 at 12:17 PM
VM. In other words, disk IO is
what you should be worried about as VMs are pretty good at scaling CPU-wise.
--
Andreas Joseph Krogh
CTO / Partner - Visena AS
Mobile: +47 909 56 963
andr...@visena.com <mailto:andr...@visena.com>
www.visena.com <https://www.visena.com>
<https://www.visena.com>
quot;details": [ {
"keyInformation": { "organizationType": "LIMITED_COMPANY" } }, {
"keyInformation": { "dunsNumber": "123", "organizationType": "LIMITED_COMPANY"
} } ], "nisse": 123 }
Thanks.
--
Andreas Joseph Krogh
CTO / Partner - Visena AS
Mobile: +47 909 56 963
andr...@visena.com <mailto:andr...@visena.com>
www.visena.com <https://www.visena.com>
<https://www.visena.com>
;a"]
jsonb #- text[] → jsonb
Deletes the field or array element at the specified path, where path elements
can be either field keys or array indexes.
'["a", {"b":1}]'::jsonb #- '{1,b}' → ["a", {}]
Regards
I have looked at the docs, but it doesn
Excellent!
Thanks!
På lørdag 18. mars 2023 kl. 14:26:57, skrev Boris Zentner mailto:b...@2bz.de>>:
Am 17.03.2023 um 08:56 schrieb Andreas Joseph Krogh :
Hi, in PG-14, how do I delete the keys "dunsNumber": "NaN":
{ "sessionId": "ce6fc9
advantages?
I find that not one bit surprising.
I've used PG since 90's and it's no secret the "big guys" beat PG on certain
workloads.
-- Andreas Joseph Krogh
På tirsdag 23. oktober 2018 kl. 23:36:29, skrev Adrian Klaver <
adrian.kla...@aklaver.com <mailto:adrian.kla...@aklaver.com>>:
On 10/23/18 2:34 PM, Andreas Joseph Krogh wrote:
> På tirsdag 23. oktober 2018 kl. 22:45:36, skrev Adrian Klaver
> mailto:adrian.kla...@aklaver.com>
ote for this solution (maybe
adding other restrictions) ?
Regards
PAscal
Scala (scala-lang.org) moved from mailing-list to Discourse a while ago and
it's in my oppinion a disaster. No matter what they tell you, it does _not_
work well with email-only. Replying, quoting and reading history is a mess imo.
--
Andreas Joseph Krogh
ent_database()));
-- Andreas Joseph Krogh
de(sha512('A'), 'hex')"
21b4f4bd9e64ed355c3eb676a28ebedaf6d8f17bdc365995b319097153044080516bd083bfcce66121a3072646994c8430cc382b8dc543e84880183bf856cff5
Thanks!
-- Andreas Joseph Krogh
CTO / Partner - Visena AS
Mobile: +47 909 56 963
andr...@visena.com <mailto:andr...@vi
På mandag 14. januar 2019 kl. 16:18:30, skrev Thomas Markus <
t.mar...@proventis.net <mailto:t.mar...@proventis.net>>:
Hi,
echo contains a trailing carriage return. Try
echo -n "A" | sha512sum
regards
Thomas
Ha ha, didn't think of that!
Thanks:-)
-- Andreas
e_group)then raise notice 'Group % not found,
creating it.', :quoted_resource_group; end if; end; $$;
ERROR: syntax error at or near ":"
LINE 3: ... exists(SELECT * FROM tbl_group WHERE groupname = :quoted_re...
^
På tirsdag 15. januar 2019 kl. 16:51:09, skrev Andreas Joseph Krogh <
andr...@visena.com <mailto:andr...@visena.com>>:
Hi all.
I'm trying to use a psql variable in a DO-block, but it fails:
[snip]
Seems I was a bit lazy, here's what works:
\set resource_
_id | valid | parent | child | valid | node_id | valid
-+---++---+---+-+---
(0 rows)
The moment you involve columns on "left joined" relations this way in the
WHERE-clause, it effectively becomes a right join.
-- Andreas Joseph Krogh
CTO / Partner - Visena AS
Mobi
support for BDR. If you really needs a
worldwide distributed multi-master solution you should be able to buy that.
Regards, Andreas To my surprise I'm unable to find downloadable BDR3. I
thought it was an open-source extention to vanilla-pg-11, isn't that the case
anymore?
09.2
OS: Ubuntu 18.04.2
Please tell me if you have any idea how to fix or debug this. I already asked
multiple people, and no one has a clue what is going on.
Best,
Felix Ableitner
Does disabling index-scan make a difference? SET enable_indexscan to off;
How about dumping the relevant dat
ttings.
You can now see all SQL executed in the log and can debug what's going on. --
Andreas Joseph Krogh CTO / Partner - Visena AS Mobile: +47 909 56 963
andr...@visena.com <mailto:andr...@visena.com> www.visena.com
<https://www.visena.com> <https://www.visena.com>
turn off logging again by setting it to 'none' and reload
settings (no need to restart). You can also only log modifications by setting
log_statement = 'mod' Also watch out for triggers modifying stuff. -- Andreas
Joseph Krogh CTO / Partner - Visena AS Mobile: +47 9
use IntelliJ IDEA for development (has syntax highlight, code
completion, introspection etc.). IDEA has a PostgreSQL plugin which is only
commercially available, and uses the same components as DataGrip, AFAIK.
--
Andreas Joseph Krogh
CTO / Partner - Visena AS
Mobile: +47 909 56 963
andr..
ee dispenser. Things some feel they need in a management tool.
If you need these things, I'm sure there's a budget somewhere for investing in
available commercial tools, some already mentioned in this thread.
--
Andreas Joseph Krogh
CTO / Partner - Visena AS
Mobile: +47 909 56
På onsdag 16. august 2023 kl. 05:40:40, skrev Ron mailto:ronljohnso...@gmail.com>>:
On 8/15/23 02:23, Jason Long wrote:
[snip]
> Does PostgreSQL have an option to increase speed?
Like a Turbo button?
It actually has that, but you'll have to sacrifice some safety.
--
Andrea
l.org/docs/release/15.0/>
They all state the same:
“A dump/restore using pg_dumpall or use of pg_upgrade or logical replication
is required for those wishing to migrate data from any previous release.”
--
Andreas Joseph Krogh
CTO / Partner - Visena AS
Mobile: +47 909 56 963
andr...@v
= t.id)
OR NOT EXISTS (
select * from stuff s where s.test_id = t.id
)
)
;
So, I want to return all entries in test not having any of ARRAY ['x', 'y',
'z', 't'] referenced in the table stuff, and I'd like to have test.id="d"
returned as well, but in order to do that I need to execute the “or not
exists”-query. Is it possible to avoid that?
--
Andreas Joseph Krogh
CTO / Partner - Visena AS
Mobile: +47 909 56 963
andr...@visena.com <mailto:andr...@visena.com>
www.visena.com <https://www.visena.com>
<https://www.visena.com>
På lørdag 25. november 2023 kl. 17:08:28, skrev Tom Lane mailto:t...@sss.pgh.pa.us>>:
Andreas Joseph Krogh writes:
> -- This works, but I'd rather not do the extra EXISTS
> select * from test t
> WHERE (NOT ARRAY ['x', 'y', 'z', 't'
set in the past,
but want to show lines with start-dates in future.
This seems to do what I want:
NOT (drange << daterange(CURRENT_DATE, NULL, '[)'))
But this doesn't use the index.
Any idea how to write a query so it uses the index on drange?
Thanks.
--
And
NULL::date, '[)'::text))) │ │ Rows Removed by Filter: 1
│ │ Planning Time: 0.077 ms │ │ Execution Time: 0.015 ms │
└─────────────┘
--
Andreas Joseph Krogh
CTO / Partner - Vis
t; have a negator operator that could
allow the NOT to be simplified out.
Wouldn't
drange && daterange(CURRENT_DATE, NULL, '[)')
serve the purpose? That should be indexable.
regards, tom lane
Yes it will, thanks.
--
Andreas Joseph Krogh
CTO / Partner - Visena AS
M
d agree that use of LOBs for this purpose was not necessary.
Well, the data is there nonetheless, is it an option to convert it to bytea
before migration?
--
Andreas Joseph Krogh
CTO / Partner - Visena AS
Mobile: +47 909 56 963
andr...@visena.com <mailto:andr...@visena.com>
www
oils down to how badly the ones in charge wants this
migration…
--
Andreas Joseph Krogh
CTO / Partner - Visena AS
Mobile: +47 909 56 963
andr...@visena.com <mailto:andr...@visena.com>
www.visena.com <https://www.visena.com>
<https://www.visena.com>
1 - 100 of 147 matches
Mail list logo
