> > 1) To deal with partial/inconsisitent write to the data file at
crash
> > recovery, we need full page writes at the first modification to
pages
> > after each checkpoint. It consumes much of WAL space.
>
> We need to find a way around this someday. Other DBs don't
> do this; it may be be
Tom Lane írta:
Andrew Dunstan <[EMAIL PROTECTED]> writes:
Tom Lane wrote:
So I think attaching a precedence to the GENERATED keyword is dangerous.
Especially when we have a good workaround which would just require use
of () around certain postfix-operator expressions.
Here is an updated version of LDC patch (V4.1).
In this release, checkpoints finishes quickly if there is a few dirty pages
in the buffer pool following the suggestion from Heikki. Thanks.
If the last write phase was finished more quickly than the configuration,
the next nap phase is also shorten
ITAGAKI Takahiro wrote:
Here is an updated version of LDC patch (V4.1).
In this release, checkpoints finishes quickly if there is a few dirty pages
in the buffer pool following the suggestion from Heikki. Thanks.
Excellent, thanks! I was just looking at the results from my test runs
with versi
On Wed, Apr 25, 2007 at 10:00:16AM +0200, Zeugswetter Andreas ADI SD wrote:
>
> > > 1) To deal with partial/inconsisitent write to the data file at
> crash
> > > recovery, we need full page writes at the first modification to
> pages
> > > after each checkpoint. It consumes much of WAL space.
>
The MSVC installer doesn't install the headers in the same directory
structure as the Mingw build. This causes other apps (such as Slony) to
fail their configure tests.
The attached patch fixes this.
Regards, Dave
Index: Install.pm
==
The attached patch installs libpgport.lib under MSVC, and corrects a
typo in a message.
Regards, Dave
Index: Install.pm
===
RCS file: /projects/cvsroot/pgsql/src/tools/msvc/Install.pm,v
retrieving revision 1.12
diff -c -r1.12 Instal
hello,
i am working with bitmap index.have gone through the code of "ondisk
bitmap implementation".
can any one help me out with the preliminary code for bitmap index
implementation.
Thanks,
Sangeetha.K.S.
Andreas,
> Writing to a different area was considered in pg, but there were more
> negative issues than positive.
> So imho pg_compresslog is the correct path forward. The current
> discussion is only about whether we want a more complex pg_compresslog
> and no change to current WAL, or an increas
On Wed, Apr 25, 2007 at 02:57:41PM +0100, Dave Page wrote:
> The MSVC installer doesn't install the headers in the same directory
> structure as the Mingw build. This causes other apps (such as Slony) to
> fail their configure tests.
>
> The attached patch fixes this.
Applied, thanks.
FWIW, I
On Wed, Apr 25, 2007 at 03:35:55PM +0100, Dave Page wrote:
> The attached patch installs libpgport.lib under MSVC, and corrects a
> typo in a message.
Applied, thanks.
//Magnus
---(end of broadcast)---
TIP 9: In versions below 8.0, the planner wi
Magnus Hagander wrote:
On Wed, Apr 25, 2007 at 02:57:41PM +0100, Dave Page wrote:
The MSVC installer doesn't install the headers in the same directory
structure as the Mingw build. This causes other apps (such as Slony) to
fail their configure tests.
The attached patch fixes this.
Applied,
Dave Page wrote:
Magnus Hagander wrote:
On Wed, Apr 25, 2007 at 02:57:41PM +0100, Dave Page wrote:
The MSVC installer doesn't install the headers in the same directory
structure as the Mingw build. This causes other apps (such as Slony)
to fail their configure tests.
The attached patch fixes
Andrew Dunstan wrote:
Dave Page wrote:
Magnus Hagander wrote:
On Wed, Apr 25, 2007 at 02:57:41PM +0100, Dave Page wrote:
The MSVC installer doesn't install the headers in the same directory
structure as the Mingw build. This causes other apps (such as Slony)
to fail their configure tests.
T
Dave Page <[EMAIL PROTECTED]> writes:
> And we really should make VC++ install in the same locations as mingw by
> default anyway.
I think you guys may be misinterpreting what's happening: this behavior
is not platform-sensitive, it is path-sensitive. In particular, the
configure script will int
Tom Lane wrote:
> Dave Page <[EMAIL PROTECTED]> writes:
>> And we really should make VC++ install in the same locations as mingw by
>> default anyway.
>
> I think you guys may be misinterpreting what's happening: this behavior
> is not platform-sensitive, it is path-sensitive. In particular, the
> --- Original Message ---
> From: Magnus Hagander <[EMAIL PROTECTED]>
> To: Tom Lane <[EMAIL PROTECTED]>
> Sent: 25/04/07, 22:31:20
> Subject: Re: [PATCHES] Fix for MSVC header installation
>
> Yup. I had no idea it did that :-) It certainly explains the difference.
No, nor I, but it m
Josh Berkus <[EMAIL PROTECTED]> writes:
> Andreas,
>> So imho pg_compresslog is the correct path forward. The current
>> discussion is only about whether we want a more complex pg_compresslog
>> and no change to current WAL, or an increased WAL size for a less
>> complex implementation.
>> Both wou
Hi,
Zeugswetter Andreas ADI SD wrote:
I don't insist the name and the default of the GUC parameter.
I'm afraid wal_fullpage_optimization = on (default) makes
some confusion because the default behavior becomes a bit
different on WAL itself.
Seems my wal_fullpage_optimization is not a good n
I wrote:
> I found that autovacuum launcher does not launch any workers in HEAD.
The attached autovacuum-fix.patch could fix the problem. I changed
to use 'greater or equal' instead of 'greater' at the decision of
next autovacuum target.
The point was in the resolution of timer; There is a platfo
"Tom Lane" <[EMAIL PROTECTED]> writes:
> Bruce Momjian <[EMAIL PROTECTED]> writes:
>> I did some performance testing of the patch, and the results were good.
>> I did this:
>
>> test=> CREATE TABLE test (x INTEGER);
>> test=> INSERT INTO test SELECT * FROM generate_series(1, 100);
Updated patch against cvs update in case it makes applying easier.
One minor change:
. Added #include in tuplesort.h to pull in UINT_MAX
(thanks to dpage for noticing this is necessary on OSX)
sort-limit-v8.patch.gz
Description: Binary data
--
Gregory Stark
EnterpriseDB htt
22 matches
Mail list logo
