AI for query-planning?

Hi, are there any plans for using some kind of AI for query-planning? Can someone with more knowledge about this than I have please explain why it might, or not, be a good idea, and what the challenges are? Thanks. -- Andreas Joseph Krogh CTO / Partner - Visena AS Mobile: +47 909 56

Re: prevent users from SELECT-ing from pg_roles/pg_database

På tirsdag 28. mai 2024 kl. 01:48:17, skrev Tom Lane mailto:t...@sss.pgh.pa.us>>: Laurenz Albe writes: > On Mon, 2024-05-27 at 09:33 +0200, Andreas Joseph Krogh wrote: >> I tried: >> REVOKE SELECT ON pg_catalog.pg_database FROM public; >> But that doesn't prevent

Re: prevent users from SELECT-ing from pg_roles/pg_database

På mandag 27. mai 2024 kl. 11:10:10, skrev Laurenz Albe < laurenz.a...@cybertec.at <mailto:laurenz.a...@cybertec.at>>: On Mon, 2024-05-27 at 09:33 +0200, Andreas Joseph Krogh wrote: > I tried: > > REVOKE SELECT ON pg_catalog.pg_database FROM public; > > But that do

Re: prevent users from SELECT-ing from pg_roles/pg_database

På fredag 24. mai 2024 kl. 19:02:13, skrev Tom Lane mailto:t...@sss.pgh.pa.us>>: Andreas Joseph Krogh writes: > Hi, is there a way to prevent a user/role from SELECT-ing from certain > system-tables? > I'd like the contents of pg_{user,roles,database} to not be visible

prevent users from SELECT-ing from pg_roles/pg_database

Hi, is there a way to prevent a user/role from SELECT-ing from certain system-tables? I'd like the contents of pg_{user,roles,database} to not be visible to all users. Thanks. -- Andreas Joseph Krogh CTO / Partner - Visena AS Mobile: +47 909 56 963 andr...@visena.com <mailto:a

RE: Performance degradation after upgrading from 9.5 to 14

nd so wonder why this default is on? I can confirm this, even in v16 we've turned JIT off. -- 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>

Parallel GIN index?

Any plans for $subject? -- 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>

Sv: Support for dates before 4713 BC

to implement it in the near future? https://www.postgresql.org/message-id/flat/ca438ff8331c4e109aa1b75a130948ac%40oeaw.ac.at <https://www.postgresql.org/message-id/flat/ca438ff8331c4e109aa1b75a130948ac%40oeaw.ac.at> -- Andreas Joseph Krogh CTO / Partner - Visena AS Mobile: +

Re: PostgreSQL Read-only mode usage

de. Right, we have PowerBI connected to a standby-DB, streaming-replication. -- 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>

Sv: PostgreSQL Read-only mode usage

eports. -- 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>

Re: Improving pg_dump performance when handling large numbers of LOBs

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>

Re: Improving pg_dump performance when handling large numbers of LOBs

em and 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

Re: Daterange question

ve 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 Mobile: +47 909 56 96

Re: Daterange question

Execution Time: 0.015 ms │ └─────────┘ -- Andreas Joseph Krogh CTO / Partner - Visena AS Mobile: +47 909 56 963 andr...@visena.com <mailto:andr...@visena.com> www.visena.com &l

Daterange question

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. -- Andreas Joseph Krogh CTO / P

Re: How to eliminate extra "NOT EXISTS"-query here?

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']::varchar[] <@ (select array_agg(s.v) f

How to eliminate extra "NOT EXISTS"-query here?

he “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>

Sv: Base files compatibility between PG11 and PG15

.postgresql.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

Re: PostgreSQL and local HDD

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. -- Andreas Jos

Re: PostgreSQL and GUI management

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 963 andr..

Re: PostgreSQL and GUI management

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..

Re: Delete values from JSON

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

Re: Delete values from JSON

ment 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't, AFAIU, show how to conditionally delete a key based on its value, and leave other key

Delete values from JSON

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>

