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


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

pgsql-general   (524)

2017-03-14 15:55:51 | Re: [GENERAL] Table not cleaning up drom dead tuples (Антон Тарабрин)

2017-03-02 08:43:46 | Re: [GENERAL] column "waiting" does not exist ("Charles Clavadetscher")

xid | xid | backend_xmin | xid | query | text | Regards Charles Regards Johann -- Because experiencing your loyal

2017-02-28 22:55:39 | Re: [GENERAL] Shared WAL archive between master and standby: WALs notalways identical (Sasa Vilic)

xid 0:11617888; oid 25304; multi 1; offset 0; oldest xid 1750 in DB 13322; oldest

2017-02-22 22:05:42 | Re: [GENERAL] NOTIFY command impact (Rob Brucks)

XID being assigned to the transaction (so that the message it sticks into the pg_notify

pgsql-hackers   (2752)

2017-03-23 07:48:22 | Re: [HACKERS] Speed up Clog Access by increasing CLOG buffers (Ashutosh Sharma)

XID being >>> committed matches the one in the PGPROC, and nsubxids matches

2017-03-23 03:25:07 | Re: [HACKERS] [PATCH] Transaction traceability - txid_status(bigint) (Craig Ringer)

xid to bigint is worth it. Probably not. You have to cast xid::text::bigint

2017-03-23 01:40:49 | Re: [HACKERS] [PATCH] Transaction traceability - txid_status(bigint) (Craig Ringer)

xid. For anything else, if you can see the xid in xmin you know it committed

2017-03-22 18:08:55 | Re: [HACKERS] [PATCH] Transaction traceability - txid_status(bigint) (Simon Riggs)

xid, since the user might wait until it is complete and then wait forever. Prefer

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

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

2017-01-01 21:45:21 | [ANNOUNCE] == PostgreSQL Weekly News - January 01 2017 == (David Fetter)

xid can leak semaphore count. Peter Eisentraut sent in a patch to generate fmgr prototypes

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

pgsql-bugs   (235)

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

2017-02-01 07:41:38 | 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

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

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

2017-03-23 18:29:33 | [COMMITTERS] pgsql: Track the oldest XID that can be safely looked up in CLOG. (Robert Haas)

XID that can be safely looked up in CLOG. This provides infrastructure for looking up arbitrary

2017-03-22 16:39:48 | [COMMITTERS] pgsql: Assign AccessExclusiveLocks against subxacts in Hot Standby (Simon Riggs)

xid, which could cause locks to be held much longer than necessary in some cases

2017-03-17 13:18:55 | Re: [COMMITTERS] pgsql: Avoid having vacuum set reltuples to 0 on non-empty relations in (Andrew Gierth)

xid_limits is certainly passing ignoreVacuum=true to Andrew> GetOldestXmin. Answering my own question: vacuum

2017-03-17 12:21:05 | Re: [COMMITTERS] pgsql: Avoid having vacuum set reltuples to 0 on non-empty relations in (Andrew Gierth)

xid_limits is certainly passing ignoreVacuum=true to GetOldestXmin. -- Andrew. -- Sent via pgsql-committers mailing

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

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