Am Mittwoch, den 26.07.2006, 16:58 -0400 schrieb Tom Lane:
Susanne Ebrecht [EMAIL PROTECTED] writes:
This is a cute hack, but it does only a small part of what I think the
spec says.
Thank you for compliment.
In the first place, the SQL syntax is pretty clear that you can combine
simple
Include here a prototype patch that implements pg_switch_xlog() in line
with earlier discussions about how this should be implemented.
This patch implements
- separate function for manual xlog switch
- internals to allow pg_stop_backup() to perform auto log switching
Patch applies cleanly to
Patch applied. Thanks.
---
Albe Laurenz wrote:
Bruce Momjian wrote:
This patch for libpq allows you to enter an LDAP URL in
pg_service.conf.
The URL will be queried and the resulting string(s) parsed for
keyword
Susanne Ebrecht [EMAIL PROTECTED] writes:
... We could provide the mixed update syntax and leave the
typed row value expression for the next release. Do you agree?
I don't really see the point --- the patch won't provide any new
functionality in anything like its current form, because you can
Bruce Momjian [EMAIL PROTECTED] writes:
Tom Lane wrote:
UPDATE mytab SET (foo, bar, baz) =
(SELECT alpha, beta, gamma FROM othertab WHERE key = mytab.key);
That UPDATE example is interesting because I remember when using
Informix that I had to do a separate SELECT statement for each UPDATE
Tom Lane wrote:
Bruce Momjian [EMAIL PROTECTED] writes:
Tom Lane wrote:
UPDATE mytab SET (foo, bar, baz) =
(SELECT alpha, beta, gamma FROM othertab WHERE key = mytab.key);
That UPDATE example is interesting because I remember when using
Informix that I had to do a separate SELECT
Joachim,
I checked your improvement and fix some problem with following scenario:
shared_buffers = 3301
START
share_buffers = 333.39
HUP
share_buffers requires integer value. Skip configuration file
#share_buffers = 3301
HUP
silent - no message
I performed some cleanup in my code as well.
You are correct.
Patch against the latest HEAD attached.
Josh
Andrew Dunstan wrote:
Joshua Reich wrote:
Ok. Here is a diff taken from the top of the contrib tree. I have
suppressed the notices in both the cube and earthdistance packages.
All tests pass.
Doesn't this contain parts that
On Jul 27, 2006, at 7:30 AM, Tom Lane wrote:
Susanne Ebrecht [EMAIL PROTECTED] writes:
... We could provide the mixed update syntax and leave the
typed row value expression for the next release. Do you agree?
I don't really see the point --- the patch won't provide any new
functionality in
On Jul 26, 2006, at 4:29 PM, Hannu Krosing wrote:
Well the desire for it comes from a very well established need
for dealing
with extremely large tales with relatively small hot spots. The
basic problem
being that currently the cost of vacuum is proportional to the
size of the
table rather
There is also an issue with PPC processors with +/-0 in the cube test:
*** ./expected/cube.out Thu Jul 27 05:23:14 2006
--- ./results/cube.out Thu Jul 27 05:43:21 2006
***
*** 144,150
SELECT '-1e-700'::cube AS cube;
cube
--
! (0)
(1 row)
SELECT
On Wednesday 26 July 2006 14:27, Darcy Buskermolen wrote:
On Wednesday 26 July 2006 14:03, Tom Lane wrote:
Darcy Buskermolen [EMAIL PROTECTED] writes:
The question though is if we did that, would Slony actually use it?
If it made sence to do it, then yes we would do it. The problem
Tom Lane wrote:
Susanne Ebrecht [EMAIL PROTECTED] writes:
... We could provide the mixed update syntax and leave the
typed row value expression for the next release. Do you agree?
I don't really see the point --- the patch won't provide any new
functionality in anything like its current form,
On Jul 26, 2006, at 10:29 AM, Tom Lane wrote:
Gregory Stark [EMAIL PROTECTED] writes:
... Well it's not like the existing vacuum checks for this.
Right, that's exactly why the patch works at all. But the point
here is
that the existing vacuum does not rely on re-computing index keys; all
Joshua Reich wrote:
You are correct.
Patch against the latest HEAD attached.
I have applied this and made an attempt to fix cube/expected/cube_1.out
- we will still need to keep an eye on the various cube tests.
cheers
andrew
---(end of
On Tue, 2006-07-18 at 16:36 -0700, Marc Munro wrote:
The attached patch provides add-ins with the means to register for
shared memory and LWLocks. This greatly improves the ease with which
shared memory may be used from add-ins, while blah blah blah
I have tried to be patient but this is
Marc Munro [EMAIL PROTECTED] writes:
The attached patch provides add-ins with the means to register for
shared memory and LWLocks. This greatly improves the ease with which
shared memory may be used from add-ins, while blah blah blah
I have tried to be patient but this is my first patch
Jim Nasby [EMAIL PROTECTED] writes:
Even if we stopped right there it would still be a huge win in many (most?)
cases. How often do the indexes on a table comprise even 50% of the table's
size?
I would say they're usually roughly comparable actually. It depends on how
wide your table is
Jim Nasby wrote:
On Jul 27, 2006, at 7:30 AM, Tom Lane wrote:
Susanne Ebrecht [EMAIL PROTECTED] writes:
... We could provide the mixed update syntax and leave the
typed row value expression for the next release. Do you agree?
I don't really see the point --- the patch won't provide any
19 matches
Mail list logo