Sv: PostgreSQL configuration in a VM

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>

Re: How to store "blobs" efficiently for small and large sizes, with random access

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

Re: How to store "blobs" efficiently for small and large sizes, with random access

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

Re: How to store "blobs" efficiently for small and large sizes, with random access

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

Sv: How to store "blobs" efficiently for small and large sizes, with random access

0GB 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>

Sv: How can I set up Postgres to use given amount of RAM?

ocs/current/runtime-config-query.html#GUC-EFFECTIVE-CACHE-SIZE> -- Andreas Joseph Krogh

Re: Logical replication of large objects

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

Logical replication of large objects

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.visen

Max sane value for join_collapse_limit?

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 / Partner

Will Barman support restore of single database?

b-include> for additional information and caveats. Are there any plans to add support for this to Barman? -- 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>

Re: Getting json-value as varchar

På torsdag 06. januar 2022 kl. 14:42:21, skrev Pavel Stehule < pavel.steh...@gmail.com <mailto:pavel.steh...@gmail.com>>: Hi čt 6. 1. 2022 v 14:33 odesílatel Andreas Joseph Krogh mailto:andr...@visena.com>> napsal: På torsdag 06. januar 2022 kl. 14:29:12, skrev

Re: Getting json-value as varchar

-- 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>

Re: Getting json-value as varchar

På torsdag 06. januar 2022 kl. 14:13:40, skrev David G. Johnston < david.g.johns...@gmail.com <mailto:david.g.johns...@gmail.com>>: On Thursday, January 6, 2022, Andreas Joseph Krogh mailto:andr...@visena.com>> wrote: I think you misread my message. What I want is for the

Sv: Recommended storage hardware

ith software RAID10 on Linux and XFS. Works very well! -- 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>

Re: Getting json-value as varchar

På torsdag 06. januar 2022 kl. 13:31:19, skrev Thomas Markus < t.mar...@proventis.net <mailto:t.mar...@proventis.net>>: Hi, Am 06.01.22 um 13:28 schrieb Andreas Joseph Krogh: Hi, in PG-14 this query returns "value" (with double-quotes): SELECT ('{"

Getting json-value as varchar

ot;value"}'::jsonb)->> 'key'; ┌──┐ │ ?column? │ ├──┤ │ value │ └──┘ (1 row) How to I use the subscript syntax and get the result as varchar instead of JSONB, assuming Iknow the JSON-field is a String? -- Andreas Joseph Krogh CTO / Partner -

Re: Best Strategy for Large Number of Images

folder, size, filenames etc.) in DB. It has excellent HA and backup mechanisms. -- 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>

Re: Detecting repeated phrase in a string

but just one word. Do you want repeated phrase (list of words) ore repeated words? For repeated words (including unicode-chars) you can do: (\b\p{L}+\b)(?:\s+\1)+ I'm not quite sure how to translate this to PG, but in JAVA it works. -- Andreas Joseph Krogh CTO / Partner - Visena AS Mob

Re: Regex for Word space Word space Word ....

cters, which [A-Z] approach doesn't handle well. How about: select regexp_matches('Åge is a Man', E'[[:upper:]]\\w+', 'g'); -- Andreas Joseph Krogh CTO / Partner - Visena AS Mobile: +47 909 56 963 andr...@visena.com <mailto:andr...@visena.com> www.visena.com <https://ww

Re: Incremental backup

"other databases have it" doesn't change that. -- Andreas Joseph Krogh

Re: PostgreSQL - Ordering Table based of Foreign Key

*all* DELETEs will be cascaded. Unfortunately, there is no DELETE FROM ... CASCADE option (similar to DROP) There is TRUNCATE ... CASCADE https://www.postgresql.org/docs/14/sql-truncate.html -- Andreas Joseph Krogh

Re: array_cat in PG-14 changed signature breaks my custom aggregate

7add66 Ok, thanks. -- Andreas Joseph Krogh

array_cat in PG-14 changed signature breaks my custom aggregate

