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


Список
Период
Сортировка
2017-01-09 14:14:32 | [GENERAL] checkpoint clarifications needed (Tom DalPozzo)

xid 0:10685; oid 24665; multi 1; offset 0; oldest xid 584 in DB 1; oldest

2016-12-21 14:53:06 | [GENERAL] archive_command called for preallocated/recycled WAL? (marty kulma)

xid 0/450172; oid 37074; multi 1; offset 0; oldest xid 1869 in DB 1; oldest

2016-11-02 16:02:21 | Recover from corrupted database due to failing disk (Gionatan Danti)

xid wraparound limit and, as vacuum fails due to the invalid blocks, I expect a database

pgsql-hackers   (2668)

2017-01-17 21:02:52 | Re: [HACKERS] Too many autovacuum workers spawned during forced auto-vacuum (Robert Haas)

XID; vacuuming the first one doesn't change anything. It would be correct -- I think

2017-01-13 11:38:05 | [HACKERS] Too many autovacuum workers spawned during forced auto-vacuum (Amit Khandekar)

xid wraparound issues. At this stage, when the server is loaded with a lot of DML operations

2017-01-13 10:57:19 | Re: [HACKERS] UNDO and in-place update (Amit Kapila)

xid in back-pointer for undo or only byte-offset will do? -- With Regards, Amit

2017-01-12 15:26:01 | Re: [HACKERS] UNDO and in-place update (Robert Haas)

XID 123456, byte-offset 78901>. (You might get such a pointer from a heap page

pgadmin-hackers   (10)

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

2008-10-20 14:33:21 | Re: [HACKERS] Hot Standby utility and administrator functions ("Robert Haas")

Should these return xid? ...Robert

2008-10-20 03:23:03 | Hot Standby utility and administrator functions (Simon Riggs)

xid() Will throw an ERROR if *not* executed in recovery mode. returns bigint * pg_last

pgadmin-support   (1)

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

2016-11-15 09:49:39 | Re: Postgresql 9.5 committing and log sequence number (Poul Kristensen)

xid shown by select * from pg_last_committed_xact(); repeating select * from pg_last_committed

2016-10-24 06:59:11 | Re: PostgresSQL 9.5 and systemd autorestart but without replication. (Poul Kristensen)

xid | backend_xmin | 2312 I can not figure it out! OS:rhel 7.2 Thanks Poul

2016-05-23 19:46:07 | Re: Canceling a vacuum freeze (Alvaro Herrera)

xid exceeded autovacuum_max_freeze_age) that's running on a = large table, how much

2016-05-23 18:29:45 | Canceling a vacuum freeze (Natalie Wenz)

xid exceeded autovacuum_max_freeze_age) that's running = on a large table, how much

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

2016-11-27 20:07:01 | == PostgreSQL Weekly News - November 27 2016 == (David Fetter)

Xid. We already have a perfectly good interface for returning "the Xid you requested is too old for us to have

2016-08-22 00:41:45 | == PostgreSQL Weekly News - August 21 2016 == (David Fetter)

xid from a bigint extended xid-with-epoch. Oskari Saarenmaa sent in two revisions of a patch

2016-08-07 19:31:24 | == PostgreSQL Weekly News - August 07 2016 == (David Fetter)

XID but no actual changes. Per bug #14279 from Marko Tiikkaja. Patch by Marko based

2016-07-17 22:19:17 | == PostgreSQL Weekly News - July 17 2016 == (David Fetter)

xid and further risks from heap_update(). When heap_update needs to look for a page

pgsql-bugs   (232)

2016-10-07 18:24:33 | Re: BUG #14361: snapshot too old bug? in xmin>=xid transaction, also raise snapshot too old error (Kevin Grittner)

On Fri, Oct 7, 2016 at 10:03 AM, wrote: To recap the above

2016-04-13 06:41:31 | Bus error in pg_logical_slot_get_changes (9.4.7, sparc) (Christoph Berg)

xid= , commit_lsn=27808752, end_lsn= , commit_time=513854161898478) at /home/myon/postgresql-9.4-9.4.7/build/../src/backend/replication/logical/reorderbuffer.c:1355 change = 0x7985f858 save

2016-03-24 05:46:11 | BUG #14042: bug, PostgreSQL not cleanup temp table info after crash. (digoal@126.com)

xid; vauum freeze pg_temp_??.t; and the table not reduce age. select age(relfrozenxid

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)

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

pgsql-committers   (130)

2017-01-19 21:24:47 | [COMMITTERS] pgsql: Fix race condition in reading commit timestamps (Alvaro Herrera)

Xid is not executed until the next checkpoint record. To fix in the primary, simply

2016-12-14 14:35:23 | Re: [COMMITTERS] pgsql: Add support for temporary replication slots (Peter Eisentraut)

xid output from pg_logical_slot_get_changes() is not portable/repeatable, so it should be omitted

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: class org.postgresql.xa.XADataSourceImpl [javac] TxConnection getTxConnection( Xid xid ) [javac] ^ A brief check at Sun seems

pgsql-docs   (26)

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

2016-09-06 04:24:12 | Re: FrozenTransactionId (Egor Rogov)

XID, - FrozenTransactionId, which does not follow the normal XID - comparison rules and is always considered

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

pgsql-interfaces   (20)

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_ag= e =3D 100000000 My pg_clog

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 (=?KOI8-R?B?IuzP19DB3sUg4crEwc3J0iI=?=)

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

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

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

2012-05-07 07:40:02 | Re: 64 bit XID / Wraparound / Streaming Replication (Tom Lane)

Frank Foerster writes: I don't believe anybody is actively thinking about 64-bit

pgsql-odbc   (21)

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

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-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

2008-03-12 11:17:05 | Re: [PERFORM] Very slow (2 tuples/second) sequential scan after bulk insert; speed returns to ~500 ("Heikki Linnakangas")

XID is 2^31-10. Then you start 20 subtransactions. What XIDs will they get? Now how would

2008-03-12 09:57:39 | Re: [PERFORM] Very slow (2 tuples/second) sequential scan after bulk insert; speed returns to ~500 (Tom Lane)

XID wraparound), and it would have problems with a slow transaction generating a sparse set of subtransaction

pgsql-performance   (123)

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

2016-01-04 14:16:51 | Re: Proposal for unlogged tables (Andres Freund)

xid wraparound handling). It probably possible to work around such things, but it's not a line

2015-03-18 09:21:23 | Re: Very slow checkpoints (Steven Jones)

XID age before forced= vacuum=0A= #autovacuum_vacuum_cost_delay =3D 20ms =A0 =A0# default

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 intege= r -- View this message in context: http://postgresql.1045698.n5.nabble.com

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)

xid =3D currval('xadmin_xid_seq'::regclass)) -> Bitmap Index Scan on it_tmp_pk (cost

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

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 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-05 23:21:18 | Archives down? 503 error (Bruce Momjian)

XID: 13756651 Varnish cache server -- Bruce Momjian http://momjian.us EnterpriseDB http://enterprisedb.com + As you are, so once

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=3D0x7f2a1b714798, xmin=3D0x7f2a1b71479c) 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=3D0x7f2a1b714798, xmin=3D0x7f2a1b71479c) at = sinvaladt.c:426 #1 0x00000000006287f4 in pgstat_read_current_status () at pgstat.c