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


Список
Период
Сортировка

pgsql-general   (553)

2017-12-15 03:20:13 | Hot standby failing with PANIC: WAL contains references to invalidpages (TAKATSUKA Haruka)

xid 210320 2017-12-11 18:14:16 JST [5094]: [15-1] db=,user=,state

2017-11-24 11:26:56 | Re: [GENERAL] BDR, near xid wraparound, a lot of files in pg_subtrans directory (milist ujang)

Hi craig, I have a bunch of orphaned replication identifier. How to cleanup those orpaned

2017-11-13 05:25:10 | [GENERAL] PostgreSQL walsender process doesn't exist after "pg_ctl stop -mfast" (y39chen)

xid 0:464; oid 16473; multi 1; offset 0; oldest xid 418 in DB 1; oldest

2017-10-20 17:39:26 | [GENERAL] Replication stops under certain circumstances (Kim Rose Carlsen)

xid      | backend_xmin     | query            | -[ RECORD 2 ]----+-------------------------------- datid            | 1 datname          | template1 pid              | 11949 usesysid         | 16388 usename

pgsql-hackers   (3195)

2017-12-11 08:54:24 | Re: [HACKERS] WAL logging problem in 9.4.3? (Kyotaro HORIGUCHI)

xid, XLogRecPtr recptr; /* Caller should not call me on a non-WAL-logged relation */ - Assert

2017-12-08 11:59:42 | Re: [HACKERS] Proposal for CSN based snapshots (Alexander Korotkov)

xid (and correspondingly have to do a lot of csnlog lookups)? See [1] slide 18. This

2017-12-08 02:36:33 | Re: Usage of epoch in txid_current (Amit Kapila)

xid value in CLOG_ZEROPAGE record while extending clog and that too we can do only

2017-12-07 19:45:53 | Re: [HACKERS] logical decoding of two-phase transactions (Peter Eisentraut)

xid)); 626 if (!TransactionIdIsValid(prstate->new_prune_xid) || 627 TransactionIdPrecedes(xid, prstate->new_prune_xid)) 628 prstate

pgadmin-hackers   (12)

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.objtype.obj build\temp.win32-2.7\Release\psycopg\adapter_asis.objadapter_asis.objasis.obj build\temp.win32-2.7

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

2008-10-21 01:03:17 | Re: [GENERAL] [HACKERS] Hot Standby utility and administrator functions (Simon Riggs)

xid difference between master and slave". In that context, xid plus epoch is appropriate. There

pgadmin-support   (3)

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

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

2016-11-10 09:03:51 | Re: pgadmin server-status does not display (Dave Page)

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

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

2017-11-15 10:06:05 | Re: [ADMIN] Vacuum not removing dead tuples (Laurenz Albe)

xid, prepared FROM pg_prepared_xacts; 3) Lagging replication slots: SELECT xmin, slot_name, active

2017-10-31 03:35:04 | Re: [ADMIN] Postgresql Upgrade from 9.3 to 9.4 failing (rammohan ganapavarapu)

XID", " latest checkpoint next OID", " latest checkpoint next MultiXactId", " > latest checkpoint next MultiXactOffset", " first

2017-10-30 18:16:19 | [ADMIN] Postgresql Upgrade from 9.3 to 9.4 failing (rammohan ganapavarapu)

XID", " latest checkpoint next OID", " latest checkpoint next MultiXactId", " latest checkpoint next MultiXactOffset", " first WAL segment

2017-09-11 22:39:17 | Re: [ADMIN] Fixing OID directory names after a fsck (Tom Lane)

XID counter, before stuff is likely to look sane. If you don't have pg_control

pgsql-advocacy   (6)

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://developers.slashdot.org

2005-02-08 22:59:14 | Re: Wrap-around XID's (Gavin Sherry)

On Tue, 8 Feb 2005, Alvaro Herrera wrote: I don't have any information on

2005-02-08 21:35:38 | Re: Wrap-around XID's (Alvaro Herrera)

On Wed, Feb 09, 2005 at 10:34:01AM +1100, Gavin Sherry wrote: Gavin, This

2005-02-08 20:34:23 | Re: Wrap-around XID's (Gavin Sherry)

XID wraparound and that was because they were attempting to load 1 TB a day and had no time

pgsql-announce   (97)

2017-10-22 18:38:31 | [ANNOUNCE] pg_filedump 10.0 released (Christoph Berg)

xid * xml * ~ -- ignores all attributes left in a tuple For instance, pg_attribute can be decoded

2017-10-15 17:35:16 | [ANNOUNCE] == PostgreSQL Weekly News - October 15 2017 == (David Fetter)

XID wraparound. Up to now async.c has used TransactionIdIsInProgress() to detect whether a notify message

2017-10-01 19:57:40 | [ANNOUNCE] == PostgreSQL Weekly News - October 01 2017 == (David Fetter)

XID behind, and if no HOT prune happens to clean it up before the containing

2017-09-23 21:10:05 | [ANNOUNCE] pg_dirtyread 1.2 released (Christoph Berg)

xid, xmax xid, cmin cid, cmax cid, dead boolean, oid oid, bar bigint, baz text

pgsql-bugs   (257)

2017-12-11 22:28:59 | #14702 followup (dennis.noordsij@alumni.helsinki.fi)

