Hola,
lei en el grupo sobre este enlace de los libros de postgress que se venden.
Parecen buenos, buscare mas informacion sobre ellos.Muchas gracias.
http://www.postgresql.org/docs/books/
Saludos,
http://gjortiz.blogspot.com";>Jen
'UPDATE is waiting
...' on the list. I killed them all. I backuped current database and DROP the
database, restore to the backup file I just made.
Don't really know why this happened, but thankfully now, everything's normal.
Thank you, guys.
should I do? It's like there's a falsely pointed index here.
Any help would be very much appreciated.
Regards,
Jenny Tania
__
Yahoo! DSL Something to write home about.
Just $16.99/mo. or less.
dsl.yahoo.com
---
On Thu, 2004-02-05 at 22:52, Martijn van Oosterhout wrote:
> On Fri, Feb 06, 2004 at 01:11:24AM -0500, Tom Lane wrote:
> > Jenny Zhang <[EMAIL PROTECTED]> writes:
> > > ERROR: end-of-copy marker corrupt
> > > CONTEXT: COPY author, line 49: "49\aoD{\BA
Oops, I named the var name the same as the column name. Changing it to
something else solved the problem.
Thanks,
Jenny
On Tue, 2003-12-16 at 15:54, Stephan Szabo wrote:
> On Tue, 16 Dec 2003, Jenny Zhang wrote:
>
> > I have stored procedure written in pl/pgsql which takes abou
on shopping_cart (cost=0.00..5.01
rows=1 width=144) (actual time=0.22..0.37 rows=1 loops=1)
Index Cond: (sc_id = 260706::numeric)
Total runtime: 1.87 msec
(3 rows)
Is it true that using pl/pgsql increases the overhead that much?
TIA,
Jenny
--
Jenny Zhang
Open Source Development Lab
12725
array
>
> Variables :
> -
>
> a alias for $1
> b _varchar
>
> Usage :
> -
>
> b[1] = a[1];
> b[2] = a[2];
>
> return b;
>
> Is it possible.
>
> TIA,
--
Jenny Zhang
Open Source Development Lab
12725 SW Millikan Way, Suite 400
Beaverto
need more info.
TIA,
Jenny
--
Jenny Zhang
Open Source Development Lab
12725 SW Millikan Way, Suite 400
Beaverton, OR 97005
(503)626-2455 ext 31
---(end of broadcast)---
TIP 7: don't forget to increase your free space map settings
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
> postgr
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?
If they happen to be stored in the same block, they'd have the same blkno
...
then
> 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?
If they happen to be stored in the same block, they'd have the same blkno
...
then
> 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?
If they happen to be stored in the same block, they'd have the same blkno
the same blkno
...
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 20
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
e 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. "
what field in LOCK.tag is tupleId?
thanks
jenny
_
hi ,
coudl some one tell me how to acquire row-level and page level locks in
postgresql.
iam aware that table level locks can be acquired by the command:
"lock table *tablename* in *locktype* mode;
thanks
_
Enter for your chance to I
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
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
I did this twice (say run_8 and run_9). I found that while the pg_class
are the same for run_8 and run_9, the pg_statistic output are
different. I posted the query, the execution plan, pg_class and
pg_statistic output at:
http://www.osdl.org/archive/jenny/
The difference in pg_statistic
/power_query9.txt
My test leads me to the following questions:
What are the factors which determine the execution plan and cost?
Does PostgreSQL check the system resource dynamically?
If Inserts and Updates happened but vacuuming is not executed, dose the
execution plan change?
Thanks,
--
Jenny Zhang
be interesting to
> see..:-)
>
>
>
Let me know if you have any suggestions about how to improve the test
kit (parameters, reported information, etc.), or how to make it more
useful to PG community.
Thanks,
--
Jenny Zhang
Open Source Development Lab Inc
12725 SW Millikan Way
Suite
23 matches
Mail list logo
