Simon Riggs <[EMAIL PROTECTED]> writes:
> It may surprise you but I didn't read Tom's words as being against
> "Simon's approach". Personally I read them as a generic warning, which I
> agreed with. Maybe Tom can straighten that out.
AFAIR, I just said that I'd find it hard to trust any complex me
Log Message:
---
Fix regexp substring matching (substring(string from pattern)) for the corner
case where there is a match to the pattern overall but the user has specified
a parenthesized subexpression and that subexpression hasn't got a match.
An example is substring('foo' from 'foo(bar)?
Log Message:
---
Fix regexp substring matching (substring(string from pattern)) for the corner
case where there is a match to the pattern overall but the user has specified
a parenthesized subexpression and that subexpression hasn't got a match.
An example is substring('foo' from 'foo(bar)?
Log Message:
---
Fix regexp substring matching (substring(string from pattern)) for the corner
case where there is a match to the pattern overall but the user has specified
a parenthesized subexpression and that subexpression hasn't got a match.
An example is substring('foo' from 'foo(bar)?
Log Message:
---
Add -M (query mode) option per ITAGAKI Takahiro
Modified Files:
--
pgsql/contrib/pgbench:
pgbench.c (r1.78 -> r1.79)
(http://anoncvs.postgresql.org/cvsweb.cgi/pgsql/contrib/pgbench/pgbench.c?r1=1.78&r2=1.79)
pgsql/doc/src/sgml:
Log Message:
---
Fix regexp substring matching (substring(string from pattern)) for the corner
case where there is a match to the pattern overall but the user has specified
a parenthesized subexpression and that subexpression hasn't got a match.
An example is substring('foo' from 'foo(bar)?
Log Message:
---
Fix regexp substring matching (substring(string from pattern)) for the corner
case where there is a match to the pattern overall but the user has specified
a parenthesized subexpression and that subexpression hasn't got a match.
An example is substring('foo' from 'foo(bar)?
Log Message:
---
Fix regexp substring matching (substring(string from pattern)) for the corner
case where there is a match to the pattern overall but the user has specified
a parenthesized subexpression and that subexpression hasn't got a match.
An example is substring('foo' from 'foo(bar)?
Log Message:
---
Add libpq new API lo_import_with_oid() which is similar to lo_import()
except that lob's oid can be specified.
Modified Files:
--
pgsql/doc/src/sgml:
lobj.sgml (r1.46 -> r1.47)
(http://anoncvs.postgresql.org/cvsweb.cgi/pgsql/doc/src/sgml/lo
Alvaro Herrera wrote:
> Simon Riggs wrote:
>
> > In any case, all I've said here is that we shouldn't put a specific
> > approach into the TODO. Just state the problem.
>
> Agreed. Perhaps the idea stated so far can be listed as possible
> alternatives to solving the problem, but they shouldn't
Log Message:
---
Fix tps calculation when -C supplied. Per Yoshiyuki Asaba.
Change Copyright owner from mine to PostgreSQL Global Development Group
Fix minor message typo
Modified Files:
--
pgsql/contrib/pgbench:
pgbench.c (r1.77 -> r1.78)
(http://anoncvs.p
Simon Riggs wrote:
> In any case, all I've said here is that we shouldn't put a specific
> approach into the TODO. Just state the problem.
Agreed. Perhaps the idea stated so far can be listed as possible
alternatives to solving the problem, but they shouldn't be the main body
of the TODO item.
Heikki Linnakangas wrote:
> How about:
>
> * Speed WAL recovery by allowing more than one page to be prefetched
>
> This should be done utilizing the same infrastructure used for
> prefetching in general, to avoid introducing complex, error-prone code
> to WAL replay codepath, which doesn't get
Log Message:
---
Spit items:
* Experiment with multi-threaded backend better I/O utilization
This would allow a single query to make use of multiple I/O channels
simultaneously. One idea is to create a background reader that can
pre-fetch sequential and index scan pages needed by o
Log Message:
---
Update TODO description:
* Speed WAL recovery by allowing more than one page to be prefetched
This should be done utilizing the same infrastructure used for
prefetching in general to avoid introducing complex error-prone code
in WAL replay.
Modified Files:
Log Message:
---
Add find_typedef comments for Linux.
Modified Files:
--
pgsql/src/tools:
find_typedef (r1.10 -> r1.11)
(http://anoncvs.postgresql.org/cvsweb.cgi/pgsql/src/tools/find_typedef?r1=1.10&r2=1.11)
--
Sent via pgsql-committers mailing list (pgsq
Log Message:
---
Add find_typedef comment.
Modified Files:
--
pgsql/src/tools:
find_typedef (r1.9 -> r1.10)
(http://anoncvs.postgresql.org/cvsweb.cgi/pgsql/src/tools/find_typedef?r1=1.9&r2=1.10)
--
Sent via pgsql-committers mailing list (pgsql-committers@
Log Message:
---
Add Linux support to find_typedefs, with help from Alvaro.
Modified Files:
--
pgsql/src/tools:
find_typedef (r1.8 -> r1.9)
(http://anoncvs.postgresql.org/cvsweb.cgi/pgsql/src/tools/find_typedef?r1=1.8&r2=1.9)
--
Sent via pgsql-committers
[EMAIL PROTECTED] (Peter Eisentraut) writes:
> Don't need -Wno-error anymore, because flex is no longer producing warnings.
This seems overoptimistic. The fact that the latest bleeding-edge flex
release is fixed does not mean that any significant population of PG
developers will have it installed
On Tue, 2008-03-18 at 16:56 -0400, Bruce Momjian wrote:
> Gregory Stark wrote:
> > "Bruce Momjian" <[EMAIL PROTECTED]> writes:
> >
> > >> > > On Tue, 2008-03-18 at 03:59 +, Bruce Momjian wrote:
> > >> > > > * Speed WAL recovery by allowing more than one page to be
> > >> > > > prefetched
> >
Robert Lor wrote:
> You didn't include the changes in pgsql/src/Makefile. By generating
> probes.h before the compile starts, it will allow probes to be added
> outside the backend without having to do anything extra. Is this not the
> right way or you think it's not needed now?
Once we have that
Log Message:
---
Arrange to "inline" SQL functions that appear in a query's FROM clause,
are declared to return set, and consist of just a single SELECT. We
can replace the FROM-item with a sub-SELECT and then optimize much as
if we were dealing with a view. Patch from Richard Rowell, cle
Bruce Momjian wrote:
Gregory Stark wrote:
"Bruce Momjian" <[EMAIL PROTECTED]> writes:
On Tue, 2008-03-18 at 03:59 +, Bruce Momjian wrote:
* Speed WAL recovery by allowing more than one page to be prefetched
This involves having a separate process that can be told which pages
the reco
Peter Eisentraut wrote:
Modified Files:
--
pgsql/src/backend:
Makefile (r1.127 -> r1.128)
(http://anoncvs.postgresql.org/cvsweb.cgi/pgsql/src/backend/Makefile?r1=1.127&r2=1.128)
pgsql/src/backend/access/transam:
xact.c (r1.259 -> r1.260)
(http
Gregory Stark wrote:
> "Bruce Momjian" <[EMAIL PROTECTED]> writes:
>
> >> > > On Tue, 2008-03-18 at 03:59 +, Bruce Momjian wrote:
> >> > > > * Speed WAL recovery by allowing more than one page to be prefetched
> >> > > >
> >> > > > This involves having a separate process that can be told wh
"Bruce Momjian" <[EMAIL PROTECTED]> writes:
>> > > On Tue, 2008-03-18 at 03:59 +, Bruce Momjian wrote:
>> > > > * Speed WAL recovery by allowing more than one page to be prefetched
>> > > >
>> > > > This involves having a separate process that can be told which pages
>> > > > the recovery
Log Message:
---
Add to TODO:
>
> * Consider not storing a NULL bitmap on disk if all the NULLs are
> trailing
>
> http://archives.postgresql.org/pgsql-hackers/2007-12/msg00624.php
> http://archives.postgresql.org/pgsql-patches/2007-12/msg00109.php
>
Modified Files:
--
Log Message:
---
Don't need -Wno-error anymore, because flex is no longer producing warnings.
Modified Files:
--
pgsql/src/interfaces/ecpg/preproc:
Makefile (r1.131 -> r1.132)
(http://anoncvs.postgresql.org/cvsweb.cgi/pgsql/src/interfaces/ecpg/preproc/Makef
Simon Riggs wrote:
> On Tue, 2008-03-18 at 11:36 -0400, Bruce Momjian wrote:
> > Simon Riggs wrote:
> > > On Tue, 2008-03-18 at 03:59 +, Bruce Momjian wrote:
> > > > Log Message:
> > > > ---
> > > > Add URLs for :
> > > >
> > > > * Speed WAL recovery by allowing more than one page to b
On Tue, 2008-03-18 at 11:36 -0400, Bruce Momjian wrote:
> Simon Riggs wrote:
> > On Tue, 2008-03-18 at 03:59 +, Bruce Momjian wrote:
> > > Log Message:
> > > ---
> > > Add URLs for :
> > >
> > > * Speed WAL recovery by allowing more than one page to be prefetched
> > >
> > > This in
Log Message:
---
Catch all errors in for and while loops in makefiles. Don't ignore any
errors in any commands, including in various clean targets that have so far
been handled inconsistently. make -i is available to ignore all errors in
a consistent and official way.
Modified Files:
---
Log Message:
---
cvsweb lives on anoncvs.postgresql.org these days.
Tags:
REL8_3_STABLE
Modified Files:
--
pgsql/doc/src/sgml:
acronyms.sgml (r1.4 -> r1.4.2.1)
(http://anoncvs.postgresql.org/cvsweb.cgi/pgsql/doc/src/sgml/acronyms.sgml?r1=1.4&r2=1.4.2.
Log Message:
---
cvsweb lives on anoncvs.postgresql.org these days.
Modified Files:
--
pgsql/doc/src/sgml:
acronyms.sgml (r1.4 -> r1.5)
(http://anoncvs.postgresql.org/cvsweb.cgi/pgsql/doc/src/sgml/acronyms.sgml?r1=1.4&r2=1.5)
--
Sent via pgsql-committers
Log Message:
---
Wiki page about cvs now lives in the main wiki, the one
on developer.postgresql.org is going away.
Tags:
REL8_3_STABLE
Modified Files:
--
pgsql/doc/src/sgml:
cvs.sgml (r1.47 -> r1.47.2.1)
(http://anoncvs.postgresql.org/cvsweb.cgi/pgsq
Log Message:
---
Wiki page about cvs now lives in the main wiki, the one
on developer.postgresql.org is going away.
Modified Files:
--
pgsql/doc/src/sgml:
cvs.sgml (r1.47 -> r1.48)
(http://anoncvs.postgresql.org/cvsweb.cgi/pgsql/doc/src/sgml/cvs.sgml?r1=1.4
Simon Riggs wrote:
> On Tue, 2008-03-18 at 03:59 +, Bruce Momjian wrote:
> > Log Message:
> > ---
> > Add URLs for :
> >
> > * Speed WAL recovery by allowing more than one page to be prefetched
> >
> > This involves having a separate process that can be told which pages
> > the re
Log Message:
---
Add TODO URLs for:
o Allow UPDATE tab SET ROW (col, ...) = (SELECT...)
> http://archives.postgresql.org/pgsql-patches/2007-04/msg00315.php
> http://archives.postgresql.org/pgsql-patches/2008-03/msg00237.php
Modified Files:
--
pgsql
Log Message:
---
Move elog(DEBUG4) call outside the locked area, per suggestion from Tom Lane.
Modified Files:
--
pgsql/src/backend/storage/ipc:
sinvaladt.c (r1.68 -> r1.69)
(http://anoncvs.postgresql.org/cvsweb.cgi/pgsql/src/backend/storage/ipc/sinvaladt.c
On Tue, 2008-03-18 at 03:59 +, Bruce Momjian wrote:
> Log Message:
> ---
> Add URLs for :
>
> * Speed WAL recovery by allowing more than one page to be prefetched
>
> This involves having a separate process that can be told which pages
> the recovery process will need in the near
39 matches
Mail list logo
