Andrew Dunstan wrote:
In the course of looking into Larry's buildfarm woes, I found that
Unixware needs this patch on HEAD to build correctly
Thanks -- I already applied an equivalent fix to HEAD.
-Neil
---(end of broadcast)---
TIP 6: Have you s
Bruce Momjian 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 commit. I am attac
Bruce Momjian 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 plan was exec
Tom Lane wrote:
> Bruce Momjian 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 i
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:
> 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/testversio
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
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 pgcry
Simon Riggs wrote:
> Yes, dead on. Thank you for this elegant summary. The main idea was
> originally Hannu Krosing's, I believe, with suggestion from Tom to
> enhance the partial index machinery to this end.
>
> So a query such as
>
> select * from pm where dkey = 25000
>
> will hav
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]
Patch applied. Thanks.
---
Marko Kreen wrote:
> On Sat, Jul 02, 2005 at 10:33:05PM -0400, Bruce Momjian wrote:
> > Patch applied. Thanks.
> > ---
> >
Russell Smith wrote:
> On Sun, 3 Jul 2005 03:51 pm, Tom Lane wrote:
> > Bruce Momjian 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 recover the
Tom Lane wrote:
> Bruce Momjian 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
If fsync is off
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.
h
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 r
On Sat, 2005-07-02 at 15:56 -0400, Bruce Momjian wrote:
> Seems you have managed to combine inheritance, check constraints, and
> partial index into table partitioning. It is nice it requires no new
> syntax. Here is an example from your tests:
>
> DROP TABLE pm cascade;
> CREA
On Sat, 2005-07-02 at 19:05 -0400, Tom Lane wrote:
> Alvaro Herrera <[EMAIL PROTECTED]> writes:
> > On Sat, Jul 02, 2005 at 03:56:48PM -0400, Bruce Momjian wrote:
> >> I am surprised no one else has commented on it, which I think means your
> >> code is ready for the queue. Do you want to adjust i
* Stephen Frost ([EMAIL PROTECTED]) wrote:
> * Tom Lane ([EMAIL PROTECTED]) wrote:
> > Stephen Frost <[EMAIL PROTECTED]> writes:
> > > Tom, if you're watching, are you working on this? I can probably spend
> > > some time today on it, if that'd be helpful.
> >
> > I am not; I was hoping you'd dea
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
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
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
---
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 (si
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 = op
On 7/3/05, Andreas Pflug <[EMAIL PROTECTED]> wrote:
> > Yup, attached. Per our earlier conversation, pg_dbfile_size() now
> > returns the size of a table or index, and pg_relation_size() returns the
> > total size of a relation and all associated indexes and toast tables
> > etc.
>
> pg_relation_s
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
I
25 matches
Mail list logo