was really suggesting that keyword
because that's what we call the feature. It doesn't sound that bad to
me, but if you laughed at it then maybe it's really a bad idea.
--
Alvaro Herrera (alvherre[a]alvh.no-ip.org)
All rings of power are equal,
But some rings of power are more equal than others
Why does the sanity check test start with a VACUUM? Why not a VACUUM
FULL?
--
Alvaro Herrera (alvherre[a]alvh.no-ip.org)
Los románticos son seres que mueren de deseos de vida
---(end of broadcast)---
TIP 3: Have you checked our extensive FAQ
is too high.
* Stop a running VACUUM if the system load is too high.
--
Alvaro Herrera (alvherre[a]alvh.no-ip.org)
La verdad no siempre es bonita, pero el hambre de ella sí
---(end of broadcast)---
TIP 4: Have you searched our list archives
On Thu, Jul 28, 2005 at 11:42:22AM +1000, Gavin Sherry wrote:
On Wed, 27 Jul 2005, Alvaro Herrera wrote:
* Change how we track the need to vacuum
I don't really think the use of row level stats are the best
indicator for a need to vacuum. I wonder if we could keep
working on this?
Also, I don't know if you handled it already, but maybe those programs
should be able to cope with creating roles/users with or without LOGIN.
--
Alvaro Herrera (alvherre[a]alvh.no-ip.org)
Industry suffers from the managerial dogma that for the sake of stability
and continuity
a watchpoint in gdb, I think.
--
Alvaro Herrera (alvherre[a]alvh.no-ip.org)
Investigación es lo que hago cuando no sé lo que estoy haciendo
(Wernher von Braun)
---(end of broadcast)---
TIP 2: Don't 'kill -9' the postmaster
On Thu, Jul 28, 2005 at 01:59:10PM -0400, Tom Lane wrote:
Alvaro Herrera [EMAIL PROTECTED] writes:
I just noticed the createuser and dropuser pages may need
adjustments as well ... are you still working on this?
The programs themselves need adjustment, too :-(. I have a TODO note
to look
/pgopenitems
The main shared dependency patch is applied. I still owe a patch to
implement DROP OWNED and REASSIGN OWNED, to drop or give away
objects owned by a list of roles.
--
Alvaro Herrera (alvherre[a]alvh.no-ip.org)
Crear es tan difícil como ser libre (Elsa Triolet
directory.)
For the edit postgresql.conf part I guess it would be important to
have some settings that would not be changeable via this interface.
--
Alvaro Herrera (alvherre[a]alvh.no-ip.org)
La primera ley de las demostraciones en vivo es: no trate de usar el sistema.
Escriba un guión que no toque
and old; then destroy both and recreate the new,
bigger one. It doesn't strike me as super straightforward.
Are we prepared to rollback to a known-safe value?
--
Alvaro Herrera (alvherre[a]alvh.no-ip.org)
Los dioses no protegen a los insensatos. Éstos reciben protección de
otros insensatos mejor
. Apparently there's a good primer on
relational theory, SQL and PostgreSQL history.
--
Alvaro Herrera (alvherre[a]alvh.no-ip.org)
Officer Krupke, what are we to do?
Gee, officer Krupke, Krup you! (West Side Story, Gee, Officer Krupke)
---(end of broadcast
.
--
Alvaro Herrera (alvherre[a]alvh.no-ip.org)
Jason Tesser: You might not have understood me or I am not understanding you.
Paul Thomas: It feels like we're 2 people divided by a common language...
---(end of broadcast)---
TIP 1: if posting/reading through
in that there's no way to know what tuples
are locked without scanning the whole table.
--
Alvaro Herrera (alvherre[a]alvh.no-ip.org)
Those who use electric razors are infidels destined to burn in hell while
we drink from rivers of beer, download free vids and mingle with naked
well shaved babes. (http
.
--
Alvaro Herrera (alvherre[a]alvh.no-ip.org)
Endurecerse, pero jamás perder la ternura (E. Guevara)
---(end of broadcast)---
TIP 4: Have you searched our list archives?
http://archives.postgresql.org
On Mon, Aug 08, 2005 at 06:02:37PM -0400, Bruce Momjian wrote:
Alvaro Herrera wrote:
On Mon, Aug 08, 2005 at 05:38:59PM -0400, Bruce Momjian wrote:
Marko Kreen wrote:
On Mon, Aug 08, 2005 at 03:56:39PM -0400, Bruce Momjian wrote:
Currently, here are the options available
is off, then no fsync is done to the data files on
checkpoint either. (See mdsync() on src/backend/storage/smgr/md.c)
--
Alvaro Herrera (alvherre[a]alvh.no-ip.org)
A male gynecologist is like an auto mechanic who never owned a car.
(Carrie Snow)
---(end of broadcast
invoke
commit() or fsync() depending on whether you have writethrough enabled.
pg_fsync() on storage/file/fd.c
--
Alvaro Herrera (alvherre[a]alvh.no-ip.org)
FOO MANE PADME HUM
---(end of broadcast)---
TIP 9: In versions below 8.0, the planner
().
--
Alvaro Herrera (alvherre[a]alvh.no-ip.org)
¿Que diferencia tiene para los muertos, los huérfanos, y aquellos que han
perdido su hogar, si la loca destrucción ha sido realizada bajo el nombre
del totalitarismo o del santo nombre de la libertad y la democracia? (Gandhi
the
performance of two runs with similar shared_buffer settings? With
O_DIRECT, I understand from this manpage that the OS is going to do
little or no page caching, so shared_buffers should be increased to
account for this fact.
Am I missing something?
--
Alvaro Herrera (alvherre[a]alvh.no-ip.org)
Hay
), a new MultiXactId is generated. The
caller is expected to check whether the member transactions are still
running.
--
Alvaro Herrera (alvherre[a]alvh.no-ip.org)
El que vive para el futuro es un iluso, y el que vive para el pasado,
un imbécil (Luis Adler, Los tripulantes de la noche
; then transaction D locked the tuple again, you would see a
new MultiXactId comprising transactions C and D.
--
Alvaro Herrera (alvherre[a]alvh.no-ip.org)
Thou shalt not follow the NULL pointer, for chaos and madness await
thee at its end. (2nd Commandment for C programmers)
---(end
] ] [, ... ]
)
Right?
--
Alvaro Herrera (alvherre[a]alvh.no-ip.org)
---(end of broadcast)---
TIP 2: Don't 'kill -9' the postmaster
.
Is anyone opposed to this idea? Further, is anyone opposed to the
addition as a whole? I'm already a month and a half late with this
part of the shdep patch, so if people think it's better to ship this
release without it, so be it. (Of course I don't like that.)
--
Alvaro Herrera (alvherre[a]alvh.no
On Fri, Aug 12, 2005 at 09:53:59PM -0400, Bruce Momjian wrote:
Can I have a TODO item for this?
Something like ease dropping roles which have dependencies spilt over
several databases ... ?
Alvaro Herrera wrote:
On Sat, Jul 30, 2005 at 12:19:41AM -0400, Bruce Momjian wrote:
I have
On Sat, Aug 13, 2005 at 10:09:35AM -0400, Tom Lane wrote:
Alvaro Herrera [EMAIL PROTECTED] writes:
I'm working on the promised DROP OWNED patch, and just noticed that it
needs modifications to the Grant/Revoke machinery that are too invasive
to consider for 8.1; the problem
weapon?
--
Alvaro Herrera (alvherre[a]alvh.no-ip.org)
Hay dos momentos en la vida de un hombre en los que no debería
especular: cuando puede permitírselo y cuando no puede (Mark Twain)
---(end of broadcast)---
TIP 9: In versions below 8.0, the planner
», Línea: 336)
--
Alvaro Herrera (alvherre[a]alvh.no-ip.org)
[PostgreSQL] is a great group; in my opinion it is THE best open source
development communities in existence anywhere.(Lamar Owen)
---(end of broadcast)---
TIP 1: if posting
a number of changes since there are several
places that follow t_ctid chains.
I wonder whether this should be refactored so all of them use a single
piece of code.
--
Alvaro Herrera (alvherre[a]alvh.no-ip.org)
Cómo ponemos nuestros dedos en la arcilla del otro. Eso es la amistad; jugar
al
to be sure that the question remains
* meaningful for long enough for the answer to be used ...
*
* Only main transaction Ids are considered. This function is mainly
* useful for determining what backend owns a lock.
*/
int
BackendXidGetPid(TransactionId xid)
{
--
Alvaro Herrera
, but it still
locks the relation until transaction end.
--
Alvaro Herrera (alvherre[a]alvh.no-ip.org)
Ni aun el genio muy grande llegaría muy lejos
si tuviera que sacarlo todo de su propio interior (Goethe)
Index: schemacmds.c
===
RCS
On Fri, Aug 19, 2005 at 01:11:54PM -0400, Tom Lane wrote:
Alvaro Herrera [EMAIL PROTECTED] writes:
I just noticed that AlterSchemaOwner (and others like AlterFunctionOwner
-- I haven't checked anything else yet) does not release the lock on
pg_namespace (resp. AlterFunctionOwner) after it's
On Fri, Aug 19, 2005 at 05:47:11PM -0400, Tom Lane wrote:
Alvaro Herrera [EMAIL PROTECTED] writes:
On Fri, Aug 19, 2005 at 01:11:54PM -0400, Tom Lane wrote:
The code's a bit inconsistent about whether it releases non-exclusive
locks on system catalogs or leaves them till transaction end. I
On Sat, Aug 20, 2005 at 12:23:38AM -0400, Tom Lane wrote:
Alvaro Herrera [EMAIL PROTECTED] writes:
The drop way probably allows slightly more concurrency, but given that
people should seldom be taking exclusionary locks on system catalogs,
I'm not sure this is really an issue.
Hmm
LGPL: they do not want to
have to rewrite it all, which they would were they to choose a license
like BSD. (Personally I think this is folly -- someone else will have
to rewrite it again with a BSD license sometime, and then the value of
their work would be decreased.)
--
Alvaro Herrera (alvherre
.
For example, gcc version 4 generates LOTS of compiler warnings. They
need clearing up.
Yeah, please do.
--
Alvaro Herrera (alvherre[a]alvh.no-ip.org)
Es filósofo el que disfruta con los enigmas (G. Coli)
---(end of broadcast)---
TIP 6: explain
be also nice to have M-# to work well -- currently it inserts a
#, which works in bash but is obviously wrong in psql.
--
Alvaro Herrera (alvherre[a]alvh.no-ip.org)
Los románticos son seres que mueren de deseos de vida
---(end of broadcast)---
TIP 1
wanted features?
Has PostgreSQL started slowing down in getting new features, and
concentrating mostly on performance issues?
--
Alvaro Herrera (alvherre[a]alvh.no-ip.org)
A male gynecologist is like an auto mechanic who never owned a car.
(Carrie Snow)
---(end of broadcast
. :)
The archives would fill with junk. From skimming other projects'
archives, IMHO that is very undesirable.
--
Alvaro Herrera (alvherre[a]alvh.no-ip.org)
The important things in the world are problems with society that we don't
understand at all. The machines will become more complicated
*log(shared_buffers))) seems to behave nicely.
That'd mean 3*4 = 12 buffers when shared_buffers is below 100; and 8*4 =
32 buffers when shared_buffers is above 1.
--
Alvaro Herrera (alvherre[a]alvh.no-ip.org)
La Primavera ha venido. Nadie sabe como ha sido (A. Machado
handling.
I'll submit a fix after dinner.
Thanks for the report.
--
Alvaro Herrera alvherre[]alvh.no-ip.org Architect, www.EnterpriseDB.com
La felicidad no es mañana. La felicidad es ahora
---(end of broadcast)---
TIP 6: explain analyze
user-defined aggregates?
--
Alvaro Herrera alvherre[]alvh.no-ip.org Architect, www.EnterpriseDB.com
Lo esencial es invisible para los ojos (A. de Saint Exúpery)
---(end of broadcast)---
TIP 4: Have you searched our list archives
on the 8.1 code I'm looking at.
--
Alvaro Herrera alvherre[]alvh.no-ip.org Architect, www.EnterpriseDB.com
Si quieres ser creativo, aprende el arte de perder el tiempo
---(end of broadcast)---
TIP 6: explain analyze is your friend
. Is there a setting that didn't make it into the
conf file?
It works for me; care to submit an test case?
--
Alvaro Herrera -- Valdivia, Chile Architect, www.EnterpriseDB.com
We are who we choose to be, sang the goldfinch
when the sun is high (Sandman)
---(end
, or describe
the anonymous record in the SELECT statement. Of course, in PL/pgSQL
you need a variable to do the FOR ... LOOP.
Your example works fine for me. What exactly were you expecting?
--
Alvaro Herrera -- Valdivia, Chile Architect, www.EnterpriseDB.com
Escucha y olvidarás; ve y
VACUUM once in a while (every billion-and-so), but this will hopefully
disappear in 8.2 too, leaving you effectively with the option of never
vacuuming a table.
--
Alvaro Herrera -- Valdivia, Chile Architect, www.EnterpriseDB.com
You liked Linux a lot when he was just the gawky kid from
, and then attach
the file to a dummy table. (Then again, you can do it today, using a
Xmin of FrozenTransactionId. I wonder why the Bizgres people isn't
advocating a tool to do that. It is very hard to do with user-defined
types, but for BI/DW you mostly don't need those, do you?)
--
Alvaro Herrera
On Thu, Sep 01, 2005 at 04:21:58AM -, Andrew - Supernews wrote:
On 2005-09-01, Alvaro Herrera [EMAIL PROTECTED] wrote:
On Thu, Sep 01, 2005 at 01:57:02AM +0100, Simon Riggs wrote:
If you're using autovacuum then the problem is already taken care of.
autovacuum will respond only
header -- in fact, there's no relation to that at
all.
--
Alvaro Herrera -- Valdivia, Chile Architect, www.EnterpriseDB.com
FOO MANE PADME HUM
---(end of broadcast)---
TIP 5: don't forget to increase your free space map settings
On Thu, Sep 01, 2005 at 11:08:36AM -0400, Tom Lane wrote:
Alvaro Herrera [EMAIL PROTECTED] writes:
What I'm saying is that you can write a heap file, on which the tuples
would all have xmin=FrozenTransactionId, xmax=Invalid, and the
corresponding bits set in the infomask. This ensures
, and got me to help with that -- in the meantime, we have to
keep the 7.1.3 server running.
--
Alvaro Herrera -- Valdivia, Chile Architect, www.EnterpriseDB.com
La naturaleza, tan fr?gil, tan expuesta a la muerte... y tan viva
Index: configure
number.
--
Alvaro Herrera -- Valdivia, Chile Architect, www.EnterpriseDB.com
Cuando miro a alguien, m?s me atrae c?mo cambia que qui?n es (J. Binoche)
---(end of broadcast)---
TIP 6: explain analyze is your friend
, you can plug the file in and all tuples will be
valid.
So, bulk loading by file generation? So the idea is that you would generate
a properly formatted PostgreSQL table file, and then in one transaction
create the table and attach it?
Exactly.
--
Alvaro Herrera -- Valdivia, Chile
remember to update the docs.
--
Alvaro Herrera -- Valdivia, Chile Architect, www.EnterpriseDB.com
Thou shalt check the array bounds of all strings (indeed, all arrays), for
surely where thou typest foo someone someday shall type
supercalifragilisticexpialidocious (5th Commandment for C
On Thu, Sep 01, 2005 at 04:34:09PM +0100, Simon Riggs wrote:
On Wed, 2005-08-31 at 22:25 -0400, Alvaro Herrera wrote:
I was thinking that when the tuple
needs to be obsoleted it would need to grow to accomodate the Xmax, but
you are not actually proposing to remove that, so it seems
with the xxid datatype Slony-I adds; maybe it's
missing some operator or property.
I wonder why we don't support more operators on Xid, so these things are
avoided? Right now we only have =, AFAIR.
--
Alvaro Herrera -- Valdivia, Chile Architect, www.EnterpriseDB.com
Hay quien adquiere
features work. May I suggest you at least get it working and try to
port your functions to it?
(Disclaimer: while I work for EDB, I haven't had any relationship to the
Oracle-PL/SQL layer yet, nor have I been involved at all in their
commercial offering.)
--
Alvaro Herrera -- Valdivia, Chile
On Fri, Sep 02, 2005 at 11:03:24AM -0400, Tom Lane wrote:
Alvaro Herrera [EMAIL PROTECTED] writes:
I wonder why we don't support more operators on Xid, so these things are
avoided? Right now we only have =, AFAIR.
I once started to make a btree opclass for XID, and stopped when
insert tuples into a page that the other transaction is using. (Not
sure if this can happen in reality.) Else we risk both inserting a
tuple in the same page, and on recovery finding out that somebody else
used the tuple slot.
--
Alvaro Herrera -- Valdivia, Chile Architect
On Fri, Sep 02, 2005 at 04:27:59PM -0400, Tom Lane wrote:
Alvaro Herrera [EMAIL PROTECTED] writes:
Contrariwise, it doesn't really matter (I think) if there are WAL-logged
records already in the table and COPY is adding more that aren't logged.
Only if the page is locked in a fashion
partitioning sometime soon, I don't think
the restriction is a problem. You may have to load a whole partition
again, which may be faster than using logged COPY to an already-filled
partition. The point is, it's not the whole table, just a partition.
--
Alvaro Herrera -- Valdivia, Chile
there.
--
Alvaro Herrera -- Valdivia, Chile Architect, www.EnterpriseDB.com
Having your biases confirmed independently is how scientific progress is
made, and hence made our great society what it is today (Mary Gardiner)
---(end of broadcast)---
TIP
this will be a much
worse problem if we allow a table that's being COPY'ed to remain after a
crash.
--
Alvaro Herrera -- Valdivia, Chile Architect, www.EnterpriseDB.com
Oh, oh, las chicas galacianas, lo harán por las perlas,
¡Y las de Arrakis por el agua! Pero si buscas damas
Que se consuman como
Does compatibile mean our combined work is still BSD licensed?
No, because of clause 2.2 (c) of the APSL, at least. (Must distribute
source code if modified.)
--
Alvaro Herrera -- Valdivia, Chile Architect, www.EnterpriseDB.com
Dios hizo a Adán, pero fue Eva quien lo hizo hombre
requires random
access, so we'd need some form of tree or hash. Unfornunately I never
got beyond brainstorming :-(
BTW, is there anything else that'd need spilling to disk during long
transactions?
Yes, the queue of pending deferred triggers.
--
Alvaro Herrera -- Valdivia, Chile
in vain..
Did you change all the other files in src/backend/nodes? You need to
change not only copyfuncs.c, but equalfuncs, outfuncs and readfuncs as
well.
--
Alvaro Herrera -- Valdivia, Chile Architect, www.EnterpriseDB.com
El miedo atento y previsor es la madre de la seguridad (E
-level tree nodes are likely to contain page
boundary keys copied from data that vanished some time ago from the
underlying table.
So there would be no problem if a REINDEX was forced every two billion
transactions, right? (A bit less, I think.)
--
Alvaro Herrera -- Valdivia, Chile
certificates is gone)?
Did you try using a hardlink instead of a symlink?
--
Alvaro Herrera -- Valdivia, Chile Architect, www.EnterpriseDB.com
Ninguna manada de bestias tiene una voz tan horrible como la humana (Orual)
---(end of broadcast
On Mon, Sep 05, 2005 at 03:27:01PM -0400, Alvaro Herrera wrote:
On Mon, Sep 05, 2005 at 09:03:06PM +0200, Simon de Hartog wrote:
I have added all the users these applications run as to a group called
ssl. Permissions on the private key are owned by root, group ssl,
protection rw-r
.
--
Alvaro Herrera -- Valdivia, Chile Architect, www.EnterpriseDB.com
Y una voz del caos me habló y me dijo
Sonríe y sé feliz, podría ser peor.
Y sonreí. Y fui feliz.
Y fue peor.
---(end of broadcast)---
TIP 6: explain analyze is your friend
applicable.
--
Alvaro Herrera -- Valdivia, Chile Architect, www.EnterpriseDB.com
Pensar que el espectro que vemos es ilusorio no lo despoja de espanto,
sólo le suma el nuevo terror de la locura (Perelandra, CSLewis)
---(end of broadcast)---
TIP
be stored in a single disk block!! I imagine the
development of decompressors was boycotted by SAN vendors and the like.
--
Alvaro Herrera -- Valdivia, Chile Architect, www.EnterpriseDB.com
Si un desconocido se acerca y te regala un CD de Ubuntu ...
Eso es
elsewhere. I don't see how is that a win; it's
actually worse because you have to do two lookups. (And actually you
have just enlarged the storage requirements because you need to store
the vis_id twice.)
--
Alvaro Herrera -- Valdivia, Chile Architect, www.EnterpriseDB.com
La realidad se
in local memory. However,
to eliminate both you'd have to keep a list of all tuples you have
created or obsoleted, with the cmin and cmax of each. This seems like
an awful amount of memory.
--
Alvaro Herrera -- Valdivia, Chile Architect, www.EnterpriseDB.com
I can't go to a restaurant
should set a threshold in order to
be able to decide ...
--
Alvaro Herrera -- Valdivia, Chile Architect, www.EnterpriseDB.com
Use it up, wear it out, make it do, or do without
---(end of broadcast)---
TIP 6: explain analyze is your friend
| grep LDFLA
LDFLAGS = -Wl,-rpath,/pg/install/00orig/lib
LDFLAGS_SL =
--
Alvaro Herrera -- Valdivia, Chile Architect, www.EnterpriseDB.com
¿Que diferencia tiene para los muertos, los huérfanos, y aquellos que han
perdido su hogar, si la loca destrucción ha sido realizada bajo el nombre
do fsync modified
files on checkpoint, and rewrite them completely from WAL images after
that. But I thought I'd mention it.
--
Alvaro Herrera -- Valdivia, Chile Architect, www.EnterpriseDB.com
Just treat us the way you want to be treated + some extra allowance
for ignorance
the freeze limit.
The problem is, this seems so awfully simple that I fear I am missing
something ... Otherwise, does this sound like a plan?
--
Alvaro Herrera -- Valdivia, Chile Architect, www.EnterpriseDB.com
The easiest way to resolve [trivial code guidelines disputes] is to fire
one
On Wed, Sep 14, 2005 at 11:30:52PM -0400, Tom Lane wrote:
Alvaro Herrera [EMAIL PROTECTED] writes:
In fact this seems pretty easy to do. Add a field to pg_class, tell
VACUUM to update it using the determined freezeLimit, and that's it.
I think that it'd be worth fixing things so
section, the backup
section? Does it merit a mention on the release notes?
Suggestions welcome.
--
Alvaro Herrera -- Valdivia, Chile Architect, www.EnterpriseDB.com
¿Que diferencia tiene para los muertos, los huérfanos, y aquellos que han
perdido su hogar, si la loca destrucción ha sido
for update_hint_bits.
So, the only callers of both has already acquired appropiate locks at
the relation level -- nobody is going to be modifying the blocks while
they proceed. So why bother locking the pages at all? Is there a
reason or is this an historical accident?
--
Alvaro Herrera -- Valdivia, Chile
with the wording though -- is there no way to tell
the difference?
--
Alvaro Herrera -- Valdivia, Chile Architect, www.EnterpriseDB.com
No single strategy is always right (Unless the boss says so)
(Larry Wall)
---(end
on the relation.
On 9/16/05, Alvaro Herrera [EMAIL PROTECTED] wrote:
Hackers,
I'm reading the vacuum code and I just noticed that the routines
move_plain_tuple and move_chain_tuple expect the dest and source blocks
to be locked, and unlock them at exit. The only caller of both
On Fri, Sep 16, 2005 at 11:50:21PM -0700, Simon Riggs wrote:
Alvaro Herrera wrote
The only caller of both is
repair_frag, whose only caller in turn is full_vacuum_rel.
...bgwriter still needs to access blocks. The WAL system relies on the
locking behaviour for recoverability, see
On Thu, Sep 22, 2005 at 10:36:41AM -0400, Alvaro Herrera wrote:
On Fri, Sep 16, 2005 at 11:50:21PM -0700, Simon Riggs wrote:
Alvaro Herrera wrote
The only caller of both is
repair_frag, whose only caller in turn is full_vacuum_rel.
...bgwriter still needs to access blocks. The WAL
to optimize the
query at all, which may be OK as a first cut but for a real-world
implementation you really need it to do.
--
Alvaro Herrerahttp://www.advogato.org/person/alvherre
Oh, great altar of passive entertainment, bestow upon me thy discordant images
at such speed
for
hierarchical queries (ala Oracle-style)... For the PostgreSQL community,
I'll work on adding the ANSI/ISO WITH standard syntax just as SQL Server/DB2
have.
Maybe the recipes could be reworked to use the connect_by() function,
wherever possible ...
--
Alvaro Herrerahttp
Hey,
While you guys are hacking at the LO code, it would be nice to consider
the suggestions outlined here:
http://archives.postgresql.org/pgsql-bugs/2004-07/msg00143.php
--
Alvaro Herrera http://www.amazon.com/gp/registry/CTMLCN8V17R4
Y una voz del caos me habló y me dijo
and
determine if something came out of kernel buffers or not, but AFAIK
that's all vaporware right now...
I don't remember the discussion, but it certainly hasn't been
implemented.
--
Alvaro Herrerahttp://www.PlanetPostgreSQL.org
Escucha y olvidarás; ve y
generating the Makefile:
sed: file conftest.s1 line 33: unterminated `s' command
I bet this is the multiline gcc --version. You could try wrapping gcc
with a script that returns a single line --version. (Or maybe using an
older gcc release.)
--
Alvaro Herrera
On Mon, Sep 26, 2005 at 05:41:24PM +0200, Gaetano Mendola wrote:
Joshua D. Drake wrote:
Autovacuum is integrated into the backend for 8.1
Can I set the autovacuum parameter per table instead of per
engine ?
Yes.
--
Alvaro Herrera Architect, http
a Python dependency for
building Postgres? I doubt it will be less portable than what we have
now, but it will be extra burden for the users.
Scons certainly seems nice anyway ...
--
Alvaro Herrerahttp://www.advogato.org/person/alvherre
El destino baraja y nosotros jugamos
you are re-titling the docs, maybe the sections on that chapter
could be titled Benefits of Write-Ahead Log instead of Benefits of
WAL, etc.
--
Alvaro Herrera http://www.amazon.com/gp/registry/DXLWNGRJD34
La realidad se compone de muchos sueños, todos ellos diferentes,
pero en
about WAL in a general manner, while the
latter two are about our implementation. I also wouldn't expand the
acronym in a title.
--
Alvaro Herrera Valdivia, Chile ICBM: S 39º 49' 17.7, W 73º 14' 26.8
Thou shalt study thy libraries and strive not to reinvent them without
cause, that thy code
and relfilenode. The
calculate_total_relation_size() function gets a relfilenode parameter
and then tries to call relation_open() with it. This is wrong.
I'll submit/commit a patch fixing this, later today. Thanks for the
test case.
--
Alvaro Herrera Valdivia, Chile ICBM: S 39º 49' 17.7, W 73º
the code include the size of the index of the TOAST
table in pg_total_relation_size().
--
Alvaro Herrera Architect, http://www.EnterpriseDB.com
En las profundidades de nuestro inconsciente hay una obsesiva necesidad
de un universo lógico y coherente. Pero el universo real
autovacuum perchance? If
so, does the number of processes correspond approximately to the
autovacuum_naptime?
--
Alvaro Herrerahttp://www.advogato.org/person/alvherre
La espina, desde que nace, ya pincha (Proverbio africano)
---(end of broadcast
. They are restarted by the postmaster if not found to be
running.
The weird thing is that the postmaster _should_ call wait() for them if
it detects that they died (when receiving a SIGCHLD signal AFAIR). If
it doesn't, maybe it indicates there's a problem with the signal
handling on Win32.
--
Alvaro Herrera
be made to clobber any existing file owned by whoever runs it.)
--
Alvaro Herrerahttp://www.PlanetPostgreSQL.org
Entristecido, Wutra (canción de Las Barreras)
echa a Freyr a rodar
y a nosotros al mar
---(end of broadcast
with a replacement on Windows? Are there simple
btree/hash table functions on Windows, with a similar API?
--
Alvaro Herrera Architect, http://www.EnterpriseDB.com
La web junta la gente porque no importa que clase de mutante sexual seas,
tienes millones de posibles parejas
the packagers of
Linux distributions to do the same.
ISTM it's trivial to test whether the file exists, and useful to
activate the feature if available.
--
Alvaro Herrerahttp://www.PlanetPostgreSQL.org
In fact, the basic problem with Perl 5's subroutines is that they're
501 - 600 of 9686 matches
Mail list logo
