On Mon, 2004-02-09 at 16:53, Josh Berkus wrote:
Jenny,
For 19, we moved the common conditions out of the big ORs, for 20, we
added distinct. We can change the query back if the optimizer can
handle it now.
Well, we want to test if it can.
Replace the file 19.sql under datagen/pgsql
its own TupleTable and has access to the t_infomask (set to
HEAP_MARKED_FOR_UPDATE for this tuple) in the HeapTupleHeader for the
HeapTuple in question , since HeapTuples are stored in TupleTable.
thanks
From: Tom Lane [EMAIL PROTECTED]
To: Jenny - [EMAIL PROTECTED]
CC: [EMAIL PROTECTED]
Subject
HI,
I found out that TupleTable stores per-tuple information(it stores
HeapTupleData) and that also there are multiple TupleTables in the db at a
time.Based on what are diffrent TupleTables created?
thank you
Jenny
From: Larry Douzie [EMAIL PROTECTED]
To: Tom Lane [EMAIL PROTECTED]
CC: [EMAIL
TupleTables are just temporary data structures to hold transiently
created tuples during execution of a query. There's usually one for
each plan node.
whats a 'plan node'?
From: Tom Lane [EMAIL PROTECTED]
To: Jenny - [EMAIL PROTECTED]
CC: [EMAIL PROTECTED]
Subject: Re: [HACKERS] row level lock
is endtill the end of transaction
Thanks
From: Tom Lane [EMAIL PROTECTED]
To: Jenny - [EMAIL PROTECTED]
CC: [EMAIL PROTECTED]
Subject: Re: [HACKERS] row level lock and table level locks Date: Mon, 08
Sep 2003 12:49:51 -0400
Jenny - [EMAIL PROTECTED] writes:
I found out that TupleTable stores per
A row lock is represented by storing the locking transaction's ID in
xmax and setting the HEAP_MARKED_FOR_UPDATE infomask bit. The bit is
needed to distinguish this from the case where the transaction is
deleting the tuple.
where is 'HEAP_MARKED_FOR_UPDATE infomask bit' found ?
thanks
From: Tom
On Thu, Sep 04, 2003 at 08:56:31AM -0700, Jenny - wrote:
I am working on a project that involves displaying locking information
about each lock taken, whether it be a row level or table leve llock.
When dealing with struct LOCK (src/include/storage) i have noticed that
postgreSQL creates
objects. i was using the LockData(defined
in src/include/storage/lock.h ) datastructures for this, but if all 3 locks
are put into the same LOCK struct even in LOCKDATA then can someone help me
as to how else i can accomplish what i intent on doing?
thank you very much
Jenny
the offnum of LOCKTAG I gather indicates which row (tuple) is being locked
in a row level locking. But when I lock 2 diffrent rows of a table, offset
for both is 0. and also offset is 0 if i take a table lock on the same
table. (blkno is the same for all three locks)..shouldnt the OffsetNumber
I understand that ObjID of LOCKtag recognizes each individual row locked by
a row level lock. BUt i have noticed that if i lock 2 different rows of the
same table they have the same blkno. is this deduction ok?
thanks
jenny
_
Get
...
then how would we recognize each individual row locked?
From: Tom Lane [EMAIL PROTECTED]
To: Jenny - [EMAIL PROTECTED]
CC: [EMAIL PROTECTED], [EMAIL PROTECTED]
Subject: Re: [GENERAL] identifying each individual tuple locked Date: Tue,
02 Sep 2003 14:08:44 -0400
Jenny - [EMAIL PROTECTED] writes
hi ,
iam trying to run gdb on postgresql to stack-trace the functions that get
called when a lock is taken.
gdb *program*
what do i pass in place of program inorder to run gdb on postgresqql
thanks
jenny
_
Get MSN 8 and help protect
if table and page are locked in src/backend/storage/lmgr/lmgr.c by
LockRelation() and LockPage respectively, in which file and by which
function is a row locked?
thanks
Jenny
From: Jenny - [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Subject: Re: [HACKERS] table-level and row-level locks.
Date: Sun
How do we acquire row level locks in postgresql and is there any feild in
LOCK or PROCLOCK datastructes (src/include/storage/lock.h) that tells us the
lock is row-level?
thanks
_
Enter for your chance to IM with Bon Jovi, Seal, Bow
the tupleId is still invalid. Finally if
this is a tuple level lock (we currently never do this) then both
the blockId and tupleId are set to valid specifications.
is blockId same as tag.objId.blkno? what field in LOCK.tag is tupleId?
thanks
jenny
the tupleId is still invalid. Finally if
this is a tuple level lock (we currently never do this) then both
the blockId and tupleId are set to valid specifications.
is blockId same as tag.objId.blkno? what field in LOCK.tag is tupleId?
thanks
jenny
A row lock is represented by storing the locking transaction's ID in
xmax and setting the HEAP_MARKED_FOR_UPDATE infomask bit.
Where is 'xmax' found? is it at code level or on disk?
thanks
Jenny
From: Tom Lane [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
CC: [EMAIL PROTECTED]
Subject: Re: [HACKERS
in LOCK.tag is tupleId?
thanks
jenny
_
bGet MSN 8/b and help protect your children with advanced parental
controls. http://join.msn.com/?page=features/parental
---(end of broadcast
From: Tom Lane [EMAIL PROTECTED]
To: Jenny - [EMAIL PROTECTED]
Subject: Re: [HACKERS] this is in plain text (row level locks) Date: Sat,
02 Aug 2003 23:28:30 -0400
if row-level locks are not recorded in proclock or any other shared
memory
datastructuers, then why does lockmode (array
hi, does anyone know what session level locks mean in postgresql..i've heard
of table-level locks and row level locks but not session level
thanks
Jenny
_
The new MSN 8: advanced junk mail protection and 2 months FREE*
http
in LOCK.tag is tupleId?
thanks
jenny
_
MSN 8 with e-mail virus protection service: 2 months FREE*
http://join.msn.com/?page=features/virus
---(end of broadcast)---
TIP 9: the planner
in LOCK.tag is tupleId?
thanks
jenny
_
The new MSN 8: smart spam protection and 2 months FREE*
http://join.msn.com/?page=features/junkmail
---(end of broadcast)---
TIP 8: explain
in LOCK.tag is tupleId?
thanks
jenny
_
Protect your PC - get McAfee.com VirusScan Online
http://clinic.mcafee.com/clinic/ibuy/campaign.asp?cid=3963
---(end of broadcast)---
TIP 6
in LOCK.tag is tupleId?
thanks
jenny
_
STOP MORE SPAM with the new MSN 8 and get 2 months FREE*
http://join.msn.com/?page=features/junkmail
---(end of broadcast)---
TIP 1: subscribe
currently can
acquire tuplelevel(row level) locks in postgresql?
Thank you
Jenny
_
Protect your PC - get McAfee.com VirusScan Online
http://clinic.mcafee.com/clinic/ibuy/campaign.asp?cid=3963
---(end
in postgresql and i also have
to display that granularity(table level, page level, row level)on the locks
acquired by these transactions on objects.Which part of postgresql code
gives this information.?
thanks
Jenny
_
MSN 8 with e
currently can
acquire tuplelevel(row level) locks in postgresql?
Thank you
Jenny
_
Protect your PC - get McAfee.com VirusScan Online
http://clinic.mcafee.com/clinic/ibuy/campaign.asp?cid=3963
---(end
currently can
acquire tuplelevel(row level) locks in postgresql?
Thank you
Jenny
_
The new MSN 8: smart spam protection and 2 months FREE*
http://join.msn.com/?page=features/junkmail
---(end of broadcast
currently can
acquire tuplelevel(row level) locks in postgresql?
Thank you
Jenny
_
The new MSN 8: smart spam protection and 2 months FREE*
http://join.msn.com/?page=features/junkmail
---(end of broadcast
Iam trying to acquire rowlevel locks in postgresql. I try doing this:
'select * from students where name='Larry' for update;
But by looking at the holding array of proclock , I've noticed that by doing this only
AccessShareLock gets acquired which is a table level lock.
How do I acquire
Protect your PC - Click here for McAfee.com VirusScan Online
rowlevelock and what fields of Lock or Proclock
datastructures indicate it.
Thanks
Jenny
_
Protect your PC - get McAfee.com VirusScan Online
http://clinic.mcafee.com/clinic/ibuy/campaign.asp?cid=3963
---(end
for its associate LOCK. But how if the
PROCLOCK has already been granted a lock and is waiting for another lock on
the same object( LOCK), how do figure that out?
2)Is tuple level locks the same as row level locks?
Thanks!!
Jenny
Iam trying to acquire rowlevel locks in postgresql. I try doing this:
'select * from students where name='Larry' for update;
But by looking at the holding array of proclock , I've noticed that by doing this only
AccessShareLock gets acquired which is a table level lock.
How do I acquire
hi,
what fields in LOCK datastructures can i use to uniquely identify each row of a table? if each row is seperately locked that is.
thanks
jennyAdd photos to your e-mail with MSN 8. Get 2 months FREE*.
hi,
1)If the same PROCLOCKhas some already-granted locks and
be waiting for more, how do we know?
I currently use the holding array of PROCLOCKto figure out what lockmodes a transaction(process) has been granted on LOCK,and if holdings sum comes to 0 that means this PROCLOCK is waiting for
Iam trying to acquire rowlevel locks in postgresql. I try doing this:
'select * from students where name='Larry' for update;
But by looking at the holding array of proclock , I've noticed that by doing this only
AccessShareLock gets acquired which is a table level lock.
How do I acquire
Does anyone know what purpose MAKE_PTR ( defined in shmem.h) servers?
thanks
jennyAdd photos to your messages with MSN 8. Get 2 months FREE*.
How do we acquire row level locks and is there a way to detect them from the any of lock data structures (like Lock, ProcLock, PGPROCK, and LockData)?
thanks
jennyThe new MSN 8: smart spam protection and 2 months FREE*
Iam trying to acquire rowlevel locks in postgresql. I try doing this:
'select * from students where name='Larry' for update;
But by looking at the holding array of proclock , I've noticed that by doing this only
AccessShareLock gets acquired which is a table level lock.
How do I acquire
hi,
1)If the same PROCLOCKhas some already-granted locks and
be waiting for more, how do we know?
I currently use the holding array of PROCLOCKto figure out what lockmodes a transaction(process) has been granted on LOCK,and if holdings sum comes to 0 that means this PROCLOCK is waiting for
Iam trying to acquire rowlevel locks in postgresql. I try doing this:
'select * from students where name='Larry' for update;
But by looking at the holding array of proclock , I've noticed that by doing this only
AccessShareLock gets acquired which is a table level lock.
How do I acquire
associate LOCK. But howif the PROCLOCK has already been granted a lock and is waiting for another lock onthe sameobject( LOCK), how dofigure that out?
2)Is tuple level locks the same as row level locks?
Thanks!!
Jenny
MSN 8 helps ELIMINATE E-MAIL VIRUSES. Get 2 months FREE*.
hi,
Iam working on project that deals with analyzing the locking mechanism in postgresql.
I started a transaction in postgresql with 'begin work;' and noticed that even though no locks have been taken yet, there still exists data in LockData datastructures that indicates that the transaction i
44 matches
Mail list logo
