Re: [GENERAL] Er Data Modeller for PostgreSQL

//www.jetbrains.com/datagrip/   -- 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>  

[GENERAL] join_collapse_limit = 14

s and performance was acceptable again.   I wonder; In general, is there any downside of having join_collapse_limit = 14 on modern hardware (32 cores, 64GB RAM), and geqo_threshold=16 ? I'm aware of it increasing planning-time, but is this really an issue in practice?   Thanks.   -- Andreas Joseph

Re: [GENERAL] join_collapse_limit = 14

På lørdag 07. januar 2017 kl. 17:48:49, skrev Tom Lane mailto:t...@sss.pgh.pa.us>>: Andreas Joseph Krogh writes: > I wonder; In general, is there any downside of having join_collapse_limit = 14 > on modern hardware (32 cores, 64GB RAM), and geqo_threshold=16 ? > I'm aw

Re: [GENERAL] join_collapse_limit = 14

På lørdag 07. januar 2017 kl. 18:25:42, skrev Tom Lane mailto:t...@sss.pgh.pa.us>>: Andreas Joseph Krogh writes: > På lørdag 07. januar 2017 kl. 17:48:49, skrev Tom Lane <mailto:t...@sss.pgh.pa.us>>: >  If you've got just one problem query, it might be worth your ti

Re: [GENERAL] Question slow query

ified);   Am I missing something?    Yes, you've not shown us: 1. The query 2. The schema 3. Complete EXPLAIN-output   -- 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>  

[GENERAL] RUM-index and support for storing BIGINT as part of a tsvector+timestamp

p often is't enough because often there is some other dimention which is *very* relevant to limit the results (like what folder, or account, to search for email-messages in, instead of searching for all in the system).   Thanks.   -- Andreas Joseph Krogh CTO / Partner - Visena AS Mobile: +

Re: [GENERAL] Searching array for multiple items

ou give an example with definition of index and explain-plan?   It would be interesting to see how this performs vs. contrib/intarray.   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>  

Re: [GENERAL] RUM-index and support for storing BIGINT as part of a tsvector+timestamp

Ping...   Any feedback is welcome, thanks.   På torsdag 12. januar 2017 kl. 13:13:34, skrev Andreas Joseph Krogh < andr...@visena.com <mailto:andr...@visena.com>>: Hi PostgresPro-guys.   I've asked this before but didn't get any response, so I'll try again. I know

[GENERAL] Execute commands in single-user mode

space some_tablespace;   Is it possible to issue the above ALTER-statement from the command-line so I can start PG in single-user mode AND execute the ALTER-statement from the command-line i a bash-loop?   Thanks.   -- Andreas Joseph Krogh CTO / Partner - Visena AS Mobile: +47 909 56 963

Re: [GENERAL] Execute commands in single-user mode

no way to issue another command. Even if it was, PG is not accepting connections, so using psql won't work, unless I'm misstaken...   BTW, it's always good form to state the exact O/S and version of PostgreSQL, regardless of whether you think it may apply.   Yea, sorry, it&

Re: [GENERAL] Execute commands in single-user mode

På søndag 10. januar 2016 kl. 16:40:23, skrev Tom Lane mailto:t...@sss.pgh.pa.us>>: Andreas Joseph Krogh writes: > I'm planning to move all my pg_largeobject tables to separate tablespaces and > to be able to do that I need to shuddown PG and start in single-user mo

Re: [GENERAL] Execute commands in single-user mode

På søndag 10. januar 2016 kl. 16:53:54, skrev Tom Lane mailto:t...@sss.pgh.pa.us>>: Andreas Joseph Krogh writes: > P�� s��ndag 10. januar 2016 kl. 16:40:23, skrev Tom Lane <mailto:t...@sss.pgh.pa.us>>: > Andreas Joseph Krogh writes: >>> Then I have to execute

Re: [GENERAL] Execute commands in single-user mode

På søndag 10. januar 2016 kl. 22:38:05, skrev Jim Nasby < jim.na...@bluetreble.com <mailto:jim.na...@bluetreble.com>>: On 1/10/16 10:01 AM, Andreas Joseph Krogh wrote: > pg_largeobject being a system-relation does quite make sense to me, but > that's another discussion

[GENERAL] Moving a large DB (> 500GB) to another DB with different locale

Hi all.   I'm moving a > 500GB DB to another server which is initdb'ed with a different locale (nb_NO.UTF-8 to get correct collation when ORDER BY). Is there another option than pg_dump/restore for doing this?   Thanks.   -- Andreas Joseph Krogh CTO / Partner - Visena AS Mobile: +

