Результат поиска

pgsql-general   (344)

2018-10-10 00:24:47 | pg9.6: PITR paused just after failover, need manual resume (magodo)

Xid oldest/newest: 0/0 < 2018-10-10 03:09:57.013 UTC > DEBUG: transaction ID wrap limit

2018-10-01 15:32:11 | Re: backend_xmin in pg_stat_replication (Andres Freund)

xid (max 2^32-1), whereas txid_snapshot_xmin returns an xid *with* epoch (max 2^64-1). What

2018-09-01 23:47:03 | error in vacuum (Dave Peticolas)

xid 3433096759 <(343)%20309-6759> from before relfrozenxid 3498422955 What can I do to repair

2018-08-14 16:23:52 | Re: Duplicating data folder without tablespace, for read access (Tom Lane)

XID wraparound trouble. But it's hard to see how you get to that without

pgsql-hackers   (1240)

2018-10-15 13:06:35 | Re: WIP: "More fair" LWLocks (Alexander Korotkov)

xid clearing and group clog update, which accumulates queue. Once exclusive lock is obtained, all the queue

2018-10-15 09:39:45 | Re: Undo logs (Amit Kapila)

xid_map_add(xlrec->xid, xlrec->logno); + + /* + * Whatever follows is the first record for this

2018-10-12 13:15:22 | Re: Continue work on changes to recovery.conf API (Sergei Kornilov)

xid, recovery_target_lsn Renamed to promote_trigger_file Possible we need something like separate

2018-10-05 08:30:17 | Re: shared-memory based stats collector (Kyotaro HORIGUCHI)

xid, uint16 info, extern void pgstat_twophase_postabort(TransactionId xid, uint16 info, void *recdata, uint32

pgadmin-hackers   (7)

2017-06-12 10:57:24 | [pgadmin-hackers] [pgAdmin4][Patch][RM_ 2477]: New Line text edit pop up renders offpage when (Surinder Kumar)

xid', 'real'). 3) Remove inline styles from rendered editors and move its styles to CSS file

2016-05-26 10:43:12 | Re: PATCH: pgAdmin4 windows installer (Dave Page)

xid_type.obj build\temp.win32-2.7\Release\psycopg\adapter_asis.obj build\temp.win32-2.7\Release\psycopg\adapter

2008-10-27 11:03:04 | Re: [HACKERS] Hot Standby utility and administrator functions (Emmanuel Cecchet)

xid(), pg_last_completed_xact_xid() or pg_last_recovered_xact_timestamp(), I would like

2007-07-12 08:13:33 | xlog switch & last record before the switch (Florian G. Pflug)

xid 0: XLOG - checkpoint: redo 0/16E00020; tli 1; xid 0/1347; oid 24576; multi 1; offset

pgadmin-support   (2)

2016-11-11 10:14:14 | Re: pgadmin server-status does not display (Walter Nordmann)

xid::text, backend_xmin::text, (SELECT min(l1.pid) FROM pg_locks l1 WHERE GRANTED

2005-09-19 08:46:23 | Re: HELP - Recover function delete (Andreas Pflug)

XID could be tuned back (by hacking the kernel), but I doubt it's worth

pgsql-admin   (146)

2018-09-12 18:46:07 | postgresql Logical Replication Stream fails with Connection/Socketerrors consistently (Jammie)

XID_IN_STREAM_CHANGES, true) .withSlotOption(PostgreSQLConstants.INCLUDE_TIMESTAMP_IN_STREAM_CHANGES, true) .withSlotOption(PostgreSQLConstants

2018-08-15 21:21:00 | Cursors (Natalie Wenz)

xid rolling via autovacuum, attaching/detaching partitions, etc). declare cursname no scroll cursor without hold for ... fetch

2018-06-11 19:05:10 | Re: pg_stat_activity (Rui DeSousa)

xid , pg_stat_activity.backend_xmin , age(now(), pg_stat_activity.state_change) as state

2018-05-04 13:38:59 | RES: indexes missing (Lincoln Teixeira Gomes)

XID. When you run a query, any query, you can only see all those records

pgsql-advocacy   (2)

2011-07-10 01:39:24 | Interesting Slashdot article that attracted a lot of comments about pg (Gavin Flower)

XID problem (not that it is likely to affect my usage of pg!). http:///story/11/07/09/1256241/Facebook-Trapped-In-MySQL-a-Fate-Worse-Than-Death

2005-02-08 18:59:05 | Wrap-around XID's (Mike Tamburro)

XID's. We read together the v8.0 docs and saw the work-around solution (section

pgsql-announce   (108)

2018-09-23 19:14:23 | == PostgreSQL Weekly News - September 23, 2018 == (David Fetter)

xid using 64 bits. Peter Geoghegan sent in another revision of a patch to make

2018-09-09 20:36:19 | == PostgreSQL Weekly News - September 9, 2018 == (David Fetter)

XID are discarded hence no files present in pg_twophase/ should be torned and have

2018-09-02 22:35:53 | == PostgreSQL Weekly News - September 2, 2018 == (David Fetter)

xid when replaying a btree deletion record, so one would need connections on a standby

2018-07-29 22:52:32 | == PostgreSQL Weekly News - July 29 2018 == (David Fetter)

xid wraparound. Fabien COELHO sent in a patch to ensure that pgbench's hash() fails

pgsql-bugs   (153)

2018-08-25 07:54:39 | Re: BUG #15346: Replica fails to start after the crash (Alexander Kukushkin)

xid = 0, pd_linp = 0x7f06ed9e9598} Index page LSN: AB3/56BF3B68 Current LSN: AB3/50323E78 Is there a way to recover

2018-06-12 16:02:44 | BUG #15240: JDBC driver sometimes hangs on copy out; suspect Json (PG Bug reporting form)

xid | backend_xmin | query | backend_type -------+---------+------+----------+----------+------------------------+-------------+-----------------+-------------+-------------------------------+------------+-------------------------------+------------------------------+-----------------+------------+-------+-------------+--------------+--------------------------------------------------------------------+---------------- 16404 | t08_dev | 8713 | 10 | bwbecker

2018-05-23 21:20:23 | Re: BUG #14820: Standby crash with "could not access status oftransaction" (for track_commit_timestamp (Jeremy Schneider)

xid 68539960: flags 0 LOCK_ONLY EXCL_LOCK , blkref #0: rel 1663/11038913/16866 blk 6135 Unfortunately

2018-05-21 18:04:28 | Re: crash while decoding INSERT ON CONFLICT (Euler Taveira)

xid 144441221: flags 0 LOCK_ONLY KEYSHR_LOCK , blkref #0: rel 1663/355309/41910223 blk 230 rmgr

pgsql-cluster-hackers   (3)

2010-05-11 09:52:50 | Re: GDQ iimplementation (Jan Wieck)

XID after that. Any XID lower/equal to that one could possibly have written into the old segment

2010-04-11 02:36:41 | Cluster Features and Commit order of transactions (Greg Smith)

XID feed", and "Creation of primary keys online" Please directly correct those or let me know

2010-02-07 08:35:03 | Re: PgCon: who will be there? (Koichi Suzuki)

able to discuss about snapsot import and XID feed. Yes, it must be very exciting.

pgsql-committers   (319)

2018-09-07 18:01:37 | pgsql: Improve handling of corrupted two-phase state files at recovery (Michael Paquier)

XID are discarded hence no files present in pg_twophase/ should be torned and have

2018-08-31 18:07:49 | pgsql: Ensure correct minimum consistent point on standbys (Michael Paquier)

xid when replaying a btree deletion record, so one would need connections on a standby

2018-08-31 18:07:49 | pgsql: Ensure correct minimum consistent point on standbys (Michael Paquier)

xid when replaying a btree deletion record, so one would need connections on a standby

2018-08-31 18:07:49 | pgsql: Ensure correct minimum consistent point on standbys (Michael Paquier)

xid when replaying a btree deletion record, so one would need connections on a standby

pgsql-cygwin   (3)

2001-12-16 14:00:55 | unexpected SIGALRM (Hiroshi Inoue)

xid=17826, lockmode=1) at lock.c:1018 #13 0x0050c8f5 in UnlockRelation (relation=0xa06c168, lockmode=1) at lmgr.c

2001-09-16 07:56:11 | Re: "pgbench -c 13" causes backend hangup. (Yutaka tanida)

xid=3288, lockmode=4) at lock.c:739 #8 0x004d2b11 in XactLockTableWait (xid=3280) at lmgr.c

2001-05-30 20:20:57 | ant wants to build a J2EE jdbc driver (I only want a J2SE driver!) (Jerry Asher)

Xid [javac] location: package xa [javac] import javax.transaction.xa.Xid; [javac] ^ [javac] C:\cygnus

pgsql-docs   (15)

2018-10-01 09:42:08 | pgrowlocks columns do not match docs: "modes" instead of "lock_type" (PG Doc comments form)

XID, -- locking XID OUT multi bool, -- multi XID? OUT xids xid[], -- multi XIDs OUT modes

2016-09-06 09:41:41 | Re: FrozenTransactionId (Tom Lane)

XID, FrozenTransactionId, ... considered older than every normal XID. Frozen row versions are treated as if ..." It might

2015-10-07 14:32:47 | Re: max_worker_processes on the standby (Fujii Masao)

xid) FROM pg_last_committed_xact()" 7. restart the server 8. run "SELECT pg_last

2013-11-12 22:39:39 | Re: MVCC snapshot timing (Bruce Momjian)

xid at the time they take their snapshot and other running xids that controls that

pgsql-interfaces   (16)

2008-05-19 00:17:02 | Re: pg_subtrans directory grows over 1 GB, is there a way to control it (Dennis Wang)

XID age before forced vacuum     #vacuum_freeze_min_age = 100000000   My pg_clog file sometimes

2003-03-04 01:58:26 | Re: User Feedback (Christoph Haller)

xid for transactions. The unclear part, at least to me, was what the role of the xid was in the view

2001-05-22 09:19:41 | Pgaccess - localization problem (Ловпаче Айдамир)

xid cid} It seems to me - that tcl does not recognize 8-bit character? But I have

2001-02-08 05:42:58 | Re: PostgreSQL and PHP persistent connections (Jan Wieck)

XID's until we have silent rollback in 7.2. Jan -- #======================================================================# # It's easier to get forgiveness

pgsql-jdbc   (34)

2018-09-03 10:33:54 | postgresql Logical Replication Stream fails with “Database connection failed when reading from copy” (Jammie)

XID_IN_STREAM_CHANGES, true) .withSlotOption(PostgreSQLConstants.INCLUDE_TIMESTAMP_IN_STREAM_CHANGES, true) .withSlotOption(PostgreSQLConstants

2018-03-15 15:26:39 | [pgjdbc/pgjdbc] 7bb4eb: [maven-release-plugin] prepare releaseREL42.2.1 (Vladimir Sitnikov)

Xid * XAException.XAER_PROTO is used when some wrong sequence of method calls is invoked

2018-03-11 08:40:21 | [pgjdbc/pgjdbc] e5aab1: Adjust XAException return codes for bettercompati... (chalda)

Xid * XAException.XAER_PROTO is used when some wrong sequence of method calls is invoked

2013-03-15 18:30:03 | Re: Re: [pgjdbc] XADataSource support for resource sharing & interleaving. (#47) (Bryan Varner)

Xid, it's aggressively used for another Xid, and an XAResource returning true for isSameRM

pgsql-novice   (15)

2018-02-14 12:33:02 | WAL settings (J B)

XID age before forced vacuum # (change requires restart) #autovacuum_multixact_freeze_max_age = 400000000 # maximum

2017-10-23 19:23:04 | [NOVICE] Issues shutting down PostgreSQL 10 cleanly (Stephen Froehlich)

Xid oldest/newest: 0/0 2017-10-20 09:25:00.077 MDT [33361] DEBUG:  transaction ID wrap

2013-04-24 18:42:58 | Could GetTransactionSnapshot be deferred till needed. (Daniel Wood)

XID is allocate only when needed, is there any way to defer the acquisition of a snapshot

2012-11-14 00:30:21 | Re: Restoring data from TABLESPACE files (Tom Lane)

XID counter. Quite aside from any efficiency problems with that, it'd be impossible to guarantee

pgsql-odbc   (20)

2004-10-01 14:37:30 | Re: OIDS column required with ODBC ? (Shachar Shemesh)

xid and oid to each query. It can then identify each row in the result

2003-05-01 10:46:58 | Error:Unable to identify an operator (Miguel Juan)

xid' and 'int4' You will have to retype this query using an explicit cast I get this

2003-05-01 10:46:57 | Fw: Error:Unable to identify an operator (Miguel Juan)

xid' and 'int4' You will have to retype this query using an explicit cast I get this

2002-08-29 06:08:01 | Linking MSSQL to Postgresq (Ian Crick)

xid' PGAPI_Columns: table='pg_database',field_name='datfrozenxid',type=28,name='xid' PGAPI_Columns

pgsql-patches   (141)

2008-09-24 15:44:03 | Re: [HACKERS] Subtransaction commits and Hot Standby (Simon Riggs)

xid status change. TransactionIdSetPageStatus() performs locking and handles write_ok problem, as did code it replaces

2008-07-09 05:54:25 | Re: page macros cleanup (ver 04) (Heikki Linnakangas)

xid = GetCurrentTransactionId(); ItemId lp; HeapTupleData tp; ! PageHeader dp; Buffer buffer; bool have_tuple_lock = false

2008-06-10 08:50:10 | Refactoring xlogutils.c (Heikki Linnakangas)

xid = xlrec->cutoff_xid; - Relation reln; Buffer buffer; Page page; if (record->xl_info & XLR_BKP_BLOCK

2008-06-09 23:33:10 | VACUUM Improvements - WIP Patch (Pavan Deolasee)

xid). May be we should trigger pruning if we got a line pointer bloat in a page

pgsql-performance   (80)

2017-04-06 00:09:28 | Re: -EXT-Re: Table not using tsvector gin index andperformance much worse than when it (Sfiligoi, Igor)

XID age before forced vacuum # (change requires restart)/ * And this #gin_pending_list_limit = 4MB * gin_clean

2017-03-22 01:56:34 | Re: [PERFORM] Optimizing around retained tuples (Claudio Freire)

xid horizon from moving forward, thus dead tuples from A cannot be reclaimed in case

2016-06-29 18:30:43 | Re: Random slow queries (Jeff Janes)

XID-in-progress test. I am not entirely sure why this (as opposed to the previous

2016-03-18 18:46:54 | Re: [GENERAL] grant select on pg_stat_activity (Adrian Klaver)

active backend_xid | backend_xmin | 58635 query | select * from pg_stat_activity; -- Adrian Klaver adrian.klaver@aklaver.com

pgsql-sql   (27)

2018-02-13 12:58:44 | pg_walldump and PITR. PostgreSQL 10.1 (ROS Didier)

xid of the problematic transaction (update ville set nville = 'PANAME' ; ). How can I do that

2014-10-09 11:07:11 | Re: could not access status of transaction pg_multixact issue (jim_yates)

xid but expression is of type integer -- View this message in context: http:///could-not-access-status-of-transaction-pg-multixact-issue-tp5822248p5822376.html Sent

2013-12-16 07:59:02 | Query caching (with 8.3) (Achilleas Mantzios)

xid_tables_cols(OUT table_name TEXT, OUT column_name TEXT, OUT data_type TEXT

2012-06-14 02:39:53 | Insane behaviour in 8.3.3 (Achilleas Mantzios)

xid_seq');currval --------- 61972 (1 row) dynacom=# SELECT id from items_tmp WHERE id=1261319 AND xid=61972; id ---------1261319 (1 row) dynacom

pgsql-students   (1)

2007-08-29 16:14:04 | Re: Final status of projects? (Florian G. Pflug)

xid assignment. So I didn't even consider that HOT could mean hot ;-) Full Ack. The fact

pgsql-www   (6)

2016-06-28 14:00:43 | Error 503 related to Varnish cache server (David G. Johnston)

XID: 460806 Varnish cache server https:///docs/devel/static/index.html Error 503 Backend fetch failed Backend fetch failed

2016-01-26 06:36:26 | archives.postgresql.org problem (Oleg Bartunov)

Backend fetch failed Backend fetch failed Guru Meditation: XID: 2441931 Varnish cache server Regards, Oleg

2015-10-06 04:04:54 | Re: Archives down? 503 error (Magnus Hagander)

XID: 13756651 > > > >         Varnish cache server > > Yeah, zalkon was having

2014-11-06 17:55:28 | www.postgresql.org is having problems (Tom Lane)

under doc/ Error 503 Service Unavailable Service Unavailable Guru Meditation: XID: 1590106948 Varnish cache server

psycopg   (2)

2015-03-30 11:40:07 | Segfault in BackendIdGetTransactionIds with psycopg2 (Vladimir Borodin)

xid=0x7f2a1b714798, xmin=0x7f2a1b71479c) at sinvaladt.c:426 #1 0x00000000006287f4 in pgstat_read_current_status () at pgstat.c

2015-03-30 11:11:17 | Segfault in BackendIdGetTransactionIds with psycopg2 (Vladimir Borodin)

xid=0x7f2a1b714798, xmin=0x7f2a1b71479c) at sinvaladt.c:426 #1 0x00000000006287f4 in pgstat_read_current_status () at pgstat.c