[HACKERS] Proposal: ALTER EXTENSION SET OPTION

and foo--[version]--unset-parallel-safety.sql -- Best Regards, Chris Travers Database Administrator Tel: +49 162 9037 210 | Skype: einhverfr | www.adjust.com Saarbrücker Straße 37a, 10405 Berlin

Re: [HACKERS] proposal: schema variables

a more clunky syntax as: SET VARIABLE foo='bar'; Perhaps one can have a short form of: SET VAR foo = 'bar'; vs SET foo = 'bar'; -- GUC > > regards, tom lane > > > -- > Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) > To make ch

Re: [HACKERS] Oracle to PostGre

de the query which is actually causing the problem. My guess is that either you didn't declare the type properly or there is some other error in your function, but the information provided is not sufficient to answer it. Best or luck asking on -general. -- Best Regards, Chris Travers Database Administrator Tel: +49 162 9037 210 | Skype: einhverfr | www.adjust.com Saarbrücker Straße 37a, 10405 Berlin

Re: [HACKERS] WIP: Restricting pg_rewind to data/wal dirs

ferent use cases well and then build common infrastructure to support the different cases. I am not against building common infrastructure for pg_rewind and pg_basebackup. I am very much against having the core guarantees being the exact same. Best Wishes, Chris Travers On Sat, Oct 28, 2017 at 1:22

Re: [HACKERS] Patch: restrict pg_rewind to whitelisted directories

On Tue, Oct 31, 2017 at 1:38 PM, Robert Haas <robertmh...@gmail.com> wrote: > On Mon, Oct 30, 2017 at 6:44 PM, Chris Travers <chris.trav...@adjust.com> > wrote: > > The attached patch is cleaned up and filed for the commit fest this next > > month: > > It'

[HACKERS] Anyone have experience benchmarking very high effective_io_concurrency on NVME's?

of PostgreSQL to bump this setting up to ever higher values, I am wondering if anyone has done this yet and if so if you would be willing to share results. -- Best Regards, Chris Travers Database Administrator Tel: +49 162 9037 210 | Skype: einhverfr | www.adjust.com Saarbrücker Straße 37a, 10405

[HACKERS] Patch: restrict pg_rewind to whitelisted directories

: mine/pg_rewind_restrict_dirs parent: 60446:e638ba9c3c11 user:Chris Travers <chris.trav...@gmail.com> date:Mon Oct 30 12:25:18 2017 +0100 files: doc/src/sgml/ref/pg_rewind.sgml src/bin/pg_rewind/copy_fetch.c src/bin/pg_rewind/fetch.c src/bin/pg_rewind/fetch

Re: [HACKERS] WIP: Restricting pg_rewind to data/wal dirs

On Mon, Oct 30, 2017 at 11:36 AM, Michael Paquier <michael.paqu...@gmail.com > wrote: > On Mon, Oct 30, 2017 at 10:15 AM, Chris Travers > <chris.trav...@adjust.com> wrote: > > This also brings up a fairly major concern more generally about control > by > > the way

Re: [HACKERS] WIP: Restricting pg_rewind to data/wal dirs

On Mon, Oct 30, 2017 at 10:57 AM, Michael Paquier <michael.paqu...@gmail.com > wrote: > On Mon, Oct 30, 2017 at 9:43 AM, Chris Travers <chris.trav...@adjust.com> > wrote: > > Are there any cases right now where you have features added by > extensions that write to dir

Re: [HACKERS] WIP: Restricting pg_rewind to data/wal dirs

First, thanks for your thoughts on this, and I am interested in probing them more. On Mon, Oct 30, 2017 at 9:04 AM, Michael Paquier <michael.paqu...@gmail.com> wrote: > On Sat, Oct 28, 2017 at 4:22 AM, Chris Travers <chris.trav...@adjust.com> > wrote: > > The So

Re: [HACKERS] proposal: schema variables

the output. > > Regards > > Pavel > > > > >> >> >>> regards >>> >>> Pavel >>> >>> >>> >> >> >> -- >> Best Regards, >> Chris Travers >> Database Administrator >> >

Re: [HACKERS] proposal: schema variables