Re: [GENERAL] Moving a large DB (> 500GB) to another DB with different locale

På tirsdag 12. januar 2016 kl. 22:56:56, skrev John R Pierce < pie...@hogranch.com <mailto:pie...@hogranch.com>>: On 1/12/2016 1:20 PM, Andreas Joseph Krogh wrote: > I'm moving a > 500GB DB to another server which is initdb'ed with a > different locale (nb_NO.UTF-

Re: [GENERAL] Moving a large DB (> 500GB) to another DB with different locale

På tirsdag 12. januar 2016 kl. 23:28:55, skrev Tom Lane mailto:t...@sss.pgh.pa.us>>: Andreas Joseph Krogh writes: > P�� tirsdag 12. januar 2016 kl. 22:56:56, skrev John R Pierce < > pie...@hogranch.com <mailto:pie...@hogranch.com>>: >> On 1/12/2016 1:20 PM, Andrea

Re: [GENERAL] Moving a large DB (> 500GB) to another DB with different locale

På tirsdag 12. januar 2016 kl. 23:49:24, skrev Tom Lane mailto:t...@sss.pgh.pa.us>>: Andreas Joseph Krogh writes: > Are you saying that I don't have to re-initdb and can just change collation > somehow? If so, how? Collation is really pretty much a per-index property these da

Re: [GENERAL] Moving a large DB (> 500GB) to another DB with different locale

På onsdag 13. januar 2016 kl. 00:03:18, skrev Tom Lane mailto:t...@sss.pgh.pa.us>>: Andreas Joseph Krogh writes: > What about ORDER BY on columns without an index, would they sort correctly? Sorting is sorting, it'll just use whatever collation is specified or implied. reg

Re: [GENERAL] Moving a large DB (> 500GB) to another DB with different locale

På onsdag 13. januar 2016 kl. 03:58:27, skrev John McKown < john.archie.mck...@gmail.com <mailto:john.archie.mck...@gmail.com>>: On Tue, Jan 12, 2016 at 4:09 PM, Andreas Joseph Krogh mailto:andr...@visena.com>> wrote: På tirsdag 12. januar 2016 kl. 22:56:56, skrev J

Re: [GENERAL] Moving a large DB (> 500GB) to another DB with different locale

På onsdag 13. januar 2016 kl. 04:17:03, skrev Vick Khera mailto:vi...@khera.org>>:   On Tue, Jan 12, 2016 at 4:20 PM, Andreas Joseph Krogh mailto:andr...@visena.com>> wrote: I'm moving a > 500GB DB to another server which is initdb'ed with a different locale (nb_NO.UTF-8

Re: [GENERAL] Moving a large DB (> 500GB) to another DB with different locale

På onsdag 13. januar 2016 kl. 19:18:20, skrev Jim Nasby < jim.na...@bluetreble.com <mailto:jim.na...@bluetreble.com>>: On 1/13/16 2:03 AM, Andreas Joseph Krogh wrote: > Seems like pglogical migth be better? > http://2ndquadrant.com/en/resources/pglogical/ > It's av

Re: [GENERAL] Moving a large DB (> 500GB) to another DB with different locale

På torsdag 14. januar 2016 kl. 00:34:51, skrev Jim Nasby < jim.na...@bluetreble.com <mailto:jim.na...@bluetreble.com>>: On 1/13/16 2:39 PM, Andreas Joseph Krogh wrote: > Where can I find more info about how to use and configure pg_logical to > replicate a 9.4 DB to 9.5? http

Re: [GENERAL] Moving a large DB (> 500GB) to another DB with different locale

På fredag 15. januar 2016 kl. 14:33:24, skrev Shulgin, Oleksandr < oleksandr.shul...@zalando.de <mailto:oleksandr.shul...@zalando.de>>: On Fri, Jan 15, 2016 at 1:02 PM, Andreas Joseph Krogh mailto:andr...@visena.com>> wrote: På torsdag 14. januar 2016 kl. 00:34:51, skrev Jim N

Re: [GENERAL] Moving a large DB (> 500GB) to another DB with different locale

På fredag 15. januar 2016 kl. 16:04:00, skrev Shulgin, Oleksandr < oleksandr.shul...@zalando.de <mailto:oleksandr.shul...@zalando.de>>: On Fri, Jan 15, 2016 at 3:41 PM, Andreas Joseph Krogh mailto:andr...@visena.com>> wrote: På fredag 15. januar 2016 kl. 14:33:24, skrev

Re: [GENERAL] Fatal error when not numeric value - PostgreSQL 9.2

A', E'\x1A', 'fe88ff8f-6b4d-4e3d-8020-3475a101d25e') andreak(> ) AS id(customer_id, csv_data, freshbooks_id, myob_id, ppy_id, qb_id, xero_id, _iid);  customer_id │ csv_data │ freshbooks_id │   myob_id    │ ppy_id │ qb_id │ xero_id │ _iid      ─┼──┼───┼──┼┼───┼─┼── 3915105 │ \x1A │ \x1A  │ c59894cb-0ffe-4ad6-823d-73c1392142b6 │ \x1A   │ \x1A  │ \x1A    │ 44 3915135 │ \x1A │ \x1A  │ fe88ff8f-6b4d-4e3d-8020-3475a101d25e │ \x1A   │ \x1A  │ \x1A    │ fe88ff8f-6b4d-4e3d-8020-3475a101d25e (2 rows)       Note that you have a comma after the last paren:   'fe88ff8f-6b4d-4e3d-8020-3475a101d25e'),   I had to remove that to not get this error-message:   [42601] ERROR: syntax error at or near ")"   Position: 428   -- 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: [GENERAL] Replacement for Oracle Text

his. Can this be used to index and search binary documents, e.g. pdf ?   What we do is extract plain-text from PFD/Word etc. clientside in the application, and then index that in the database. Works very well.   -- Andreas Joseph Krogh CTO / Partner - Visena AS Mobile: +47 909 56 963 andr...@vi

[GENERAL] Exclude pg_largeobject form pg_dump

Hi all.   Is there a way to exclude pg_largeobject from pg_dump? -T pg_largeobject doesn't work. I've tried to exclude tables using OID-datatype also but that didn't work either.   Thanks.   -- Andreas Joseph Krogh CTO / Partner - Visena AS Mobile: +47 909 56 963 andr...@visena.c

Re: [GENERAL] Exclude pg_largeobject form pg_dump

På tirsdag 08. mars 2016 kl. 15:43:37, skrev Adrian Klaver < adrian.kla...@aklaver.com <mailto:adrian.kla...@aklaver.com>>: On 03/08/2016 01:53 AM, Andreas Joseph Krogh wrote: > Hi all. > Is there a way to exclude pg_largeobject from pg_dump? -T pg_largeobject > doesn&

Re: [GENERAL] Exclude pg_largeobject form pg_dump

På tirsdag 08. mars 2016 kl. 16:30:36, skrev Tom Lane mailto:t...@sss.pgh.pa.us>>: Andreas Joseph Krogh writes: > P�� tirsdag 08. mars 2016 kl. 15:43:37, skrev Adrian Klaver < > adrian.kla...@aklaver.com <mailto:adrian.kla...@aklaver.com>>: >  Do you care about not

Re: [GENERAL] Exclude pg_largeobject form pg_dump

På tirsdag 08. mars 2016 kl. 16:54:19, skrev Adrian Klaver < adrian.kla...@aklaver.com <mailto:adrian.kla...@aklaver.com>>: On 03/08/2016 07:46 AM, Andreas Joseph Krogh wrote: > På tirsdag 08. mars 2016 kl. 16:30:36, skrev Tom Lane <mailto:t...@sss.pgh.pa.us>>: >

Re: [GENERAL] Exclude pg_largeobject form pg_dump

På tirsdag 08. mars 2016 kl. 16:57:01, skrev Tom Lane mailto:t...@sss.pgh.pa.us>>: Andreas Joseph Krogh writes: > What I'm looking for is "inverse -b" in an otherwise complete dump. Any plans > to add that? [ shrug... ]  Nobody ever asked for it before. regards,

Re: [GENERAL] Exclude pg_largeobject form pg_dump

På tirsdag 08. mars 2016 kl. 17:10:43, skrev Tom Lane mailto:t...@sss.pgh.pa.us>>: Andreas Joseph Krogh writes: > P�� tirsdag 08. mars 2016 kl. 16:54:19, skrev Adrian Klaver < > adrian.kla...@aklaver.com <mailto:adrian.kla...@aklaver.com>>: >  Off hand I would say y

Re: [GENERAL] Exclude pg_largeobject form pg_dump

På tirsdag 08. mars 2016 kl. 17:38:04, skrev Joshua D. Drake < j...@commandprompt.com <mailto:j...@commandprompt.com>>: On 03/08/2016 08:02 AM, Andreas Joseph Krogh wrote: > På tirsdag 08. mars 2016 kl. 16:57:01, skrev Tom Lane <mailto:t...@sss.pgh.pa.us>>: > >   

Re: [GENERAL] Exclude pg_largeobject form pg_dump

På tirsdag 08. mars 2016 kl. 21:03:01, skrev David G. Johnston < david.g.johns...@gmail.com <mailto:david.g.johns...@gmail.com>>: On Tue, Mar 8, 2016 at 9:45 AM, Andreas Joseph Krogh mailto:andr...@visena.com>> wrote: På tirsdag 08. mars 2016 kl. 17:38:04, skrev J

Re: [GENERAL] Multi-row constraints, how to avoid unnecessary trigger execution?

HEN (NEW.t_updated)EXECUTE PROCEDURE index_email_3_tf();   Hope this helps   -- 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: [GENERAL] Multi-row constraints, how to avoid unnecessary trigger execution?

, at transaction commit time. Andreas, thanks, but I need to avoid duplicate executions on different rows too. I just came up with this "hack" which seems to be working: create or replace function my_trigger() returns trigger as $$ begin create temporary table my_trigger() on commit d

[GENERAL] How to build docs from master?

*** [all] Error 2 make[1]: Leaving directory '/home/andreak/dev/postgresql/doc' GNUmakefile:17: recipe for target 'docs' failed make: *** [docs] Error 2     Any hints?   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>

Re: [GENERAL] How to build docs from master?

På mandag 11. april 2016 kl. 15:05:06, skrev Artur Zakirov < a.zaki...@postgrespro.ru <mailto:a.zaki...@postgrespro.ru>>: On 11.04.2016 15:27, Andreas Joseph Krogh wrote: > Hi all. > I have installed PG (master) from git, but it seems the docs are not > built issuing "

Re: [GENERAL] Initdb --data-checksums by default

'll write to hackers.   -1 on changing the default.   10^15 ~= 1000 TB, which isn't very common yet. Those having it probably are aware of the risk and have enabled checksums already.   -- 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: [GENERAL] Initdb --data-checksums by default

På onsdag 20. april 2016 kl. 11:02:31, skrev Alex Ignatov < a.igna...@postgrespro.ru <mailto:a.igna...@postgrespro.ru>>:   On 20.04.2016 11:40, Andreas Joseph Krogh wrote: På onsdag 20. april 2016 kl. 10:33:14, skrev Alex Ignatov < a.igna...@postgrespro.ru <mailto:a.igna...@postg

Re: [GENERAL] Initdb --data-checksums by default

  To make certain garantees that data is by default durable.   What I'm saying is that everything is a compromise, cost/benefit. The universe might explode tomorrow but the chances are slim, so no use preparing for it. Those caring enough probably use checksums, battery-packed RAID etc.   -

Re: [GENERAL] "Keyed" sequence?

tp://instagram-engineering.tumblr.com/post/10853187575/sharding-ids-at-instagram   Then you can do: "id" bigint NOT NULL DEFAULT insta5.next_id(),   -- 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: [GENERAL] index on ILIKE/LIKE - PostgreSQL 9.2

gint you have to cast the value to bigint for btree_gin to use it (note that this isn't necessary if you use a prepared statement):   SELECT DISTINCT title           FROM ja_jobs WHERE title ILIKE '%RYAN WER%'         and clientid = 31239::bigint  AND time_job > 1457826264   

Re: [GENERAL] index on ILIKE/LIKE - PostgreSQL 9.2

På torsdag 12. mai 2016 kl. 09:57:58, skrev Andreas Joseph Krogh < andr...@visena.com <mailto:andr...@visena.com>>: På torsdag 12. mai 2016 kl. 02:30:33, skrev Lucas Possamai < drum.lu...@gmail.com <mailto:drum.lu...@gmail.com>>: Hi there!   I've got a simple but s

Re: [GENERAL] index on ILIKE/LIKE - PostgreSQL 9.2

På torsdag 12. mai 2016 kl. 10:05:01, skrev Andreas Joseph Krogh < andr...@visena.com <mailto:andr...@visena.com>>: [snp] I created this test:   create table ja_jobs(id bigserial primary key, title varchar not null, clientid bigint not null, time_job bigint not null);

[GENERAL] Slides for PGCon2016; "FTS is dead ? Long live FTS !"

Hi.   Any news about when slides for $subject will be available?   -- 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: [GENERAL] Slides for PGCon2016; "FTS is dead ? Long live FTS !"

På lørdag 28. mai 2016 kl. 23:59:55, skrev Oleg Bartunov mailto:obartu...@gmail.com>>:     On Thu, May 26, 2016 at 11:26 PM, Andreas Joseph Krogh mailto:andr...@visena.com>> wrote: Hi.   Any news about when slides for $subject will be available?   I submitted slides to pgcon site, bu

Re: [GENERAL] Slides for PGCon2016; "FTS is dead ? Long live FTS !"

grespro/rum/issues/1   Would be cool to see this fixed so I actually could have a sip of the rum:-)   -- 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: [GENERAL] PG-10 + ICU and abbreviated keys

På mandag 13. november 2017 kl. 19:07:53, skrev Peter Geoghegan mailto:p...@bowt.ie>>: On Mon, Nov 13, 2017 at 12:27 AM, Andreas Joseph Krogh wrote: > In PG-10, with ICU enabled, is abbreviated keys now enabled? Yes. ICU will use abbreviated keys on every platform, including Window

Re: [GENERAL] PG-10 + ICU and abbreviated keys

På mandag 13. november 2017 kl. 21:40:47, skrev Peter Geoghegan mailto:p...@bowt.ie>>: On Mon, Nov 13, 2017 at 11:48 AM, Andreas Joseph Krogh wrote: > Ok, so I have to explicitly specify like this: > > create table test(id serial primary key, name varchar collate "nb_NO

Re: [GENERAL] PG-10 + ICU and abbreviated keys

should be quite a bit of debug output from that that specifically mentions abbreviated keys.   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>  

Re: [GENERAL] PG-10 + ICU and abbreviated keys

På mandag 13. november 2017 kl. 22:28:40, skrev Peter Geoghegan mailto:p...@bowt.ie>>: On Mon, Nov 13, 2017 at 12:48 PM, Andreas Joseph Krogh wrote: > Thanks. As the person that worked on abbreviated keys, I'd like to hear about how you get with this. How much faster is it for

Re: [GENERAL] PG-10 + ICU and abbreviated keys

På tirsdag 14. november 2017 kl. 00:44:11, skrev Peter Geoghegan mailto:p...@bowt.ie>>: On Mon, Nov 13, 2017 at 2:05 PM, Andreas Joseph Krogh wrote: > When sorting on text, we're usually doing so using an multi-column index, like for instance "CREATE INDEX xxx ON my_tab

Re: [GENERAL] Build in function to verify email addresses

e convenient to have datatypes for. Being an open-source project I guess one must show initiative and start a discussion on -hackers to see what interesst there's in having one in core. I for one hope there will be.   -- Andreas Joseph Krogh CTO / Partner - Visena AS Mobile: +47 90

[GENERAL] Problem with autovacuum and pg_autovacuum

4 on x86_64-pc-linux-gnu, compiled by GCC cc (GCC) 4.1.2 20061115 (prerelease) (Debian 4.1.1-21) (1 row) Any idea, what's wrong here? Kind regards -- Andreas 'ads' Scherbaum Failure is not an option. It comes bundled with your Microsoft product. (Ferenc Mantfeld) ---(end of broadcast)--- TIP 2: Don't 'kill -9' the postmaster

Re: [GENERAL] Problem with autovacuum and pg_autovacuum

window. Kind regards -- Andreas 'ads' Scherbaum Failure is not an option. It comes bundled with your Microsoft product. (Ferenc Mantfeld) ---(end of broadcast)--- TIP 2: Don't 'kill -9' the postmaster

Re: [GENERAL] Problem with autovacuum and pg_autovacuum

Hello, On Wed, 4 Jul 2007 18:40:15 -0400 Alvaro Herrera wrote: > Andreas 'ads' Scherbaum wrote: > > > > On Wed, 4 Jul 2007 18:04:35 -0400 Alvaro Herrera wrote: > > > > > Most likely it is worried about XID wraparound, and those are precisely > >

Re: [GENERAL] Problem with autovacuum and pg_autovacuum

On Wed, 4 Jul 2007 19:47:12 -0400 Alvaro Herrera wrote: > Andreas 'ads' Scherbaum wrote: > > Oh. It's not the age. Please let us look at the pg_stat_user_tables > entries for the involved tables? If it's picking the same tables maybe > pgstats has stale

Re: [GENERAL] Problem with autovacuum and pg_autovacuum

On Fri, 6 Jul 2007 11:30:19 +0530 Pavan Deolasee wrote: Hello, > On 7/5/07, Andreas 'ads' Scherbaum <[EMAIL PROTECTED]> wrote: > > > > On Wed, 4 Jul 2007 18:04:35 -0400 Alvaro Herrera wrote: > > > > > Most likely it is worried about XID wraparound,

Re: [GENERAL] Problem with autovacuum and pg_autovacuum

On Fri, 6 Jul 2007 12:06:41 -0400 Alvaro Herrera wrote: > Andreas 'ads' Scherbaum wrote: > > On Fri, 6 Jul 2007 11:30:19 +0530 Pavan Deolasee wrote: > > > > > On 7/5/07, Andreas 'ads' Scherbaum <[EMAIL PROTECTED]> wrote: > > > >

Re: [GENERAL] Problem with autovacuum and pg_autovacuum

On Sat, 7 Jul 2007 00:12:32 +0200 Andreas 'ads' Scherbaum wrote: > On Fri, 6 Jul 2007 12:06:41 -0400 Alvaro Herrera wrote: > > > Andreas 'ads' Scherbaum wrote: > > > The value is '0' for all columns in all entries, except 'vacrelid'

Re: [GENERAL] Problem with autovacuum and pg_autovacuum

utovacuum give some hints about values which seem to create problems. Kind regards -- Andreas 'ads' Scherbaum Failure is not an option. It comes bundled with your Microsoft product. (Ferenc Mantfeld) ---(end of broadcast)

[GENERAL] Hotel for FOSDEM 2008

& kind regards -- Andreas 'ads' Scherbaum German PostgreSQL User Group ---(end of broadcast)--- TIP 1: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [E

Re: [GENERAL] Feature request: NOTIFY enhancement

message to be added to the notify > message, perhaps indicating the row modified or other custom > information. It is possible, that some notifies, if following in a very short time frame, can get lost. In case we want to send extra text messages with NOTIFY, we should make sure

Re: [GENERAL] Replication Using Triggers

-master or even multi-master is a very complicated topic. So let's start with something more easy, like master-slave. This works, you don't have race conditions and that's a good starting point for more research. > I presume you mean that you cannot attach triggers to schema change

Re: [GENERAL] Replication Using Triggers

l.org/about/news.752 > > http://www.postgresql.org/about/news.752 > > The design of that seems suspiciously similar to pgcluster with separate > load balancer and replicator servers. It does not only look like pgcluster. Bye -- Andreas 'ads'

[GENERAL] postgre...@fosdem 2011 - Call for talks

formed by email within one week of the submission deadline. -- Andreas 'ads' Scherbaum German PostgreSQL User Group European PostgreSQL User Group - Board of Directors Volunteer Regional Contact, Germany - PostgreSQL Project -- Sent via pgsql-general

[GENERAL] Hotel room for FOSDEM 2011 in Brussels

2.php -- Andreas 'ads' Scherbaum German PostgreSQL User Group European PostgreSQL User Group - Board of Directors Volunteer Regional Contact, Germany - PostgreSQL Project -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your sub

[GENERAL] postgre...@fosdem 2011 - Reminder: call for papers ending soon!

at FOSDEM. -- Andreas 'ads' Scherbaum German PostgreSQL User Group European PostgreSQL User Group - Board of Directors Volunteer Regional Contact, Germany - PostgreSQL Project -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your

Re: [GENERAL] How to store fixed size images?

gresql How do you usually store images? Thanks!   The images we store might be quite large so we use OID (Large Objects) and use the java.sql.Blob API of the pgjdbc-ng driver to avoid having to deal with large byte-arrays.   -- Andreas Jospeh Krogh CTO / Partner - Visena AS Mobile: +47 909 56 963

[GENERAL] text-prefix search in 9.4's JSONB

": to_tsquery('simple', '(vise:*|office:*)')}';   and have the above query match documents where subject contains the prefixes "vise" and "office", which would match subject="visena" and subject="officenet"   Would be

Re: [GENERAL] text-prefix search in 9.4's JSONB

På mandag 07. juli 2014 kl. 20:15:16, skrev Vik Fearing mailto:vik.fear...@dalibo.com>>: On 07/07/2014 11:28 AM, Andreas Joseph Krogh wrote: > Hi all. >  > I'm excited about 9.4's new JSONB and search-performance. >  > Is it possible to combine tsearch

[GENERAL] Strategy for moving a large DB to another machine with least possible down-time

PITR, rsync + webl-replay magic, what else? Can Barman help with this, maybe?   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>

Re: [GENERAL] Strategy for moving a large DB to another machine with least possible down-time

På søndag 21. september 2014 kl. 13:51:00, skrev Bill Moran < wmo...@potentialtech.com <mailto:wmo...@potentialtech.com>>: On Sun, 21 Sep 2014 13:36:18 +0200 (CEST) Andreas Joseph Krogh wrote: > Hi all.   PG-version: 9.3.5   I have a DB large enough for it to be impractica

Re: [GENERAL] Strategy for moving a large DB to another machine with least possible down-time

På søndag 21. september 2014 kl. 15:48:00, skrev Adrian Klaver < adrian.kla...@aklaver.com <mailto:adrian.kla...@aklaver.com>>: On 09/21/2014 05:44 AM, Andreas Joseph Krogh wrote: > På søndag 21. september 2014 kl. 13:51:00, skrev Bill Moran > mailto:wmo...@potentialtech.com&

Re: [GENERAL] Strategy for moving a large DB to another machine with least possible down-time

På søndag 21. september 2014 kl. 16:10:54, skrev Adrian Klaver < adrian.kla...@aklaver.com <mailto:adrian.kla...@aklaver.com>>: On 09/21/2014 06:50 AM, Andreas Joseph Krogh wrote: > På søndag 21. september 2014 kl. 15:48:00, skrev Adrian Klaver > mailto:adrian.kla...@aklaver.c

[GENERAL] Importing large object (with lo_import) to table in separate tablespaces takes up lots of space in $PGDATA

  Check space-usage: $ du -hs data/ tablespaces/ 164M    data/ 208M    tablespaces/   Now - why is so much extra space used in $PGDATA? Is there a way to reclame it? Was the "apeland"-db moved completely or is there lots dangeling left in PGDATA?   Thanks.   -- Andreas Joseph Krogh CTO

Re: [GENERAL] Importing large object (with lo_import) to table in separate tablespaces takes up lots of space in $PGDATA

På torsdag 09. oktober 2014 kl. 07:29:30, skrev Guillaume Lelarge < guilla...@lelarge.info <mailto:guilla...@lelarge.info>>: Hi, Le 9 oct. 2014 01:31, "Andreas Joseph Krogh" mailto:andr...@visena.com>> a écrit : > > Hi all. >   > I'm having a dat

[GENERAL] Is any information about trigger-name and src-table available at the protocol-level?

me of trigger etc.)?   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>

[GENERAL] DEFERRABLE NOT NULL constraint

  Having deferrable constraints on FKs and UKs is really nice and when working with ORMs it's almost impossible to not use this feature.   Are there any plans to make NOT NULL constraints deferrable so one can avoid the trigger "boilerplate"?   -- Andreas Joseph Krogh       mob: +47 9

Re: [GENERAL] DEFERRABLE NOT NULL constraint

På tirsdag 05. februar 2013 kl. 09:59:54, skrev Albe Laurenz <laurenz.a...@wien.gv.at>: Andreas Joseph Krogh wrote: > It's currently (9.2) not possible to define DEFERRABLE NOT NULL constraints. Meaning the following is > not valid: > > CREATE TABLE my_table( > id varch

Re: [GENERAL] DEFERRABLE NOT NULL constraint

På tirsdag 05. februar 2013 kl. 10:39:43, skrev Darren Duncan <dar...@darrenduncan.net>: Deferrable foreign key and unique key constraints I can understand, but ... On 2013.02.05 1:22 AM, Andreas Joseph Krogh wrote: > +100 for having NOT NULL and CHECK-constraints deferrable:-) >

Re: [GENERAL] DEFERRABLE NOT NULL constraint

På tirsdag 05. februar 2013 kl. 11:04:27, skrev Thomas Kellerer <spam_ea...@gmx.net>: Andreas Joseph Krogh, 05.02.2013 10:57: > The value of having NOT NULL deferrable is, well, to not check for > NULL until the tx commits. When working with ORMs this often is the > case,

Re: [GENERAL] DEFERRABLE NOT NULL constraint

På tirsdag 05. februar 2013 kl. 11:26:20, skrev Alban Hertroys <haram...@gmail.com>: On 5 February 2013 11:15, Andreas Joseph Krogh <andr...@officenet.no> wrote: På tirsdag 05. februar 2013 kl. 11:04:27, skrev Thomas Kellerer <spam_ea...@gmx.net>: Andreas Joseph Krogh

Re: [GENERAL] DEFERRABLE NOT NULL constraint

På tirsdag 05. februar 2013 kl. 13:32:15, skrev Alban Hertroys <haram...@gmail.com>: On 5 February 2013 12:41, Andreas Joseph Krogh <andr...@officenet.no> wrote: There are lots of things you can do, but when it's the ORM which does it you have limited control, and that'

Re: [GENERAL] DEFERRABLE NOT NULL constraint

På tirsdag 05. februar 2013 kl. 14:13:20, skrev Chris Angelico <ros...@gmail.com>: On Tue, Feb 5, 2013 at 11:32 PM, Alban Hertroys wrote: > On 5 February 2013 12:41, Andreas Joseph Krogh wrote: >> >> There are lots of things you can do, but when it's the ORM which d

[GENERAL] Call for Sponsors: German-speaking PostgreSQL Conference 2013

Gold, Silver and Bronze sponsorship are described on the website. Please contact us if you are interested in other forms of sponsorship. -- Andreas 'ads' Scherbaum German PostgreSQL User Group European PostgreSQL User Group - Board of Directors Voluntee

[GENERAL] Announcement: German-speaking PostgreSQL Conference 2013

Sponsors in a separate e-mail. Following this conference, the OpenRheinRuhr will take place at the same venue over the weekend: http://openrheinruhr.de/ -- Andreas 'ads' Scherbaum German PostgreSQL User Group European PostgreSQL User Group - Board of

[GENERAL] Why is NULL = unbounded for rangetypes?

2013-08-11' :: DATE, '[]') && daterange('2013-07-04' :: DATE, '2013-07-30' :: DATE, '[]'); What is the rational behind this behavior of NULL?   -- Andreas Joseph Krogh       mob: +47 909 56 963 Senior Software Developer / CTO - OfficeNet AS - http://www.officenet.no Public key: http://home.officenet.no/~andreak/public_key.asc

Re: [GENERAL] Why is NULL = unbounded for rangetypes?

På mandag 08. juli 2013 kl. 19:16:15, skrev Jeff Davis <pg...@j-davis.com>: On Mon, 2013-07-08 at 10:19 +0200, Andreas Joseph Krogh wrote: > Hi. >  > Both of these queries return TRUE because NULL means "unmounded": > select daterange('2013-07-01' :: DATE

Re: [GENERAL] Why is NULL = unbounded for rangetypes?

På fredag 30. august 2013 kl. 03:23:09, skrev Jeff Davis <pg...@j-davis.com>: On Tue, 2013-07-09 at 10:45 +0200, Andreas Joseph Krogh wrote: > I would expect the queries above to return FALSE and have to use > INFINITY to have them return TRUE. I don't understand what you mea

Re: [GENERAL] Upgrading postgresql minor version

of failure just to replace them back. Is it doable? How?   What about just re-installing the previous version the same way you installed the "patch-release"-version? -- Andreas Joseph Krogh  

Re: [GENERAL] Upgrading postgresql minor version

ge-repo. Maybe you'll have more luck asking that other places than a PG-mailing-list. -- Andreas Joseph Krogh  

[GENERAL] How to include BIGINT-column in RUM-index sorted by timestamp

his indicates that the folder_id column, which is part of the index, isn't actually "part of the index", meaning it's not used in the index for some reason.   Can you tell me how to craft an index so that folder_id = ANY ('{44965,2470520}'::bigint[]) is part of t

[GENERAL] OR-clause support for indexes

e you made any progress making it work for btree?   -- 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>

[GENERAL] pglogical vs. built-in logical replication in pg-10

pglogical replicate large objects? I cannot find any notes about large-objects under "Limitations and Restrictions":  https://www.2ndquadrant.com/en/resources/pglogical/pglogical-docs/   -- Andreas Joseph Krogh CTO / Partner - Visena AS Mobile: +47 909 56 963 andr...@visena.com <ma

Re: [GENERAL] pglogical vs. built-in logical replication in pg-10

På torsdag 22. juni 2017 kl. 11:43:02, skrev Achilleas Mantzios < ach...@matrix.gatewaynet.com <mailto:ach...@matrix.gatewaynet.com>>: On 22/06/2017 11:21, Andreas Joseph Krogh wrote: Hi.   1. Why should one prefer built-in logical replication in pg-10 to pglogical, does it do anythi

Re: [GENERAL] pglogical vs. built-in logical replication in pg-10

På torsdag 22. juni 2017 kl. 15:25:20, skrev Achilleas Mantzios < ach...@matrix.gatewaynet.com <mailto:ach...@matrix.gatewaynet.com>>: On 22/06/2017 13:38, Andreas Joseph Krogh wrote: På torsdag 22. juni 2017 kl. 11:43:02, skrev Achilleas Mantzios < ach...@matrix.gatewaynet.

Re: [GENERAL] pglogical vs. built-in logical replication in pg-10

successfully using logical decoding, correct?     > > I wish PG in some future version will address these quirks so one can operate on LOs more smoothly. You're welcome to help...   Every time issues arise regarding LOs there seems to be little interest to improve matters, and if it do

Re: [GENERAL] pglogical vs. built-in logical replication in pg-10

ing with large objects and streaming to clients (JDBC). The only solution (I've found) which doesn't explode in memory-usage is using LOs (OIDs). Note that we're dealing with multi-gigabytes objects, which need to be "transactional safe" (hence stored in the DB).   --

<    5   6   7   8   9   10   11   >