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


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

pgsql-general   (533)

2017-08-09 22:26:51 | Re: [GENERAL] Multixact members limit exceeded (Thomas Munro)

xid) to compute the age of a multixact ID. Although they have type xid in pg_class

2017-07-02 03:13:42 | Re: [GENERAL] Re: have trouble understanding xmin and xmax withupdate operations from two different sessions (Jeff Janes)

xid manually. Some testing here showed >that what xmin or xmax is created depends

2017-07-02 01:32:54 | [GENERAL] Re: have trouble understanding xmin and xmax with update operationsfrom two different sessions (rajan)

xid is not incremented when calling it. Yes. But why (ctid(0,4)) in *Session

2017-07-01 17:00:07 | Re: [GENERAL] have trouble understanding xmin and xmax with updateoperations from two different sessions (Adrian Klaver)

xid manually. Some testing here showed that what xmin or xmax is created depends on when

pgsql-hackers   (2852)

2017-08-19 10:04:37 | Re: [HACKERS] recovery_target_time = 'now' is not an error but stillimpractical setting (Piotr Stefaniak)

xid to the latest transaction ID pg_xlogdump could find. You could also try recovery

2017-08-16 01:33:23 | Re: [HACKERS] [PATCH] pageinspect function to decode infomasks ("Moon Insung")

xid = HeapTupleHeaderGetXmin(tuple); if (TransactionIdIsNormal(xid)) { if (TransactionIdPrecedes(xid, cutoff_xid)) { frz->t_infomask |= HEAP

2017-08-15 06:53:48 | Re: [HACKERS] Pluggable storage (Andres Freund)

xid, cmin, itempointer, ctid, heaponly} are each individual functions, that seems pretty painful to maintain

2017-08-10 15:31:39 | Re: [HACKERS] [TRAP: FailedAssertion] causing server to crash (Craig Ringer)

xid limit was advanced before clog truncation. > > I'll be finding time in the next

pgadmin-hackers   (13)

2017-06-12 14:37:16 | Re: [pgadmin-hackers] [pgAdmin4][Patch][RM_ 2477]: New Line text editpop up renders off page (Robert Eckhardt)

xid', 'real'). >> > >> > 3) Remove inline styles from rendered editors

2017-06-12 13:27:59 | Re: [pgadmin-hackers] [pgAdmin4][Patch][RM_ 2477]: New Line text editpop up renders off page (Surinder Kumar)

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

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

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

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

2017-06-05 22:53:29 | [ADMIN] Questions about upgrade standby with rsync (Sergey Burladyan)

xid:0, rmid:0(XLOG), len/tot_len:64/96, info:0, prev:0/11387BB8] checkpoint: redo 0/12000020; tli 1; nextxid

2017-04-08 17:34:48 | Re: [ADMIN] Repeating autovacuum (Ertan Küçükoğlu)

Xid oldest/newest: 0/0 2017-04-08 15:52:34 +03DEBUG: transaction ID wrap limit

2017-04-07 22:35:22 | [ADMIN] Repeating autovacuum (Ertan Küçükoğlu)

Xid oldest/newest: 0/0 DEBUG: transaction ID wrap limit is 2147484183, limited by database with OID 12401 DEBUG

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

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

2017-08-14 01:51:44 | [ANNOUNCE] == PostgreSQL Weekly News - August 14 2017 == (David Fetter)

XID that can be safely looked up in clog *before* truncating CLOG, and the oldest

2017-07-16 18:35:40 | [ANNOUNCE] == PostgreSQL Weekly News - July 16 2017 == (David Fetter)

XID. 4. GetNewTransactionid stores XID 100 to MyPgXact->xid So, GetOldestActiveTransactionId returned XID 101, even

2017-06-18 21:25:38 | [ANNOUNCE] == PostgreSQL Weekly News - June 18 2017 == (David Fetter)

xid assigned. That was used to check that the exporting transaction is still running, which

2017-01-22 23:24:24 | [ANNOUNCE] == PostgreSQL Weekly News - January 22 2017 == (David Fetter)

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

pgsql-bugs   (237)

2017-06-16 19:56:17 | [BUGS] BUG #14710: Function now() and logical replication (konst583@gmail.com)

xid | backend_xmin | query | backend_type | background worker so the value now() = backend_start (logical

2017-05-12 13:42:25 | Re: [BUGS] Crash observed during the start of the Postgres process ("K S, Sandhya (Nokia - IN/Bangalore)")

xid 6252 db 16386 rel 16899                   48: [19825-58f473ff.4d71-48] 2017-04-17 07:51:28.189 GMT < > LOCATION

2017-03-13 00:06:00 | Re: [BUGS] Bug in Physical Replication Slots (at least 9.5)? (Venkata B Nagothi)

xid 0:638; oid 16487; multi 1; offset 0; oldest xid 544 in DB 1; oldest

2017-02-03 03:16:49 | Re: [HACKERS] [BUGS] Bug in Physical Replication Slots (at least9.5)? (Kyotaro HORIGUCHI)

xid, bool last_write); static XLogRecPtr WalSndWaitForWal(XLogRecPtr loc); -static void XLogRead(char *buf, XLogRecPtr

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

2017-08-10 15:25:48 | [COMMITTERS] pgsql: Remove incorrect assertion in clog.c (Robert Haas)

XID that can be safely looked up in clog *before* truncating CLOG, and the oldest

2017-08-06 21:37:30 | [COMMITTERS] pgsql: Fix thinko introduced in 2bef06d516460 et al. (Andres Freund)

xid dangerously much. Reported-By: Antonin Houska Discussion: https://postgr.es/m/32704.1496993134@localhost Backport: 9.4-, where 2bef06d516460

2017-08-06 21:37:29 | [COMMITTERS] pgsql: Fix thinko introduced in 2bef06d516460 et al. (Andres Freund)

xid dangerously much. Reported-By: Antonin Houska Discussion: https://postgr.es/m/32704.1496993134@localhost Backport: 9.4-, where 2bef06d516460

2017-08-06 21:37:27 | [COMMITTERS] pgsql: Fix thinko introduced in 2bef06d516460 et al. (Andres Freund)

xid dangerously much. Reported-By: Antonin Houska Discussion: https://postgr.es/m/32704.1496993134@localhost Backport: 9.4-, where 2bef06d516460

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   (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 ("Ловпаче Айдамир")

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

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

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

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.orgarchives.postgresql.orgpostgresql.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.usmomjian.us EnterpriseDB http://enterprisedb.com

2014-11-06 17:55:28 | www.postgresql.orgwww.postgresql.orgpostgresql.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