pecify allowed types in custom settings. 3. In a subsequent stage you might be able to SELECT INTO setting_name FROM ; allowing access to setting writes based on queries. > regards > > Pavel > > > -- Best Regards, Chris Travers Database Administrator Tel: +49 162 9037 210 | Skype: einhverfr | www.adjust.com Saarbrücker Straße 37a, 10405 Berlin

[HACKERS] WIP: Restricting pg_rewind to data/wal dirs

escriptive name but currently did not remove the old function yet. Feedback is very welcome. pg_rewind is a very nice piece of software. I am hoping that these sorts of changes will help ensure that it is easier to use and provides more predictable results. -- Best Regards, Chris Traver

Re: [HACKERS] Add Roman numeral conversion to to_number

kype: davidfetter XMPP: david(dot)fetter(at)gmail(dot)com > > Remember to vote! > Consider donating to Postgres: http://www.postgresql.org/about/donate > > > -- > Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) > To make changes to your subscription: > http://www.postgresql.org/mailpref/pgsql-hackers > -- Best Regards, Chris Travers Database Administrator Tel: +49 162 9037 210 | Skype: einhverfr | www.adjust.com Saarbrücker Straße 37a, 10405 Berlin

Re: [HACKERS] pg_rewind proposed scope and interface changes

On Wed, Sep 13, 2017 at 6:28 AM, Michael Paquier <michael.paqu...@gmail.com> wrote: > On Tue, Sep 12, 2017 at 11:52 PM, Chris Travers > <chris.trav...@adjust.com> wrote: > > Additionally the wal, xact, timestamp and logical directories must be > > processed in some

[HACKERS] pg_rewind proposed scope and interface changes

. Problems that we will not try to solve: * Rewinding past table creation orphans table file. This is a complex topic on its own and probably needs a separate utility. Thoughts? -- Best Regards, Chris Travers Database Administrator Tel: +49 162 9037 210 | Skype: einhverfr | www.adjust.com

Re: [HACKERS] Proposal: pg_rewind to skip config files

dmap of patches, and then submitting them as they become complete. > -- > Álvaro Herrerahttps://www.2ndQuadrant.com/ > PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services > -- Best Regards, Chris Travers Database Administrator Tel: +49 162 9037 210 | Skype: einhverfr | www.adjust.com Saarbrücker Straße 37a, 10405 Berlin

Re: [HACKERS] Proposal: pg_rewind to skip config files

subsystem would fix this. Is this a reason to rethink the idea that maybe a pg_fsck utility might be useful that could be run immediately after a rewind? -- Best Regards, Chris Travers Database Administrator Tel: +49 162 9037 210 | Skype: einhverfr | www.adjust.com Saarbrücker Straße 37a, 10405 Berlin

Re: [HACKERS] Proposal: pg_rewind to skip config files

d is sometimes slower than new WALs are > written under heavy load. > How would this work when it comes to rewinding against a file directory? > > -- > May the force be with you… > https://simply.name > > -- Best Regards, Chris Travers Database Administrator Tel: +49 162 9037 210 | Skype: einhverfr | www.adjust.com Saarbrücker Straße 37a, 10405 Berlin

Re: [HACKERS] Proposal: pg_rewind to skip config files

On Tue, Sep 5, 2017 at 1:04 PM, Michael Paquier <michael.paqu...@gmail.com> wrote: > On Tue, Sep 5, 2017 at 7:54 PM, Vladimir Borodin <r...@simply.name> wrote: > > 5 сент. 2017 г., в 12:31, Chris Travers <chris.trav...@adjust.com> > > написал(а): > > &g

Re: [HACKERS] Proposal: pg_rewind to skip config files

On Tue, Sep 5, 2017 at 12:54 PM, Vladimir Borodin <r...@simply.name> wrote: > > 5 сент. 2017 г., в 12:31, Chris Travers <chris.trav...@adjust.com> > написал(а): > > I think the simplest solution for now is to skip any files ending in > .conf, .log, and serverlog. >

Re: [HACKERS] Proposal: pg_rewind to skip config files

On Mon, Sep 4, 2017 at 3:38 PM, Alvaro Herrera <alvhe...@alvh.no-ip.org> wrote: > Chris Travers wrote: > > On Mon, Sep 4, 2017 at 12:23 PM, Michael Paquier < > michael.paqu...@gmail.com> > > wrote: > > > > > On Mon, Sep 4, 2017 at 7:21 PM, Michael Pa

