Bruce Momjian wrote:
Andreas Pflug wrote:
Dave Page wrote:
-Original Message-
From: Bruce Momjian [mailto:[EMAIL PROTECTED]
Sent: 02 July 2005 21:30
To: Bruce Momjian
Cc: Dave Page; PostgreSQL-patches; PostgreSQL-development
Subject: Re: [PATCHES] Dbsize backend integration
On Sat, Jul 02, 2005 at 10:33:05PM -0400, Bruce Momjian wrote:
Patch applied. Thanks.
---
Michael Fuhr wrote:
This patch allows contrib/pgcrypto to build with OpenSSL 0.9.8
(currently in beta) when cryptolib = openssl.
Here's my current patch for ALTER OBJECT SET SCHEMA: the attached patch
file implements
schema move for FUNCTION, SEQUENCE, TYPE, DOMAIN and TABLE with all
improvements discussed on -hackers recently. Altering OPERATOR, OPERATOR
CLASS, AGGREGATE and CONVERSION are currently not implemented
On E, 2005-05-23 at 11:42 -0400, Tom Lane wrote:
Hannu Krosing [EMAIL PROTECTED] writes:
I can't think of any other cases where it could matter, as at least the
work done inside vacuum_rel() itself seema non-rollbackable.
VACUUM FULL's tuple-moving is definitely roll-back-able, so it might
Hannu Krosing [EMAIL PROTECTED] writes:
Ok, this is a new version of the vacuum patch with the following changes
following some suggestions in this thread.
The more I look at this, the uglier it looks ... and I still haven't
seen any convincing demonstration that it *works*, ie doesn't have
bad
Dawid Kuroczko [EMAIL PROTECTED] writes:
Oh, I think pg_dbfile_size is best so far.
I think it's by far the ugliest suggestion yet :-(
Andreas's suggestion of having just one function with a bool parameter
might be a workable compromise.
regards, tom lane
Stephen Frost wrote:
This should almost certainly be a pg_database_ownercheck() call instead.
Right there wasn't pg_database_ownercheck at the time I was writing it,
fixed
The rest needs to be updated for roles, but looks like it should be
pretty easy to do. Much of it just needs to be
Hi,
Sorry for the delay. I'm too busy the last days. Based in the
discussions [1], here is a patch that translate the reindexdb shell
script to a C program. Like the other scripts, this is a wrapper for
REINDEX. Docs are include but need some improvement.
Hope that it could be included in 8.1.
Tom Lane wrote:
Bruce Momjian pgman@candle.pha.pa.us writes:
The following patch disables WAL backup pages when fsync is off.
This is a good idea why?
There is no need to write backup pages if fsync is off. Our TODO has:
* Turn off after-change writes if fsync is disabled
Russell Smith wrote:
On Sun, 3 Jul 2005 03:51 pm, Tom Lane wrote:
Bruce Momjian pgman@candle.pha.pa.us writes:
The following patch disables WAL backup pages when fsync is off.
This is a good idea why?
If it is, why do we write wal at all if fsync is off?
Good question. WAL is to
Patch applied. Thanks.
---
Marko Kreen wrote:
On Sat, Jul 02, 2005 at 10:33:05PM -0400, Bruce Momjian wrote:
Patch applied. Thanks.
---
Bruce Momjian wrote:
Patch applied. Thanks.
Should either or both of these patches be applied to back branches?
-Neil
---(end of broadcast)---
TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]
On Mon, Jul 04, 2005 at 12:22:03PM +1000, Neil Conway wrote:
Should either or both of these patches be applied to back branches?
Considering that OpenSSL 0.9.8 is supposed to be final very soon[1],
probably much sooner than PostgreSQL 8.1, some people will probably
install it and have pgcrypto
On Mon, Jul 04, 2005 at 01:08:05AM +0200, Petr Jelinek wrote:
Stephen Frost wrote:
New version which works with roles is attached (diffed against cvs),
everything else is mostly same.
I also had to readd roleid to flatfiles because I need it in
InitProcess() function.
I was wondering if
Tom Lane wrote:
CVS tip fails with
./configure --with-openssl \
--with-includes=/usr/local/ssl/include --with-libs=/usr/local/ssl/lib
...
make[3]: Entering directory `/home/postgres/pgsql/src/interfaces/libpq'
...
/usr/ccs/bin/ld +h libpq.sl.4 -b +b /home/postgres/testversion/lib
This patch disables page writes to WAL when fsync is off, because with
no fsync guarantee, the page write recovery isn't useful.
This also adds a full_page_writes GUC to turn off page writes to WAL.
Some people might not want full_page_writes, but still might want fsync.
--
Bruce Momjian
Tom Lane wrote:
Bruce Momjian pgman@candle.pha.pa.us writes:
Tom Lane wrote:
It appears that somebody has changed things so that the -L switches
appear after the -l switches (ie, too late). I'm too tired to
investigate now, but my money is on Autoconf 2.59 being the problem ...
I
Bruce Momjian pgman@candle.pha.pa.us writes:
Simon Riggs wrote:
Oh, why would someone want to set enable_constraint_exclusion to false?
The included functionality performs the exclusion at plan time. If a
query was prepared for later execution, it *could* return the wrong
answer when the
Bruce Momjian pgman@candle.pha.pa.us writes:
Tom Lane wrote:
It appears that somebody has changed things so that the -L switches
appear after the -l switches (ie, too late). I'm too tired to
investigate now, but my money is on Autoconf 2.59 being the problem ...
I wonder if it was this
19 matches
Mail list logo