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


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

pgsql-general   (543)

2017-10-10 20:40:07 | [GENERAL] core system is getting unresponsive because over 300 cpu load (pinker)

xid_age, mxid_age(relminmxid) AS mxid_age, least( (SELECT setting::int FROM pg_settings

2017-10-10 20:23:52 | Re: [GENERAL] startup process stuck in recovery (Tom Lane)

xid 134024 db 423347 rel 524106 WARNING: out of shared memory CONTEXT: xlog redo at 0/C10A97E0

2017-09-18 08:00:48 | Re: [GENERAL] BDR, near xid wraparound, a lot of files in pg_subtrans directory (milist ujang)

Hi Craig, So, is it safe to drop those list from this query output? select

pgsql-hackers   (2909)

2017-10-19 20:44:01 | Re: [HACKERS] [COMMITTERS] pgsql: Fix traversal of half-frozen update chains (Peter Geoghegan)

XID cutoff. That's why after 20b65522 there was no problem with sequential scans. There

2017-10-19 14:21:12 | Re: [HACKERS] [COMMITTERS] pgsql: Fix traversal of half-frozen update chains (Robert Haas)

xid managing to be a new enough transaction ID for this to happen in the first

2017-10-18 19:45:36 | [HACKERS] Re: heap/SLRU verification, relfrozenxid cut-off, and freeze-the-deadbug (Was: amcheck (B-Tree (Peter Geoghegan)

XID-cutoff for safely interrogating CLOG: I guess it will be possible to assess a HOT chain

2017-10-18 10:20:50 | Re: [HACKERS] Re: Is anything preventing us from allowing write toforeign tables from standby? (Wolfgang Wilhelm)

xid when we're working with foreign > tables since we don't do any local

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

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

2017-08-22 21:26:39 | [ADMIN] Vacuuming: To Freeze or Not To Freeze? (Don Seiler)

XID & freezing part of my journey but it sounds like it might be a good

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

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

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

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

pgsql-bugs   (252)

2017-10-19 23:14:24 | [BUGS] BUG #14863: wrong reltuples statistics after vacuum without analyze (psuderevsky@gmail.com)

xid older than tuples xmax's. database=# select pg_class.relnamepg_class.relnameclass.relname, to_char

2017-10-11 17:00:18 | Re: [BUGS] BUG #14830: Missed NOTIFications, PostgreSQL 9.1.24 (Tom Lane)

xid, Snapshot snapshot); extern void HeapTupleSetHintBits(HeapTupleHeader tuple, Buffer buffer, uint16 infomask, TransactionId xid); -- Sent

2017-10-10 18:07:36 | Re: [BUGS] BUG #14830: Missed NOTIFications, PostgreSQL 9.1.24 (Tom Lane)

xid) || ! XidInMVCCSnapshot(qe->xid, snapshot)) { /* * The source transaction is still in progress, so we can't *************** asyncQueueProcessPageEntries

2017-10-10 14:09:29 | Re: [BUGS] BUG #14830: Missed NOTIFications, PostgreSQL 9.1.24 (Marko Tiikkaja)

xid, RecentXmin)) >       return false; Hmm ... I suppose it's possible that that happens if the listening

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

2017-10-11 18:29:05 | [COMMITTERS] pgsql: Fix low-probability loss of NOTIFY messages due to XIDwraparoun (Tom Lane)

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

2017-10-11 18:29:05 | [COMMITTERS] pgsql: Fix low-probability loss of NOTIFY messages due to XIDwraparoun (Tom Lane)

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

2017-10-11 18:29:05 | [COMMITTERS] pgsql: Fix low-probability loss of NOTIFY messages due to XIDwraparoun (Tom Lane)

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

2017-10-11 18:29:05 | [COMMITTERS] pgsql: Fix low-probability loss of NOTIFY messages due to XIDwraparoun (Tom Lane)

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

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