Re: [HACKERS] How to determine that a TransactionId is really aborted?

and then regularly poking Postgres to see which ones are > aborted-and-no-longer-considered-visible so I can clean up my external list. > so, what you want is txid_status() [1]... while this is new in v10 you can use the code as guide or just migrate to v10 ;) [1] https://www.postgr

Re: [HACKERS] Columnar storage support

On 9 October 2017 at 15:03, legrand legrand <legrand_legr...@hotmail.com> wrote: > Is there a chance that pluggable storage permits creation of a columnar rdbms > as monetDB in PostgreSQL ? pluggable storage is one of the pieces for it, yes... but is not as simple as that, IIU

Re: [HACKERS] generated columns

On 10 September 2017 at 00:08, Jaime Casanova <jaime.casan...@2ndquadrant.com> wrote: > > During my own tests, though, i found some problems: > a few more tests: create table t1 ( id serial, height_cm int, height_in int generated always as (height_cm * 10) ) ; ""&q

Re: [HACKERS] generated columns

o t1_1 values (11); server closed the connection unexpectedly This probably means the server terminated abnormally before or while processing the request. The connection to the server was lost. Attempting reset: Failed. !> \q -- Jaime Casanova www.2ndQuadrant.com PostgreSQL Dev

Re: [HACKERS] [PATCH] New command to monitor progression of long running queries

nction could be usable by a tool to examine a slow query status -- Jaime Casanova www.2ndQuadrant.com PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers

[HACKERS] SASL minor docs typo

Hi, reading SASL docs found this typo: in protocol.sgml:1356 """ To begin a SASL authentication exchange, the server an AuthenticationSASL message. """ I guess it should say "the server sends an AuthenticationSASL message" -- Jaime Casanova

[HACKERS] minor typo in client-auth.sgml

cram md5 and password. """ -- Jaime Casanova www.2ndQuadrant.com PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers

Re: [HACKERS] Patch: Write Amplification Reduction Method (WARM)

RAP: FailedAssertion("!(((bool) (((const void*)(>t_ctid) != ((void *)0)) && (((>t_ctid)->ip_posid & uint16) 1) << 13) - 1)) != 0", File: "../../../../src/include/access/htup_details.h", Line: 659) """ -- Jaime Casanova

Re: [HACKERS] [PATCH v1] Add and report the new "in_hot_standby" GUC pseudo-variable.