Re: [HACKERS] Proposal: pg_rewind to skip config files

p to avoid these problems is not always a sane assumption. So consequently, I think it would be good to fix in the tool. The fundamental question is if there is any reason someone would actually want to copy config files over. -- > Michael > -- Best Regards, Chris Travers D

Re: [HACKERS] Proposal: pg_rewind to skip config files

ot think of any cases where anyone would actually want to do this but that doesn't mean they aren't out there. If people really want to, then they need to copy the configuration files they want separately. Next Steps: If people like this idea I will add test cases and edit documentation as appropriate.

[HACKERS] Proposal: pg_rewind to skip config files

the file tree traversal. Any feedback before I create.a proof of concept? -- Best Regards, Chris Travers Database Administrator Tel: +49 162 9037 210 | Skype: einhverfr | www.adjust.com Saarbrücker Straße 37a, 10405 Berlin

Re: [HACKERS] Proposal: global index

On Fri, Aug 25, 2017 at 12:15 PM, Petr Jelinek <petr.jeli...@2ndquadrant.com > wrote: > On 25/08/17 10:28, Chris Travers wrote: > > > > > > On Thu, Aug 24, 2017 at 9:44 PM, Andres Freund <and...@anarazel.de > > <mailto:and...@anarazel.de>> wrote: >

Re: [HACKERS] Thoughts on unit testing?

ce, and it improves the safety of moving forward. But I still think the question of what to test ought to be geared around "what are we willing to try to guarantee as behaviour for some years, not just to ourselves but to third parties." > > Greetings, > Torsten > > > -- > Se

Re: [HACKERS] Proposal: global index

s mailing list (pgsql-hackers@postgresql.org) > To make changes to your subscription: > http://www.postgresql.org/mailpref/pgsql-hackers > -- Best Regards, Chris Travers Database Administrator Tel: +49 162 9037 210 | Skype: einhverfr | www.adjust.com Saarbrücker Straße 37a, 10405 Berlin

Re: [HACKERS] Proposal: global index

On Aug 21, 2017 07:47, "Simon Riggs" wrote: On 18 August 2017 at 15:40, Alvaro Herrera wrote: > Ildar Musin wrote: > >> While we've been developing pg_pathman extension one of the most frequent >> questions we got from our users was about global

Re: [HACKERS] [RFC] What would be difficult to make data models pluggable for making PostgreSQL a multi-model database?

On Sun, Aug 20, 2017 at 4:10 AM, MauMau <maumau...@gmail.com> wrote: > From: Chris Travers > > Why cannot you do all this in a language handler and treat as a user > defined function? > > ... > > If you have a language handler for cypher, why do you need in_region &

Re: [HACKERS] [RFC] What would be difficult to make data models pluggable for making PostgreSQL a multi-model database?

ture is not enough. Maybe I am missing something? > > Regards > MauMau > > > > -- > Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) > To make changes to your subscription: > http://www.postgresql.org/mailpref/pgsql-hackers > -- Best Regards, Chris Travers Database Administrator Tel: +49 162 9037 210 | Skype: einhverfr | www.adjust.com Saarbrücker Straße 37a, 10405 Berlin

Re: [HACKERS] Proposal: global index

I’ll be glad to hear it. > > [1] https://www.postgresql.org/message-id/c8fe4f6b-ff46-aae0-89e > 3-e936a35f0cfd%40postgrespro.ru > > Thanks! > > -- > Ildar Musin > i.mu...@postgrespro.ru > > > -- > Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) >

Re: [HACKERS] Orphaned files in base/[oid]

ave external programs to do after-the-fact review and cleanup. > > Greetings, > > Andres Freund > -- Best Regards, Chris Travers Database Administrator Tel: +49 162 9037 210 | Skype: einhverfr | www.adjust.com Saarbrücker Straße 37a, 10405 Berlin

Re: [HACKERS] Orphaned files in base/[oid]

to make sure everything is ok? -- Best Regards, Chris Travers Database Administrator Tel: +49 162 9037 210 | Skype: einhverfr | www.adjust.com Saarbrücker Straße 37a, 10405 Berlin

Re: [HACKERS] Orphaned files in base/[oid]

