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
> > > 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
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 ma
> > > 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
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 PROT
> > > 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 tradeof
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 time
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 ~ '^' for btree
> > indices.
>
> Uh ... nonsense.
Oh good, I was worried there for a s
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 ~ '^' for btree
> indices.
Uh ... nonsense.
> On Tue, 29 May 2001, Marc G. Fournier wrote:
>> globalmatch=# vacuum verbose analyz
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 ~ '^' 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:
>
>
> > > 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 a
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; Re-
> 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 ha
> 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 i
> > > > > 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 rollba
15 matches
Mail list logo