xid 0:4886727; oid 2067430; multi 3972; offset 11826; oldest xid 548 in DB 1; oldest

2017-12-04 15:01:22 | Re: BUG #14940: Duplicated records inspite of primary key and uniqueconstraint (Сергей А. Фролов)

xid -----+----------+-------+-------+-------+---------+----------+---------+-----------  0/0 |        0 |     0 |   320 |   416 |    8192 |     8192 | 4 |         0 (1 строка)  lp | lp_off | lp_flags

2017-10-23 16:38:27 | Re: [BUGS] Connections hang indefinitely while taking a LWLockTranchebuffer_content lock. (Chris Hanks)

xid, backend_xmin, backend_start, xact_start, query_start, state_change, query FROM pg_stat

2017-10-22 18:23:32 | [BUGS] Connections hang indefinitely while taking a LWLockTranchebuffer_content lock. (Chris Hanks)

xid, backend_xmin, backend_start, xact_start, query_start, state_change, query FROM pg_stat

pgsql-cluster-hackers   (8)

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-05-11 09:20:51 | Re: GDQ iimplementation (Marko Kreen)

XID" means actually "own transaction" here? And it's not committed yet? That's seems

2010-05-11 08:05:38 | Re: GDQ iimplementation (Jan Wieck)

XID in progress at the time of switching, waits until the lowest XID in progress

2010-05-07 11:31:44 | Re: Clustering features for upcoming developer meeting -- please claim yours! (Josh Berkus)

XID feed on the wiki page? -- -- Josh Berkus PostgreSQL Experts Inc. http://www.pgexperts.comwww.pgexperts.com

pgsql-committers   (295)

2017-12-15 02:28:56 | pgsql: Fix pruning of locked and updated tuples. (Andres Freund)

xid in a multixact with both key share lockers and an updater) was below the cutoff

2017-12-15 02:28:53 | pgsql: Fix pruning of locked and updated tuples. (Andres Freund)

xid in a multixact with both key share lockers and an updater) was below the cutoff

2017-12-15 02:28:51 | pgsql: Fix pruning of locked and updated tuples. (Andres Freund)

xid in a multixact with both key share lockers and an updater) was below the cutoff

2017-12-15 02:28:49 | pgsql: Fix pruning of locked and updated tuples. (Andres Freund)

xid in a multixact with both key share lockers and an updater) was below the cutoff

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.Xidjavax.transaction.xa.Xidtransaction.xa.Xidxa.Xid; [javac

pgsql-docs   (28)

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-12-04 11:46:02 | Re: [HACKERS] max_worker_processes on the standby (Fujii Masao)

xid and timestamp information of the last committed transaction disappeared by crash recovery. Isn't this

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

2015-10-02 00:06:09 | Re: max_worker_processes on the standby (Fujii Masao)

xid) from generate_series(1750, 1800) num The steps to reproduce the problem is 1. Set up replication

pgsql-interfaces   (25)

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

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-14 13:29:15 | Re: PostgreSQL XAResource & GlassFish 3.1.2.2 (Bryan Varner)

XID and have been suspended by the TM, at some indeterminate point in time, at least

2013-02-14 11:59:50 | Re: PostgreSQL XAResource & GlassFish 3.1.2.2 (Florent Guillaume)

XID. Florent On Wed, Feb 13, 2013 at 11:20 PM, Bryan Varner wrote

2013-02-13 19:20:22 | Re: PostgreSQL XAResource & GlassFish 3.1.2.2 (Bryan Varner)

XID) then the situation you've described is completely accurate, and no different than the situation

pgsql-novice   (18)

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

2012-11-11 13:39:33 | Re: Restoring data from TABLESPACE files (Tom Lane)

XID counter of the new installation is nowhere near what it likely was in the old one. So even

pgsql-odbc   (23)

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

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-07-04 06:14:59 | Re: page macros cleanup (ver 04) (Zdenek Kotala)

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

2008-07-04 04:00:47 | Re: page macros cleanup (ver 03) (Zdenek Kotala)

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

pgsql-performance   (135)

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-04-05 23:54:00 | Re: Table not using tsvector gin index and performance much worsethan when it uses it (rverghese)

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

pgsql-sql   (33)

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://postgresql.1045698.n5.nabble.com/could-not-access-status-of-transaction-pg-multixact-issue-tp5822248p5822376.html

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-15 01:25:50 | Re: Insane behaviour in 8.3.3 (Achilleas Mantzios)

2012-06-15 01:24:08 | Re: Insane behaviour in 8.3.3 (Robert Edwards)

xid=currval('xadmin_xid_seq'::text) or even: SELECT id from items_tmp WHERE id=1261319 AND xid=currval

pgsql-students   (2)

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

2007-08-29 11:52:00 | Re: Final status of projects? ("Florian G. Pflug")

XID too (We cannot generate XIDs on the standby, they might conflict with those generated

pgsql-www   (10)

2016-06-28 16:36:22 | Re: Error 503 related to Varnish cache server ("David G. Johnston")

XID: 460806 > > Varnish cache server did this happen today or over a longer

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

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

2016-01-26 08:13:20 | Re: archives.postgresql.orgarchives.postgresql.orgpostgresql.org problem (Oleg Bartunov)

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

2016-01-26 07:26:11 | Re: archives.postgresql.orgarchives.postgresql.orgpostgresql.org problem (Magnus Hagander)

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

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