On Tue, Aug 15, 2017 at 3:32 PM, Tom Lane <t...@sss.pgh.pa.us> wrote: > Chris Travers <chris.trav...@adjust.com> writes: > > I wonder about a different solution. Would it be possible to special > case > > vacuum to check for and remove (or just move to where they ca

Re: [HACKERS] Orphaned files in base/[oid]

to be able to know that a relfilenode shouldn't be used anymore, right? -- Best Regards, Chris Travers Database Administrator Tel: +49 162 9037 210 | Skype: einhverfr | www.adjust.com Saarbrücker Straße 37a, 10405 Berlin

Re: [HACKERS] Orphaned files in base/[oid]

more advanced solutions but that I might be able to do. > > regards, tom lane > -- Best Regards, Chris Travers Database Administrator Tel: +49 162 9037 210 | Skype: einhverfr | www.adjust.com Saarbrücker Straße 37a, 10405 Berlin

Re: [HACKERS] Orphaned files in base/[oid]

On Mon, Aug 14, 2017 at 6:33 PM, Andres Freund <and...@anarazel.de> wrote: > Hi, > > On 2017-08-14 14:12:22 +0200, Chris Travers wrote: > > Problem: > > The system this came up on is PostgreSQL 9.6.3 and has had repeated > trouble > > with disk space. Quer

Re: [HACKERS] Orphaned files in base/[oid]

On Aug 14, 2017 14:12, "Chris Travers" <chris.trav...@adjust.com> wrote: Hi all; I am trying to track down a problem we are seeing that looks very similar to bug #12050, and would certainly consider trying to contribute a fix if we agree on one. (I am not sure we can, so absen

[HACKERS] Orphaned files in base/[oid]

in various operations including creating materialised views. So my question is if there is a way we can safely clean these up on server restart? If not does it make sense to try to create a utility that can connect to PostgreSQL, seek out valid files, and delete the rest? -- Best Regards, Chris Travers

Re: [HACKERS] Funny WAL corruption issue

On Fri, Aug 11, 2017 at 1:33 PM, Greg Stark <st...@mit.edu> wrote: > On 10 August 2017 at 15:26, Chris Travers <chris.trav...@gmail.com> wrote: > > > > > > The bitwise comparison is interesting. Remember the error was: > > > > pg_xlogdump:

Re: [HACKERS] Funny WAL corruption issue

On Fri, Aug 11, 2017 at 1:33 PM, Greg Stark <st...@mit.edu> wrote: > On 10 August 2017 at 15:26, Chris Travers <chris.trav...@gmail.com> wrote: > > > > > > The bitwise comparison is interesting. Remember the error was: > > > > pg_xlogdump:

Re: [HACKERS] Funny WAL corruption issue

but wal records ISTR have a separate CRC check), would this perhaps indicate that the checksum operated over incorrect data? > > -- > Vladimir Rusinov > PostgreSQL SRE, Google Ireland > > Google Ireland Ltd.,Gordon House, Barrow Street, Dublin 4, Ireland > Registered in Dublin, I

Re: [HACKERS] Funny WAL corruption issue

pg_xlogdump: FATAL: error in WAL record at 1E39C/E1117FB8: unexpected pageaddr 1E375/61118000 in log segment 0001E39C00E1, offset 1146880 > -- Best Wishes, Chris Travers Efficito: Hosted Accounting and ERP. Robust and Flexible. No vendor lock-in. http://www.efficito.com/learn_more

Re: [HACKERS] Funny WAL corruption issue

Sorry, meant to reply all. On Thu, Aug 10, 2017 at 2:19 PM, Vladimir Borodin <r...@simply.name> wrote: > Hi, Chris. > > 10 авг. 2017 г., в 15:09, Chris Travers <chris.trav...@gmail.com> > написал(а): > > Hi; > > I ran into a funny situation today regard

[HACKERS] Funny WAL corruption issue

hings from happening in the future if, for example, a replica dies in the middle of a wal fsync. -- Best Wishes, Chris Travers Efficito: Hosted Accounting and ERP. Robust and Flexible. No vendor lock-in. http://www.efficito.com/learn_more

Re: [HACKERS] 9.3 Json Array's

@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers Best Wishes, Chris Travers http://www.2ndquadrant.com PostgreSQL Services, Training, and Support

Re: [HACKERS] 9.3 Json Array's