to anycompatiblearray, but that doesn't really tell me anything. Do I have to change the signature of my aggregate to take anycompatiblearray as argument? -- Andreas Joseph Krogh

RE: How to keep format of views source code as entered?

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

Re: How to specify that a trigger should fire when column is NOT in SET-clause?

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'

How to specify that a trigger should fire when column is NOT in SET-clause?

OCEDURE 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:andr..

Re: Hot backup in PostgreSQL

741s 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>

RUM and WAL-generation

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

Sv: PostgreSQL transaction aborted on SQL error

nnection is "invalid" after an SQLException and should be rolled back. -- Andreas Joseph Krogh

Re: Postgresql HA Cluster

hat, 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

Sv: autovacuum failing on pg_largeobject and disk usage of the pg_largeobject growing unchecked

undred 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. -- An

Re: Oracle vs. PostgreSQL - a comment

her 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

Re: Oracle vs. PostgreSQL - a comment

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

Re: Order by lower(column-alias) doesn't work...

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

Re: Order by lower(column-alias) doesn't work...

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

Order by lower(column-alias) doesn't work...

oes 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

Sv: Practical usage of large objects.

l.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

Sv: Triggers and Full Text Search *

/ fail like 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

Sv: Replacing Apache Solr with Postgre Full Text Search?

r 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 experience with it. -- An

Re: How to transfer databases form one server to other

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>

Sv: Why are clobs always "0"

sibl/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 / Partner - Visena AS

Sv: DELETE Query Hang

ount; raise notice 'deleted % rows', num_rows; exit when num_rows = 0; end loop; end;$_$; -- Andreas Joseph Krogh

Re: Create a logical and physical replication

sl32%40alap3.anarazel.de <https://www.postgresql.org/message-id/flat/20181212204154.nsxf3gzqv3gesl32%40alap3.anarazel.de> -- Andreas Joseph Krogh

Re: Having more than one constraint trigger on a table

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.

Re: Having more than one constraint trigger on a table

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

Having more than one constraint trigger on a table

ger 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

Sv: Postgres Point in time Recovery (PITR),

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! =======

Sv: drop database

-- 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>

Sv: drop database

: 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>

Sv: Conflict between autovacuum and backup restoration

setting this in postgresql.conf: autovacuum = off and reload the config (SIGHUP) -- Andreas Joseph Krogh

Re: Segmentation fault with PG-12

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

Re: Segmentation fault with PG-12

om 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

Re: Segmentation fault with PG-12

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

Re: Segmentation fault with PG-12

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? >

Re: Segmentation fault with PG-12

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 WHEN cla

Re: Segmentation fault with PG-12

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

Re: Segmentation fault with PG-12

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

Segmentation fault with PG-12

-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

Logical replicatino from standby

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 Jose

Re: lc_numeric and negative-prefix

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' negative-pref

lc_numeric and negative-prefix

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:andr...@visena.com> www.visena.com <https:/

Re: Installed PostgreSQL-11 in Ubuntu 18.04.02 Server Edition: No existing local cluster is suitable as a default target

" 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>

Re: Installed PostgreSQL-11 in Ubuntu 18.04.02 Server Edition: No existing local cluster is suitable as a default target

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

Re: PostgreSQL License

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 long as you preserve th

Re: pg full text search very slow for Chinese characters

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

RE: Primary Key Update issue ?

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

Sv: Primary Key Update issue ?

@[local]: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

Re: Uninstall postgres

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. sep

Sv: Uninstall postgres

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>

Sv: Two Postgres master process are showing - one is on and off

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

Sv: RE: Transactions

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 909 56 963 andr...@vi

Sv: Transactions

ou 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>

Sv: SQL queries not matching on certain fields

y 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 data and reloading it into another similar (but smaller)

Sv: Re: Geographical multi-master replication

r 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?   -- Andreas Joseph K

Sv: lost "left join"

_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

Sv: Using psql variables in DO-blocks

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_group 'Res

  1   2   >