You mean it is restored in session that is running the transaction ?
Depends on what you mean with restored. It first reads the heap page,
sees that it needs an older version and thus reads it from the rollback
segment.
So are whole pages stored in rollback segments or just
An alternative approach is to make charin and text_char map empty
strings to the null character (\0), and conversely make charout and
char_text map the null character to empty strings. charout already
acts that way, in effect, since it has to produce a null-terminated
This way would have
Okay, just bit the bullet, upgraded to v7.1.2, and the problem still
persists:
globalmatch=# vacuum verbose analyze locations;
NOTICE: --Relation locations--
NOTICE: Pages 1395: Changed 0, reaped 0, Empty 0, New 0; Tup 123571: Vac 0, Keep/VTL
0/0, Crash 0, UnUsed 0, MinLen 76, MaxLen 124;
Marc,
The column 'zip' is of type text. As such, indices will not be used except
in the case when the where clause is WHERE zip ~ '^text' for btree
indices.
Gavin
On Tue, 29 May 2001, Marc G. Fournier wrote:
Okay, just bit the bullet, upgraded to v7.1.2, and the problem still
persists:
Gavin Sherry [EMAIL PROTECTED] writes:
The column 'zip' is of type text. As such, indices will not be used except
in the case when the where clause is WHERE zip ~ '^text' for btree
indices.
Uh ... nonsense.
On Tue, 29 May 2001, Marc G. Fournier wrote:
globalmatch=# vacuum verbose analyze
On Tue, 29 May 2001, Tom Lane wrote:
Gavin Sherry [EMAIL PROTECTED] writes:
The column 'zip' is of type text. As such, indices will not be used except
in the case when the where clause is WHERE zip ~ '^text' for btree
indices.
Uh ... nonsense.
Oh good, I was worried there for a sec ...
So are whole pages stored in rollback segments or just
the modified data?
This is implementation dependent. Storing whole pages is
much easy to do, but obviously it's better to store just
modified data.
I am not sure it is necessarily better. Seems to be a tradeoff here.
pros
hello all
I don't know what to do...
the pg_log file is too big..
anyone can help me?
thanks
---(end of broadcast)---
TIP 2: you can get off all lists at once with the unregister command
(send unregister YourEmailAddressHere to [EMAIL
On Mon, May 28, 2001 at 02:37:32PM -0400, Tom Lane wrote:
I wrote:
I propose that both of these operations should return a space character
for an empty input string. This is by analogy to space-padding as you'd
get with char(1). Any objections?
An alternative approach is to make
IBM is trying to find the answer to this but I thought I would throw
this out here to see if anyone can help me. I am compiling a user
defined type on AIX and it fails when I try to use it. The type is
chkpass and it is in the contrib directory. It fails with a core dump
at line 88 in
IBM is trying to find the answer to this but I thought I would throw ...
Tell me your link line, OS and compiler version.
And have you forgotten to include -bI:postgres.imp ?
Bingo! I can't believe that IBM has been wrestling with this for a week.
Part of the reason we are
Larry Rosenman [EMAIL PROTECTED] writes:
I tried to use the unixdate contrib, and got the following:
I think unixdate is suffering from bit-rot. Most or all of what it
does is now part of the mainframe anyway.
Any ideas? (I need SOMETHING that takes a unix timestamp and turns it
to
Seems overwrite smgr has mainly advantages in terms of
speed for operations other than rollback.
... And rollback is required for 5% transactions ...
This obviously depends on application.
Small number of aborted transactions was used to show
useless of UNDO in terms of space
OTOH it is possible to do without rolling back at all as
MySQL folks have shown us ;)
Not with SDB tables which support transactions.
My point was that MySQL was used quite a long time without it
and still quite many useful applications were produced.
And my point was that
Peter Eisentraut [EMAIL PROTECTED] writes:
In general, I don't see a point in accepting a zero byte in character
strings. If you want to store binary data there are binary data types (or
effort could be invested in them).
If we were starting in a green field then I'd think it worthwhile to
15 matches
Mail list logo