Re: [HACKERS] Proposal : For Auto-Prewarm.

Thanks Beena, On Tue, Feb 7, 2017 at 4:46 PM, Beena Emerson wrote: > Few more comments: > > = Background worker messages: > > - Workers when launched, show messages like: "logical replication launcher > started”, "autovacuum launcher started”. We should probably have a

Re: [HACKERS] Postgres_fdw behaves oddly

Hi, On Fri, 3 Feb 2017 18:12:01 +0900 vinayak wrote: > Hello, > > I have tested some scenarios of inserting data into two foreign tables > using postgres_fdw. All the test cases works fine except Test 5. > > In Test 5, I am expecting error as both the rows

Re: [HACKERS] LWLock optimization for multicore Power machines

Am Montag, den 06.02.2017, 22:44 +0300 schrieb Alexander Korotkov: >    2. Also could you run each test longer: 3-5 mins, and run them > with > >    variety of clients count? So here are some other results. I've changed max_connections to 300. The bench was prewarmed and run 300s each. I could

[HACKERS] DROP SUBSCRIPTION and ROLLBACK

Hi all, While testing logical replciation I found that if the transaction issued DROP SUBSCRIPTION　rollbacks then the logical repliation stops and the subscription can never be removed later. The document says that the replication worker associated with the subscription will not stop until after

Re: [HACKERS] [COMMITTERS] pgsql: Release note updates.

On Tue, Feb 7, 2017 at 5:23 PM, Alvaro Herrera wrote: > Tom Lane wrote: > > Release note updates. > > > > Add item for last-minute CREATE INDEX CONCURRENTLY fix. > > Hi, > > Sorry for not noticing earlier, but there is a bug in the notes: > > + If CREATE INDEX

Re: [HACKERS] [COMMITTERS] pgsql: Release note updates.

Tom Lane wrote: > Release note updates. > > Add item for last-minute CREATE INDEX CONCURRENTLY fix. Hi, Sorry for not noticing earlier, but there is a bug in the notes: + If CREATE INDEX CONCURRENTLY was used to build an index + that depends on a column not previously indexed, then

Re: [HACKERS] Proposal : For Auto-Prewarm.

On Tue, Feb 7, 2017 at 12:24 PM, Amit Kapila wrote: > On Tue, Feb 7, 2017 at 11:53 AM, Beena Emerson > wrote: >> Are 2 workers required? >> > > I think in the new design there is a provision of launching the worker > dynamically to dump the

Re: [HACKERS] WAL consistency check facility

On Tue, Jan 31, 2017 at 9:36 PM, Robert Haas wrote: > > +if (!HeapTupleHeaderXminFrozen(page_htup)) > +page_htup->t_infomask |= HEAP_XACT_MASK; > +else > +page_htup->t_infomask |= HEAP_XMAX_COMMITTED | >

Re: [HACKERS] Proposal : For Auto-Prewarm.

On Tue, Feb 7, 2017 at 3:01 PM, Mithun Cy wrote: > On Tue, Feb 7, 2017 at 11:53 AM, Beena Emerson > wrote: > > launched by other applications. Also with max_worker_processes = 2 and > > restart, the system crashes when the 2nd worker is not

Re: [HACKERS] Proposal : For Auto-Prewarm.

On Tue, Feb 7, 2017 at 11:53 AM, Beena Emerson wrote: > launched by other applications. Also with max_worker_processes = 2 and > restart, the system crashes when the 2nd worker is not launched: > 2017-02-07 11:36:39.132 IST [20573] LOG: auto pg_prewarm load : number of

[HACKERS] Backport of pg_statistics typos fix

Hi, I found typos "pg_statistics" in REL9_6_STABLE, but that has been fixed in the master branch. Fix typo: pg_statistics -> pg_statistic https://git.postgresql.org/gitweb/?p=postgresql.git;a=commitdiff;h=5a366b4ff4ceceb9793fcc13c3f097ee0d32c56d;hp=f7c62462402972b13d10e43f104ca0c0fecb6d08 I

Re: [HACKERS] Adding the optional clause 'AS' in CREATE TRIGGER

On Wednesday, November 16, 2016 4:31 PM Okano Naoki wrote: > > But in any case it would be a serious mistake to do this without first > > implementing CREATE OR REPLACE TRIGGER. I think that's an entirely > > separate > > proposal and you would be well advised to treat it as such. > I see.

<    1   2