be turned into a patch. See my previous post on this topic. Again collaboration is welcome. Best Wishes, Chris Travers http://www.2ndquadrant.com PostgreSQL Services, Training, and Support

Re: [HACKERS] Minmax indexes

target and over years of billing, the subset would be quite small compared to the full system (imagine, say, 50k rows out of 20M). Best Wises, Chris Travers - Heikki -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http

Re: [HACKERS] Proposal: json_populate_record and nested json objects

, This will be an interesting way to get into PostgreSQL hacking. Best Wishes, Chris Travers merlin -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers Best Wishes, Chris Travers http://www

Re: [HACKERS] Proposal: json_populate_record and nested json objects

On 15 September 2013 at 18:42 Andrew Dunstan and...@dunslane.net wrote: On 09/14/2013 10:27 PM, chris travers wrote: Well, you could fairly easily build it as an extension as a POC. The main point of the API this is built on was to allow for extensions. The logic changes might be a bit

[HACKERS] Proposal: json_populate_record and nested json objects

this first as an extension (perhaps with different function names) or first as a patch? Best Wishes, Chris Travers http://www.2ndquadrant.com PostgreSQL Services, Training, and Support

Re: [HACKERS] Proposal: PL/PgSQL strict_mode

changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers Best Wishes, Chris Travers http://www.2ndquadrant.com PostgreSQL Services, Training, and Support

Re: [HACKERS] [GENERAL] Creating temp tables inside read only transactions

. Right now I am using a double underscore which is error-prone. Best Wishes, Chris Travers -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers

[HACKERS] Question about the TODO, numerics, and division

something? Best Wishes, Chris Travers begin:vcard fn:Chris Travers n:Travers;Chris email;internet:[EMAIL PROTECTED] tel;work:509-888-0220 tel;cell:509-630-7794 x-mozilla-html:FALSE version:2.1 end:vcard ---(end of broadcast)--- TIP 4: Have you searched

Re: [GENERAL] [HACKERS] 'a' == 'a '

that they are the same length before performing the comparison. Understood, but what gain do you have in a case like this that might justify the effort that would go into making it, say, an initdb option? How often does this behavior cause problems? Best Wishes, Chris Travers Metatron Technology

Re: [GENERAL] [HACKERS] 'a' == 'a '

other cases. Best Wishes, Chris Travers Metatron Technology Consulting ---(end of broadcast)--- TIP 5: don't forget to increase your free space map settings

Re: [HACKERS] [pgsql-advocacy] Spikewatch testing

someone to commit to helping me on the contest, so that PostgreSQL can participate. What is involved in this? Maybe if you give specifics one of us can commit to helping :-) Best Wishes, Chris Travers Metatron Technology Consulting ---(end of broadcast

Re: [pgsql-advocacy] [HACKERS] Increased company involvement

sections: Bids and Bounties. Best Wishes, Chris Travers Metatron Technology Consulting ---(end of broadcast)--- TIP 7: don't forget to increase your free space map settings

Re: [HACKERS] [GENERAL] CREATE DATABASE on the heap with PostgreSQL?

which is best left untouched. Best Wishes, Chris Travers Metatron Technology Consulting ---(end of broadcast)--- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faqs/FAQ.html

Re: [HACKERS] [pgsql-advocacy] What can we learn from MySQL?

of the ipc stuff is a reasonable barrier to entry). Best Wishes, Chris Travers Metatron Technology Consulting ---(end of broadcast)--- TIP 4: Don't 'kill -9' the postmaster

Re: [pgsql-advocacy] [HACKERS] What can we learn from MySQL?

due to paid contracts, I don't really see the value of published roadmaps in general. Best Wishes, Chris Travers ---(end of broadcast)--- TIP 3: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL

Re: [pgsql-advocacy] [HACKERS] What can we learn from MySQL?

MS SQL does have a nice installer, however, as do most binary open source products for Windows. I am completely confident that PostgreSQL for Windows, when it arrives, will have a nice GUI-based installer. Best Wishes, Chris Travers Metatron Technology Consulting begin:vcard fn:Chris Travers

Re: [HACKERS] [GENERAL] Should we consider empty fields as NULL values when

'NULL'; } else { return '$db_var'; } } This will enclose your variable with single-quotes unless it is not set in which case it will return a string, NULL which can be used in your database queries. Best Wishes, Chris Travers This problem is solved by adding