xid - Результат поиска в архиве списков рассылки

pgsql-general   (340)

2018-07-03 10:28:26 | One transaction and several processes (Valery Kuzmin)

XID. 2. Calling service updates some data. 3. Need to detach a transaction from a service

2018-06-18 05:16:18 | Replication using PGLogical (Abhinav Singh)

xid 121331 latest complete 121330 next xid 121331) ***************************************** 2018-06-14 07:11:23.902 UTC [18490] DEBUG

2018-06-11 17:08:12 | Re: pg_upgrade and wraparound (Andres Freund)

xid != 0) { ControlFile.checkPointCopy.nextXid = set_xid; /* * For the moment, just set oldestXid to a value

2018-05-30 13:54:59 | Re: Query running for 12 hours (Yavuz Selim Sertoğlu)

xid=0,sid=5b0ddb70.1bd8 ,LOG: *duration*: *739797.540* ms execute : select this_.ID as ID107_1_, this

pgsql-hackers   (1221)

2018-07-18 15:31:07 | One transaction and several processes (Valery Kuzmin)

XID. 2. Calling service updates some data. 3. Need to detach a transaction from a service

2018-07-17 14:46:08 | Re: Another fun fact about temp tables and wraparound (Alvaro Herrera)

xid age to avoid this problem -- see autovacuum lines 2046ff. (Except it doesn't do anything

2018-07-16 20:36:51 | Re: ENOSPC FailedAssertion("!(RefCountErrors == 0)" (Tom Lane)

xid, uint32 *epoch) void ShutdownXLOG(int code, Datum arg) { + /* + * We should have an aux process

2018-07-13 08:40:04 | Re: [HACKERS] Restricting maximum keep segments by repslots (Kyotaro HORIGUCHI)

xid,xid,pg_lsn,pg_lsn}', - proargmodes => '{o,o,o,o,o,o,o,o,o,o,o}', - proargnames

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   (144)

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

2018-03-25 01:07:05 | bloatcheck.sql (A System Admin)

XID age before forced vacuum # (change requires restart) #autovacuum_vacuum_cost_delay = 20ms # default vacuum

2018-03-22 13:43:18 | Re: pg_stat_activity doubts (Ray Stell)

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   (104)

2018-07-15 22:19:15 | == PostgreSQL Weekly News - July 15 2018 == (David Fetter)

XID, which might lead to unnecessary query cancellations on hot standby servers. Per reports from

2018-07-01 21:09:14 | == PostgreSQL Weekly News - July 01 2018 == (David Fetter)

xid. Instead of searching one big list linearly, let's create one list per xid and put them

2018-06-10 22:28:35 | == PostgreSQL Weekly News - June 10 2018 == (David Fetter)

xid to standby and then having that hold back xmin on master via feedback. Backpatch

2018-04-01 21:59:05 | == PostgreSQL Weekly News - April 01 2018 == (David Fetter)

XID when spilling old transactions to disk, so it would wrap around sooner and print

pgsql-bugs   (152)

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

2018-05-15 19:02:40 | ERROR: subxact logged without previous toplevel record (Euler Taveira)

XID 124557507 to disk 2018-05-15 15:24:05 -03 [31783]: [478-1] ERROR

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   (311)

2018-07-09 23:26:45 | pgsql: Avoid emitting a bogus WAL record when recycling an all-zerobtr (Tom Lane)

XID, which might lead to unnecessary query cancellations on hot standby servers. Per reports from

2018-07-09 23:26:45 | pgsql: Avoid emitting a bogus WAL record when recycling an all-zerobtr (Tom Lane)

XID, which might lead to unnecessary query cancellations on hot standby servers. Per reports from

2018-07-09 23:26:45 | pgsql: Avoid emitting a bogus WAL record when recycling an all-zerobtr (Tom Lane)

XID, which might lead to unnecessary query cancellations on hot standby servers. Per reports from

2018-07-09 23:26:45 | pgsql: Avoid emitting a bogus WAL record when recycling an all-zerobtr (Tom Lane)

XID, which might lead to unnecessary query cancellations on hot standby servers. Per reports from

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   (14)

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

2011-01-19 11:53:40 | Re: [HACKERS] Couple document fixes (Kevin Grittner)

xid | not null relacl | aclitem[] | reloptions | text[] | Indexes: "pg_class_oid_index" UNIQUE, btree (oid) "pg_class

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   (33)

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

2013-02-12 13:01:47 | Re: PostgreSQL XAResource & GlassFish 3.1.2.2 (Bryan Varner)

XID managed by a Transaction Manager. In an JEE container, it's expected that multiple

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