ings, no? Or how are you going to know the current value of the GUC that makes it different to just poll for pg_is_in_recovery()? -- Jaime Casanova www.2ndQuadrant.com PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services -- Sent via pgsql-hackers mailing list (p

Re: [HACKERS] Logical replication launcher's bgworker enabled by default, and max_logical_replication_workers

re that has created more than 13k of code > diffs, it would be disabled by default. > +1, we should that to 0 before release -- Jaime Casanova www.2ndQuadrant.com PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services -- Sent via pgsql-hackers

Re: [HACKERS] Logical Replication WIP

On 20 January 2017 at 11:39, Petr Jelinek <petr.jeli...@2ndquadrant.com> wrote: > On 20/01/17 17:33, Jaime Casanova wrote: >>> >> >> surely wal_level < logical shouldn't start a logical replication >> launcher, and after an initdb wal_level is

Re: [HACKERS] Logical Replication WIP

t up by default? >> > > Because running subscriptions is allowed by default. You'd need to set > max_logical_replication_workers to 0 to disable that. > surely wal_level < logical shouldn't start a logical replication launcher, and after an initdb wal_level is only replica -- Jaime Cas

Re: [HACKERS] Patch: Write Amplification Reduction Method (WARM)

al 6: Aborted LOG: aborting startup due to startup process failure """ still cannot reproduce this one consistently but happens often enough will continue playing with it... -- Jaime Casanova www.2ndQuadrant.com PostgreSQL Development, 24x7 Support, Remote DBA, T

Re: [HACKERS] patch proposal

it's unable to restore that WAL > segment. > Ah! Is this documented somewhere? if we expect people to use correct exit codes we should document them, no? -- Jaime Casanova www.2ndQuadrant.com PostgreSQL Development, 24x7 Support, Remote DBA, Training &

Re: [HACKERS] Declarative partitioning - another take

On 7 November 2016 at 12:15, Jaime Casanova <jaime.casan...@2ndquadrant.com> wrote: > On 28 October 2016 at 02:53, Amit Langote <langote_amit...@lab.ntt.co.jp> > wrote: >> >> Please find attached the latest version of the patches > > Hi, > > I started to

Re: [HACKERS] Declarative partitioning - another take

e START END syntax but i don't have any ideas there... except, there was a reason not to use expressions (like a CHECK constraint?) -- Jaime Casanova www.2ndQuadrant.com PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services failing_test_1.sql Descriptio

Re: [HACKERS] Is the last 9.1 release planned?

it is going to die. What normally happens is that all minor releases are released the same day. Taken your example, that same day were released: 9.0.23, 9.1.19, 9.2.14, 9.3.10 and 9.4.5 -- Jaime Casanova www.2ndQuadrant.com PostgreSQL Development, 24x7 Support, Remote DBA, T

Re: [HACKERS] autonomous transactions

). CONTEXT: PL/pgSQL function foo() line 7 at SQL statement STATEMENT: select foo(); ERROR: null value in column "i" violates not-null constraint DETAIL: Failing row contains (null). CONTEXT: PL/pgSQL function foo() line 7 at SQL statement this happens even everytime i use the PRAGMA

Re: [HACKERS] autonomous transactions

re is not guilty why do you want to put it in jail? -- Jaime Casanova www.2ndQuadrant.com PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscriptio

Re: [HACKERS] to_date_valid()

we fix this instead? Sounds like a bug to me. We don't usually want to be bug compatible so it doesn't matter if we break something. -- Jaime Casanovahttp://www.2ndQuadrant.com/ PostgreSQL Development, 24x7 Support, Training & Services

[HACKERS] Rename synchronous_standby_names?

Hi, Are we going to change synchronous_standby_names? Certainly the GUC is not *only* a list of names anymore. synchronous_standby_config? synchronous_standbys (adjust to correct english if necesary)? -- Jaime Casanova www.2ndQuadrant.com PostgreSQL Development, 24x7

Re: [HACKERS] 10.0

>>> * The year after, 11.0. Etc cetera. >>>> >>>> >>> Yes. Please! >> >> Hear, hear! >> >> Sadly, we're too late for 9.6, but we can start with 10.0 and finish >> this silliness once and for good. > > +1! > +

Re: [HACKERS] Disabling an index temporarily

index list. > > > Wouldn't something like: > > ALTER INDEX foo SET DISABLED; > > See more in line with our grammar? > > I assume the index is only disabled as far as the planner is concerned and > all updates/inserts/deletes will still actually update the index > appr

[HACKERS] REASSIGN OWNED doesn't know how to deal with USER MAPPINGs

Hi, We just notice $SUBJECT. Attached patch fixes it by ignoring USER MAPPINGs in shdepReassignOwned() just like it happens with default ACLs. DROP OWNED manages it well. -- Jaime Casanova www.2ndQuadrant.com Professional PostgreSQL: Soporte 24x7 y capacitación diff --git

Re: [HACKERS] REASSIGN OWNED doesn't know how to deal with USER MAPPINGs

On 10 December 2015 at 13:04, Jaime Casanova <jaime.casan...@2ndquadrant.com> wrote: > Hi, > > We just notice $SUBJECT. Attached patch fixes it by ignoring USER > MAPPINGs in shdepReassignOwned() just like it happens with default > ACLs. > BTW, shouldn't we at least give

Re: [HACKERS] GIN pending list clean up exposure to SQL

On 21 November 2015 at 03:54, Jim Nasby <jim.na...@bluetreble.com> wrote: > On 11/19/15 10:47 AM, Jaime Casanova wrote: >> >> - only superusers? > > > I would think the owner of the table (index?) should also be able to run > this. agreed, tha

Re: [HACKERS] GIN pending list clean up exposure to SQL

On 19 November 2015 at 14:57, Jaime Casanova <jaime.casan...@2ndquadrant.com> wrote: > On 19 November 2015 at 14:47, Jaime Casanova > <jaime.casan...@2ndquadrant.com> wrote: >> On 19 November 2015 at 14:18, Alvaro Herrera <alvhe...@2ndquadrant.com> >> wrote:

Re: [HACKERS] GIN pending list clean up exposure to SQL

rize_new_values() in core -- Jaime Casanova www.2ndQuadrant.com Professional PostgreSQL: Soporte 24x7 y capacitación -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers

Re: [HACKERS] GIN pending list clean up exposure to SQL

thought-out choice? > > After reading gitPendingCleanup it becomes clear that there's no need > for a stronger lock than what you've chosen. Jaime Casanova just > pointed this out to me. > But it should do some checks, no? - only superusers? - what i received as parameter is a GIN inde

Re: [HACKERS] GIN pending list clean up exposure to SQL

On 19 November 2015 at 14:47, Jaime Casanova <jaime.casan...@2ndquadrant.com> wrote: > On 19 November 2015 at 14:18, Alvaro Herrera <alvhe...@2ndquadrant.com> wrote: >> Alvaro Herrera wrote: >>> Jeff Janes wrote: >>> > I've written a function which

Re: [HACKERS] bugs and bug tracking

low you to say which OS was affected that is the one the user was using. still the bug could happen in all OSes (versions?), only some, only a specifi OS in a specific version is affected. so we need, to have an interface to fix metada... and people taking responsability for that -- Jai

Re: [HACKERS] bugs and bug tracking

to register in a ML, they just want a specific question answered so i don't think any change in the form will avoid that. -- Jaime Casanova www.2ndQuadrant.com Professional PostgreSQL: Soporte 24x7 y capacitación -- Sent via pgsql-hackers mailing list (pgsql-hackers@pos

Re: [HACKERS] synchronous_commit = apply

ne Simon suggest is not the first time he submitted that option so it should be other threads too: http://www.postgresql.org/message-id/aanlktinxoymwowbsjxmnpjhjh_yan9vfmnmhnjdme...@mail.gmail.com -- Jaime Casanova www.2ndQuadrant.com Professional PostgreSQL: Soporte 24x7 y cap

Re: [HACKERS] Proposal: Implement failover on libpq connect level.

then this could be a good idea -- Jaime Casanova www.2ndQuadrant.com Professional PostgreSQL: Soporte 24x7 y capacitación -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers

Re: [HACKERS] Improving GEQO

at -- Jaime Casanova www.2ndQuadrant.com Professional PostgreSQL: Soporte 24x7 y capacitación -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers

Re: [HACKERS] Remove fsync ON/OFF as a visible option?

, that why if you want to have it you need to compile and postgres' developers do that routinely anyway just my 2c -- Jaime Casanova www.2ndQuadrant.com Professional PostgreSQL: Soporte 24x7 y capacitación -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make

Re: [HACKERS] Remove fsync ON/OFF as a visible option?

El mar 21, 2015 2:00 AM, Mark Kirkwood mark.kirkw...@catalyst.net.nz escribió: On 21/03/15 19:28, Jaime Casanova wrote: what about not removing it but not showing it in postgresql.conf? as a side note, i wonder why trace_sort is not in postgresql.conf... other option is to make it a compile

Re: [HACKERS] Remove fsync ON/OFF as a visible option?

On Sat, Mar 21, 2015 at 2:33 PM, Joshua D. Drake j...@commandprompt.com wrote: On 03/20/2015 11:28 PM, Jaime Casanova wrote: I fought to remove fsync before so i understand JD concerns. and yes, i have seen fsync=off in the field too... what about not removing it but not showing

Re: [HACKERS] pgaudit - an auditing extension for PostgreSQL

user). what if i want to audit different things for different users? -- Jaime Casanova www.2ndQuadrant.com Professional PostgreSQL: Soporte 24x7 y capacitación Phone: +593 4 5107566 Cell: +593 987171157 -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org

Re: [HACKERS] TABLESAMPLE patch

tablesample system (null); count --- 28 (1 row) regression=# select count(1) from tenk1 tablesample bernoulli (null); count --- 0 (1 row) -- Jaime Casanova www.2ndQuadrant.com Professional PostgreSQL: Soporte 24x7 y capacitación Phone: +593 4 5107566 Cell: +593

Re: [HACKERS] Commitfest problems

not-yet customers ask for certificated engineers, and there isn't any official (as in from community) certificate so you need to prove you're a contributor so let's see this random commit messages... -- Jaime Casanova www.2ndQuadrant.com Professional PostgreSQL: Soporte 24x7 y

Re: [HACKERS] TABLESAMPLE patch

wake up ;) -- Jaime Casanova www.2ndQuadrant.com Professional PostgreSQL: Soporte 24x7 y capacitación Phone: +593 4 5107566 Cell: +593 987171157 regression.diffs Description: Binary data -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes

Re: [HACKERS] Turning recovery.conf into GUCs

to be overwritten by the contents of the backup. only that you need to start in recovery mode to start replication -- Jaime Casanova www.2ndQuadrant.com Professional PostgreSQL: Soporte 24x7 y capacitación Phone: +593 4 5107566 Cell: +593 987171157 -- Sent via pgsql-hackers mailing

Re: [HACKERS] Turning recovery.conf into GUCs

On Mon, Nov 24, 2014 at 12:24 PM, Jaime Casanova ja...@2ndquadrant.com wrote: On Fri, Nov 21, 2014 at 12:55 PM, Josh Berkus j...@agliodbs.com wrote: On 11/21/2014 09:35 AM, Alex Shulgin wrote: Hello, Here's an attempt to revive this patch. Yayy! Thank you. People might not like me

Re: [HACKERS] Amazon Redshift

. -- Jaime Casanova www.2ndQuadrant.com Professional PostgreSQL: Soporte 24x7 y capacitación Phone: +593 4 5107566 Cell: +593 987171157 -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql

Re: [HACKERS] Let's drop two obsolete features which are bear-traps for novices

compromise is to move MONEY datatype to a contrib. And documenting its limitations. -- Jaime Casanova 2ndQuadrant Consultant PostgreSQL Development, 24x7 Support, Training Services

Re: [HACKERS] Shared Data Structure b/w clients

link to follow. you can look at contrib/pg_stat_statements -- Jaime Casanova www.2ndQuadrant.com Professional PostgreSQL: Soporte 24x7 y capacitación Phone: +593 4 5107566 Cell: +593 987171157 -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make

Re: [HACKERS] Minmax indexes

-- Jaime Casanova www.2ndQuadrant.com Professional PostgreSQL: Soporte 24x7 y capacitación Phone: +593 4 5107566 Cell: +593 987171157 -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql

Re: [HACKERS] view reloptions

a view_reloptions() function in order to not use heap_reloptions() for views, but maybe that was too much? i haven't seen the check_option_offset thingy yet, but i hope to take a look at that tomorrow. -- Jaime Casanova www.2ndQuadrant.com Professional PostgreSQL: Soporte 24x7 y capacitación Phone: +593

Re: [HACKERS] Providing catalog view to pg_hba.conf file - Patch submission

not Local, host not Host, etc) -- Jaime Casanova www.2ndQuadrant.com Professional PostgreSQL: Soporte 24x7 y capacitación Phone: +593 4 5107566 Cell: +593 987171157 -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http

Re: [HACKERS] SQL access to database attributes

to true? -- Jaime Casanova www.2ndQuadrant.com Professional PostgreSQL: Soporte 24x7 y capacitación Phone: +593 4 5107566 Cell: +593 987171157 -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref

Re: [HACKERS] SQL access to database attributes

On Fri, May 23, 2014 at 11:06 PM, Vik Fearing vik.fear...@dalibo.com wrote: On 05/24/2014 12:03 AM, Jaime Casanova wrote: On Fri, May 23, 2014 at 10:53 PM, Vik Fearing vik.fear...@dalibo.com wrote: It was suggested to me that these options should either error out if there are existing

Re: [HACKERS] [WIP] showing index maintenance on EXPLAIN

On Thu, May 8, 2014 at 10:44 PM, Amit Kapila amit.kapil...@gmail.com wrote: On Thu, May 8, 2014 at 12:01 PM, Jaime Casanova ja...@2ndquadrant.com wrote: On Wed, May 7, 2014 at 10:52 PM, Amit Kapila amit.kapil...@gmail.com wrote: Why to capture only for Index Insert/Update and not for Read

Re: [HACKERS] [WIP] showing index maintenance on EXPLAIN

On Wed, May 7, 2014 at 10:52 PM, Amit Kapila amit.kapil...@gmail.com wrote: On Thu, May 8, 2014 at 5:30 AM, Jaime Casanova ja...@2ndquadrant.com wrote: Hi, This patch implements $subject only when ANALYZE and VERBOSE are on. I made it that way because for years nobody seemed interested

Re: [HACKERS] [WIP] showing index maintenance on EXPLAIN

On Thu, May 8, 2014 at 10:41 AM, Robert Haas robertmh...@gmail.com wrote: On Thu, May 8, 2014 at 2:31 AM, Jaime Casanova ja...@2ndquadrant.com wrote: On Wed, May 7, 2014 at 10:52 PM, Amit Kapila amit.kapil...@gmail.com wrote: On Thu, May 8, 2014 at 5:30 AM, Jaime Casanova ja...@2ndquadrant.com

[HACKERS] [WIP] showing index maintenance on EXPLAIN

we have GiST and GIN this became an interested piece of data (there are other cases even when using btree). Current patch doesn't have docs yet i will add them soon. -- Jaime Casanova www.2ndQuadrant.com Professional PostgreSQL: Soporte 24x7 y capacitación Phone: +593 4 5107566

Re: [HACKERS] [WIP] showing index maintenance on EXPLAIN

On Wed, May 7, 2014 at 7:03 PM, Josh Berkus j...@agliodbs.com wrote: On 05/07/2014 05:00 PM, Jaime Casanova wrote: Hi, This patch implements $subject only when ANALYZE and VERBOSE are on. I made it that way because for years nobody seemed interested in this info (at least no one did it) so i

[HACKERS] server vs foreign server inconsistency

at all IMHO i think 3 is not acceptable because it's annoying opinions? -- Jaime Casanova www.2ndQuadrant.com Professional PostgreSQL: Soporte 24x7 y capacitación Phone: +593 4 5107566 Cell: +593 987171157 -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org

Re: [HACKERS] Patch for CREATE RULE sgml -- Was in: [DOCS]

-- Jaime Casanova www.2ndQuadrant.com Professional PostgreSQL: Soporte 24x7 y capacitación Phone: +593 4 5107566 Cell: +593 987171157 -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql

Re: [HACKERS] db_user_namespace a temporary measure

the db then is the global 'joe' that want to login -- Jaime Casanova www.2ndQuadrant.com Professional PostgreSQL: Soporte 24x7 y capacitación Phone: +593 4 5107566 Cell: +593 987171157 -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your

Re: [HACKERS] db_user_namespace a temporary measure

On Tue, Mar 11, 2014 at 10:52 PM, Andrew Dunstan and...@dunslane.net wrote: On 03/11/2014 11:50 PM, Jaime Casanova wrote: On Tue, Mar 11, 2014 at 10:06 PM, Tom Lane t...@sss.pgh.pa.us wrote: But not sure how to define a unique index that allows (joe, db1) to coexist with (joe, db2

Re: [HACKERS] 9.2.1 index-only scans : abnormal heap fetches after VACUUM FULL

=values@entry=0x1852f40, isnull=isnull@entry=0x184f920 , newRelHasOids=1 '\001', rwstate=rwstate@entry=0x1849e98) at cluster.c:1670 -- Jaime Casanova www.2ndQuadrant.com Professional PostgreSQL: Soporte 24x7 y capacitación Phone: +593 4 5107566 Cell: +593 987171157 -- Sent

Re: [HACKERS] Trigger information for auto_explain.

(). 0002_auto_explain_triggers_v1_20140114.patch Enable auto_explain to output trigger information. Documentation will be added later.. Hi, I think documentation is the only thing that stops this patch to be commitable... can you add it? -- Jaime Casanova www.2ndQuadrant.com Professional PostgreSQL: Soporte

Re: [HACKERS] Turning recovery.conf into GUCs

On Wed, Jan 15, 2014 at 2:00 AM, Jaime Casanova ja...@2ndquadrant.com wrote: On Mon, Nov 18, 2013 at 12:27 PM, Andres Freund and...@2ndquadrant.com wrote: * Maybe we should rename names like pause_at_recovery_target to recovery_pause_at_target? Since we already force everyone to bother

Re: [HACKERS] tracking commit timestamps

down; automatic recovery in progress LOG: record with zero length at 0/3112AE58 LOG: redo is not required FATAL: cannot make new WAL entries during recovery LOG: startup process (PID 24876) exited with exit code 1 LOG: aborting startup due to startup process failure -- Jaime Casanova

Re: [HACKERS] Turning recovery.conf into GUCs

restore_command and i changed it because archive_command's parameter is called XLogArchiveCommand so i wanted the name to follow the same format. i can return it to the original name if no one likes XLogRestoreCommand -- Jaime Casanova www.2ndQuadrant.com Professional PostgreSQL: Soporte

Re: [HACKERS] Turning recovery.conf into GUCs

On Fri, Nov 15, 2013 at 9:28 AM, Peter Eisentraut pete...@gmx.net wrote: On 11/13/13, 12:17 AM, Jaime Casanova wrote: I have rebased Michael Paquier's patch and did a few changes: * changed standby.enabled filename to recovery.trigger * make archive_command a SIGHUP parameter again * make

Re: [HACKERS] Commitfest II CLosed

to bind anyone also) i would prefer to see a flag stating if number of reviews registered there are less than submitted patches. This could be a column just after the author of a patch, so people can give preference to patches of submitters that are also reviewing other people's patches. -- Jaime

Re: [HACKERS] Turning recovery.conf into GUCs

merger in the same release we introduce configuration directory (or after it). you mean the ALTER SYSTEM syntax? anyway, why that restriction? -- Jaime Casanova www.2ndQuadrant.com Professional PostgreSQL: Soporte 24x7 y capacitación Phone: +593 4 5107566 Cell: +593 987171157

Re: [HACKERS] Turning recovery.conf into GUCs

this should be up to the packagers, no? or, do you mean something else? -- Jaime Casanova www.2ndQuadrant.com Professional PostgreSQL: Soporte 24x7 y capacitación Phone: +593 4 5107566 Cell: +593 987171157 -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make

Re: [HACKERS] Turning recovery.conf into GUCs

put the recovery variables into postgresql.conf, then? create a recovery trigger file (called standby.enabled in current patch) in $PGDATA and start the server -- Jaime Casanova www.2ndQuadrant.com Professional PostgreSQL: Soporte 24x7 y capacitación Phone: +593 4 5107566 Cell

Re: [HACKERS] Turning recovery.conf into GUCs

version of PostgreSQL they are on. well, people will go out of replication also if they forgot the recovery trigger file even if they set the variables in postgresql.conf it happens two me twice today ;) -- Jaime Casanova www.2ndQuadrant.com Professional PostgreSQL: Soporte 24x7 y

Re: [HACKERS] Turning recovery.conf into GUCs

of these are too different. even if we are not sure we can do this now and change them as SIGHUP later -- Jaime Casanova www.2ndQuadrant.com Professional PostgreSQL: Soporte 24x7 y capacitación Phone: +593 4 5107566 Cell: +593 987171157 -- Sent via pgsql-hackers mailing list (pgsql

[HACKERS] Turning recovery.conf into GUCs

, should be PGC_POSTMASTER only + {standby_mode, PGC_POSTMASTER, REPLICATION_STANDBY, -- Jaime Casanova www.2ndQuadrant.com Professional PostgreSQL: Soporte 24x7 y capacitación Phone: +593 4 5107566 Cell: +593 987171157 -- Sent via pgsql-hackers mailing list (pgsql-hackers

Re: [HACKERS] [PoC] pgstattuple2: block sampling to reduce physical read

that number as absolute for good accuracy in every relation? why not a percentage, maybe an argument to the function? also the name pgstattuple2, doesn't convince me... maybe you can use pgstattuple() if you use a second argument (percentage of the sample) to overload the function -- Jaime Casanova

Re: [HACKERS] Assertions in PL/PgSQL

(client_min_messages) to make it appear or not of course, this has the disadvantage that an EXCEPTION level will always happen... or you can make it a new loglevel that mean EXCEPTION if asserts_enabled -- Jaime Casanova www.2ndQuadrant.com Professional PostgreSQL: Soporte 24x7 y capacitación

Re: [HACKERS] VMs for Reviewers Available

)? not always our reviewers know how to install those tools -- Jaime Casanova 2ndQuadrant: Your PostgreSQL partner

Re: [HACKERS] Assertions in PL/PgSQL

El 21/09/2013 17:16, Jaime Casanova ja...@2ndquadrant.com escribió: On Fri, Sep 20, 2013 at 5:17 AM, Marko Tiikkaja ma...@joh.to wrote: On 9/20/13 12:09 PM, Amit Khandekar wrote: On 16 September 2013 03:43, Marko Tiikkaja ma...@joh.to wrote: I think it would be extremely surprising

Re: [HACKERS] Minmax indexes

to 2 blocks: it's only 1 blocks now CONTEXT: automatic vacuum of table postgres.public.t1 ERROR: could not truncate file base/12645/16397_vm to 2 blocks: it's only 1 blocks now CONTEXT: automatic vacuum of table postgres.public.t1 -- Jaime Casanova www.2ndQuadrant.com Professional

Re: [HACKERS] Minmax indexes

] -- Jaime Casanova www.2ndQuadrant.com Professional PostgreSQL: Soporte 24x7 y capacitación Phone: +593 4 5107566 Cell: +593 987171157 Program received signal SIGABRT, Aborted. 0x7f4428819475 in *__GI_raise (sig=optimized out) at ../nptl/sysdeps/unix/sysv/linux/raise.c:64 64

Re: [HACKERS] Minmax indexes

On Tue, Sep 17, 2013 at 3:30 AM, Thom Brown t...@linux.com wrote: On 17 September 2013 07:20, Jaime Casanova ja...@2ndquadrant.com wrote: On Mon, Sep 16, 2013 at 3:47 AM, Thom Brown t...@linux.com wrote: On 15 September 2013 01:14, Alvaro Herrera alvhe...@2ndquadrant.com wrote: Hi

Re: [HACKERS] Minmax indexes

On Tue, Sep 17, 2013 at 8:43 AM, Thom Brown t...@linux.com wrote: On 17 September 2013 14:37, Jaime Casanova ja...@2ndquadrant.com wrote: On Tue, Sep 17, 2013 at 3:30 AM, Thom Brown t...@linux.com wrote: On 17 September 2013 07:20, Jaime Casanova ja...@2ndquadrant.com wrote: On Mon, Sep

Re: [HACKERS] Assertions in PL/PgSQL

be implemented as extension without any lost of compatibility or lost of functionality. So can you redesign this without new keyword? Hi, If using ASSERT as keyword is not acceptable, not that i agree but in case. What about using RAISE EXCEPTION WHEN (condition) -- Jaime Casanova 2ndQuadrant: Your

Re: [HACKERS] Assertions in PL/PgSQL

El 15/09/2013 17:13, Marko Tiikkaja ma...@joh.to escribió: On 2013-09-15 23:23, Jaime Casanova wrote: If using ASSERT as keyword is not acceptable, not that i agree but in case. What about using RAISE EXCEPTION WHEN (condition) I think it would be extremely surprising if a command like

Re: [HACKERS] [PATCH] bitmap indexes

concurrently (attached index_failure.txt), it wasn't just a crash i couldn't start up the server again after it -- Jaime Casanova www.2ndQuadrant.com Professional PostgreSQL: Soporte 24x7 y capacitación Phone: +593 4 5107566 Cell: +593 987171157 postgres=# create index concurrently

Re: [HACKERS] Assertions in PL/PgSQL

use per function then i can keep the ASSERT and activate them by replacing the function -- Jaime Casanova www.2ndQuadrant.com Professional PostgreSQL: Soporte 24x7 y capacitación Phone: +593 4 5107566 Cell: +593 987171157

Re: [HACKERS] Assertions in PL/PgSQL

El 14/09/2013 15:18, Marko Tiikkaja ma...@joh.to escribió: On 2013-09-14 21:55, Jaime Casanova wrote: On Sat, Sep 14, 2013 at 1:52 PM, Marko Tiikkaja ma...@joh.to wrote: And by compile time here, I mean at the time when the PL/PgSQL function is compiled, not the postgres server binary

Re: [HACKERS] Differences in WHERE clause of SELECT

ask for all customers whose names begins with 'A' but that the code begins with '1'? -- Jaime Casanova www.2ndQuadrant.com Professional PostgreSQL: Soporte 24x7 y capacitación Phone: +593 4 5107566 Cell: +593 987171157 -- Sent via pgsql-hackers mailing list (pgsql-hackers

Re: [HACKERS] in-catalog Extension Scripts and Control parameters (templates?)

On Sat, Jul 6, 2013 at 2:25 PM, Dimitri Fontaine dimi...@2ndquadrant.fr wrote: Jaime Casanova ja...@2ndquadrant.com writes: not sure if you're wrong. but at the very least, you miss a heap_freetuple(oldtup) there, because get_catalog_object_by_oid() Well, oldtup can be either a syscache copy

Re: [HACKERS] in-catalog Extension Scripts and Control parameters (templates?)

On Mon, Jun 24, 2013 at 6:20 AM, Dimitri Fontaine dimi...@2ndquadrant.fr wrote: Jaime Casanova ja...@2ndquadrant.com writes: just tried to build this one, but it doesn't apply cleanly anymore... specially the ColId_or_Sconst contruct in gram.y Please find attached a new version of the patch

Re: [HACKERS] in-catalog Extension Scripts and Control parameters (templates?)

On Thu, Jul 4, 2013 at 2:42 AM, Jaime Casanova ja...@2ndquadrant.com wrote: create extension test version '123'; CREATE EXTENSION postgres=# \df List of functions Schema | Name | Result data type | Argument data types | Type

Re: [HACKERS] in-catalog Extension Scripts and Control parameters (templates?)

sure that evi in line 1150 is only because you need to receive the returned value. Maybe you could use (void) get_ext_ver_info() (or it should be (void *)?) to avoid that assignment and keep compiler quiet PS: i'm on gcc (Debian 4.7.2-5) 4.7.2 -- Jaime Casanova www.2ndQuadrant.com

Re: [HACKERS] in-catalog Extension Scripts and Control parameters (templates?)

working on that, setting up the documentation tool set. Fixed in the attached version 6 of the patch. just tried to build this one, but it doesn't apply cleanly anymore... specially the ColId_or_Sconst contruct in gram.y -- Jaime Casanova www.2ndQuadrant.com Professional PostgreSQL: Soporte

Re: [HACKERS] problem with commitfest redirection

. right URL is http://www.postgresql.org/message-id/CAFjNrYuh=4Vwnv=2n7cj0jjuwc4hool1epxsoflj6s19u02...@mail.gmail.com -- Jaime Casanova www.2ndQuadrant.com Professional PostgreSQL: Soporte 24x7 y capacitación Phone: +593 4 5107566 Cell: +593 987171157 -- Sent via pgsql-hackers

Re: [HACKERS] Hard limit on WAL space used (because PANIC sucks)

preallocated log files around, specifically so it can get consistent and halt cleanly if it runs out of disk space. fwiw, informix (at least until IDS 2000, not sure after that) had the same thing. only this was a parameter to set, and bad things happened if you forgot about it :D -- Jaime

Re: [HACKERS] Extent Locks

for next_extend_blocks so formula is needed, or of course the automated calculation that has been proposed -- Jaime Casanova www.2ndQuadrant.com Professional PostgreSQL: Soporte 24x7 y capacitación Phone: +593 4 5107566 Cell: +593 987171157 -- Sent via pgsql-hackers mailing list

Re: [HACKERS] Extent Locks

On Tue, May 28, 2013 at 8:38 AM, Jaime Casanova ja...@2ndquadrant.com wrote: We can also think in GUC/reloption for next_extend_blocks so formula is needed, or of course the automated calculation that has been proposed s/so formula is needed/so *no* formula is needed btw, we can also use

Re: [HACKERS] Extent Locks

some slop. And how do you decide the amount of that slop? -- Jaime Casanova www.2ndQuadrant.com Professional PostgreSQL: Soporte 24x7 y capacitación Phone: +593 4 5107566 Cell: +593 987171157 -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes

Re: [HACKERS] Planning incompatibilities for Postgres 10.0

even exporting the plan so we don't need to replan again... Not sure if that is possible, just hand waving... -- Jaime Casanova www.2ndQuadrant.com Professional PostgreSQL: Soporte 24x7 y capacitación Phone: +593 4 5107566 Cell: +593 987171157 -- Sent via pgsql-hackers mailing

Re: [HACKERS] New committers

the pgcon closing session - Jeff Davis, Stephen frost, fujii masao and Noah misch. Congratulations for you guys... -- Jaime Casanova www.2ndQuadrant.com Professional PostgreSQL: Soporte 24x7 y capacitación Phone: +593 4 5107566 Cell: +593 987171157 -- Sent via pgsql-hackers

  1   2   3   4   5   6   7   8   9   >