"Pavan Deolasee" <[EMAIL PROTECTED]> writes:
> When I looked at the code, it occurred to me that possibly we are
> OK with just taking shared lock on the procarray. That means that
> some other transaction can concurrently set its serializable snapshot
> while we are scanning the procarray. But tha
On 4/1/07, Tom Lane <[EMAIL PROTECTED]> wrote:
Good point. I'm envisioning a procarray.c function along the
lines of
bool TransactionHasSnapshot(xid)
which returns true if the xid is currently listed in PGPROC
and has a nonzero xmin. CIC's cleanup wait loop would check
this and ignore
Ühel kenal päeval, T, 2007-04-10 kell 18:17, kirjutas Joshua D. Drake:
> > In terms of idle time for gzip and other command to archive WAL offline,
> > no difference in the environment was given other than the command to
> > archive. My guess is because the user time is very large in gzip, it
> >
> In terms of idle time for gzip and other command to archive WAL offline,
> no difference in the environment was given other than the command to
> archive. My guess is because the user time is very large in gzip, it
> has more chance for scheduler to give resource to other processes. In
> the
Hi,
In the case below, we run DBT-2 benchmark for one hour to get the
measure. Checkpoint occured three times (checkpoint interval was 20min).
For more information, when checkpoint interval is one hour, the amount
of the archived log size was as follows:
cp: 3.1GB
gzip: 1.
I wrote:
> I fooled around with this idea and came up with the attached patch.
> It seems to do what's intended but could do with more eyeballs and
> testing before committing. Comments please?
Earlier I said that I didn't want to back-patch this change, but on
looking at the CVS history I'm reco
"Pavel Stehule" <[EMAIL PROTECTED]> writes:
> this patch allows using SQL2003 syntax for set returning functions. It is
> based on using new type of argmode - PROARGMODE_TABLE.
I've been looking at this, and my feeling is that we should drop the
PROARGMODE_TABLE business and just define RETURNS T
I wrote:
> Actually, on second look I think the key idea here is Takahiro-san's
> introduction of a cancellation flag in the hashtable entries, to
> replace the cases where AbsorbFsyncRequests can try to delete entries.
> What that means is mdsync() doesn't need an outer retry loop at all:
I foole
Alvaro Herrera wrote:
> Ok, here it is, after considerable rejiggering.
Hum, just noticed a leftover from a previous version; the changes to
procarray.c, sinvaladt.c and lock.c should be discarded (they are just
about adding autovacuum_max_workers to code that uses MaxBackends). The
changes are t
Hi Tom,
The original patch was submitted by Kai Sattler, and we (at EDB) spent a
lot of time improving it, making it as seamless and as user-friendly as
possible. As is evident from the version number of the patch (v26), it has
gone through a lot of iterations, and was available to the communi
I wrote:
> This patch looks fairly sane to me; I have a few small gripes about
> coding style but that can be fixed while applying. Heikki, you were
> concerned about the cycle-ID idea; do you have any objection to this
> patch?
Actually, on second look I think the key idea here is Takahiro-san's
Koichi Suzuki <[EMAIL PROTECTED]> writes:
> My proposal is to remove unnecessary full page writes (they are needed
> in crash recovery from inconsistent or partial writes) when we copy WAL
> to archive log and rebuilt them as a dummy when we restore from archive
> log.
> ...
> Benchmark: DBT-2
>
Am Dienstag, 10. April 2007 15:17 schrieb Andrew Dunstan:
> Nikolay Samokhvalov wrote:
> > 6. (bugfix) Work with fragments with prologue: select xpath('/a',
> > ''); // now XML datum is always wrapped
> > with dummy ..., XML prologue simply goes away (if any).
>
> Is that legal XML? I though only
Nikolay Samokhvalov wrote:
6. (bugfix) Work with fragments with prologue: select xpath('/a',
''); // now XML datum is always wrapped
with dummy ..., XML prologue simply goes away (if any).
Is that legal XML? I though only documents could have prologs.
cheers
andrew
-
Here is new version that adds following changes:
4. Function is now strict, per discussion.
5. Return empty array in case when XPath expression detects nothing
(previously, NULL was returned in such case), per discussion.
6. (bugfix) Work with fragments with prologue: select xpath('/a',
''); //
"Simon Riggs" <[EMAIL PROTECTED]> wrote:
> > transaction_guarantee.v11.patch
> correct files attached
This is a small fix to transaction_guarantee patch.
WAL writer needs PGSharedMemoryReAttach() on EXEC_BACKEND platforms.
Other changes are only for suppressing warnings.
We might also need to i
Hi,
On 4/10/07, Bruce Momjian <[EMAIL PROTECTED]> wrote:
Added to TODO:
o Have WITH CONSTRAINTS also create constraint indexes
http://archives.postgresql.org/pgsql-patches/2007-04/msg00149.php
Trevor's patch does add unique/primary indexes. This would mean that we have
to remove t
"David Fetter" <[EMAIL PROTECTED]> writes:
> On Mon, Apr 09, 2007 at 06:43:08PM -0400, Tom Lane wrote:
>
>> So this does not really add any new functionality, it's just variant
>> syntax for something you can do about as easily without it, right?
>
> Not totally as easily. For example, you can do
"Bruce Momjian" <[EMAIL PROTECTED]> writes:
> Added to TODO:
>
> o Allow single-byte header storage for arrays
Fwiw this is "single-byte header storage for varlena array *elements*"
The arrays themselves already get the packed varlena treatment.
--
Gregory Stark
EnterpriseDB
19 matches
Mail list logo
