This is a proposal for archive log compression keeping physical log in WAL.
In PotgreSQL 8.2, full-page_writes option came back to cut out physical
log both from WAL and archive log. To deal with the partial write
during the online backup, physical log is written only during the online
backup.
Tom Lane wrote:
Mark Dilger <[EMAIL PROTECTED]> writes:
Tom Lane wrote:
Would a simple constant value be workable, or do we need some more
complex model (and if so what)?
Consider:
ANALYZE myfunc(integer) ON (SELECT myfunc(7)) WITH RATIO 0.03;
...
It seems to me that the above system would w
Mark Dilger <[EMAIL PROTECTED]> writes:
> Tom Lane wrote:
>> Would a simple constant value be workable, or do we need some more
>> complex model (and if so what)?
> Consider:
> ANALYZE myfunc(integer) ON (SELECT myfunc(7)) WITH RATIO 0.03;
> ...
> It seems to me that the above system would work pe
Tom Lane wrote:
Would a simple constant value be workable, or do we need some more
complex model (and if so what)?
Consider:
ANALYZE myfunc(integer) ON (SELECT myfunc(7)) WITH RATIO 0.03;
ANALYZE myfunc(text,text) ON (SELECT myfunc(mt.a,mt.b) FROM mytable mt) WITH
RATIO 1.071;
ANALYZE myfu
Peter Eisentraut wrote:
> David Fetter wrote:
>> I think it's necessary to get each in its own schema whether we have
>> an initdb flag or not.
>
> In any case, the initdb flag idea is about as much a nonstarter as the
> configure flag idea, for the same (packaging) reasons.
I don't see your poi
>>> --enable-extension=earthdistance
>> And have to parse for each extension?
> I don't see this as a big problem.
Well I am not really interesting in this. Someone else is welcome
to try that.
>>> It's really not hard, even for a C n00b like me. :)
>> I didn't say it was har
David Fetter wrote:
> I think it's necessary to get each in its own schema whether we have
> an initdb flag or not.
In any case, the initdb flag idea is about as much a nonstarter as the
configure flag idea, for the same (packaging) reasons.
--
Peter Eisentraut
http://developer.postgresql.org/~
On Sun, Jan 28, 2007 at 02:14:36PM -0800, Joshua D. Drake wrote:
> > I don't think "all or nothing" is a good way to do this. 500
> > functions in a schema called extensions isn't much more helpful
> > than 500 in public. There's a reason namespaces were invented
> > long ago, and this is classic
>
> I don't think "all or nothing" is a good way to do this. 500
> functions in a schema called extensions isn't much more helpful than
> 500 in public. There's a reason namespaces were invented long ago,
> and this is classic use case for same. :)
I disagree, see my post previously about initi
On Sun, Jan 28, 2007 at 01:58:38PM -0800, Joshua D. Drake wrote:
>
> >> Well to me that gets a little messy. I mean:
> >>
> >> pg_catalog,public,,xml2,ltree (just to get a could
> >> functions?) etc...
> >
> > Not as messy as trying to drop or re-create a package when there
> > are already 500 fu
>> I don't mind this term, BUT, what we need to get across is not just that
>> these are extensions, but that they are *standard* extensions, supplied
>> with PostgreSQL core code and supported by the PostgreSQL core team.
>> This would be analogous with, say, the standard perl modules (like
>
>> Well to me that gets a little messy. I mean:
>>
>> pg_catalog,public,,xml2,ltree (just to get a could
>> functions?) etc...
>
> Not as messy as trying to drop or re-create a package when there are
> already 500 functions in the public schema.
I am not sure I understand the correlation. I am n
I wrote:
> One possibility for fixing it is that maybe we should be making an
> effort to execute Tcl_Finalize() before exiting the backend. If so,
> having pltcl set up an on_proc_exit callback to do it would be the
> appropriate thing. This is all speculation though.
Just for grins I tried thi
On Sun, Jan 28, 2007 at 04:52:27PM -0500, Andrew Dunstan wrote:
>
>
> Michael Glaesemann wrote:
> >
> >On Jan 28, 2007, at 11:25 , Joshua D. Drake wrote:
> >
> >>David Fetter wrote:
> >>>Not so great. SQL:2003 has a special meaning for the word "module."
> >>
> >>Yeah I saw mention of that in ano
Michael Glaesemann wrote:
On Jan 28, 2007, at 11:25 , Joshua D. Drake wrote:
David Fetter wrote:
Not so great. SQL:2003 has a special meaning for the word "module."
Yeah I saw mention of that in another thread, but I really didn't like
the word plugins. Do you have another thought? Extens
On Sun, Jan 28, 2007 at 10:10:14AM -0800, Joshua D. Drake wrote:
> David Fetter wrote:
> > On Sat, Jan 27, 2007 at 09:49:25PM -0800, Joshua D. Drake wrote:
> >> Tom Lane wrote:
> >>> "Joshua D. Drake" <[EMAIL PROTECTED]> writes:
> So what are we thinking here? Along with my suggestion of
> >>>
Oleg Bartunov wrote:
> I'm wonderin why global setting
> doesn't work.
It's not implemented. Feel free to code it. :)
--
Peter Eisentraut
http://developer.postgresql.org/~petere/
---(end of broadcast)---
TIP 1: if posting/reading through Usenet
Stefan Kaltenbrunner <[EMAIL PROTECTED]> writes:
> FWIW - I removed --with-tcl from quagga's configuration about two weeks
> ago and it has not failed(for that reason) again. So the issue most
> definitly looks like plptcl related ...
I poked around a bit in the Tcl sources, and as far as I can te
> It seems a general solution would involve having dependency.c take
> exclusive locks on all types of objects (not only tables) as it scans
> them and decides they need to be deleted later. And when adding a
> pg_depend entry, we'd need to take a shared lock and then recheck to
> make sure the
On Sun, 2007-01-28 at 20:47 +0100, Magnus Hagander wrote:
> uuid_t is defined to UUID in the win32 platform SDK header files. I
> would suggest we use pguuid_t or something like that instead.
We could possibly try to workaround it by #undef'ing any existing uuid_t
definitions before we supply our
Seems the UUID patch broke Windows builds.
http://www.pgbuildfarm.org/cgi-bin/show_log.pl?nm=snake&dt=2007-01-28%2018:30:01
uuid_t is defined to UUID in the win32 platform SDK header files. I
would suggest we use pguuid_t or something like that instead.
//Magnus
---(end o
On Sun, 28 Jan 2007, Peter Eisentraut wrote:
Oleg Bartunov wrote:
I want to center a content of table's cell
Put the align attributes into the entry elements.
I'm wonderin why global setting doesn't
work. Specifying that fro each entry element looks very inefficient.
Regards,
Hello
SQL/PSM standard defines language for stored procedures. PL/pgPSM is
postgresql's implementation of SQL/PSM. I uploaded first version, which can
be tested without patching core files. Simply download and compile it. Some
samples you can find on
http://postgresql.interweb.cz/index.php/SQ
Oleg Bartunov wrote:
> I want to center a content of table's cell
Put the align attributes into the entry elements.
--
Peter Eisentraut
http://developer.postgresql.org/~petere/
---(end of broadcast)---
TIP 2: Don't 'kill -9' the postmaster
Gregory Stark <[EMAIL PROTECTED]> writes:
> I've thought further about this and I believe the problem is simpler than we
> were thinking previously. All we need is one boolean flag on the equality
> operator for the data type (or perhaps it would be more convenient to have it
> on the operator clas
David Fetter wrote:
> On Sat, Jan 27, 2007 at 09:49:25PM -0800, Joshua D. Drake wrote:
>> Tom Lane wrote:
>>> "Joshua D. Drake" <[EMAIL PROTECTED]> writes:
So what are we thinking here? Along with my suggestion of
extensions / contrib that we modify initdb to load an extensions
schem
"Simon Riggs" <[EMAIL PROTECTED]> writes:
> In a thread in July last year, I raised the possibility of transforming
> a query to allow functional indexes to be utilised automatically.
> http://archives.postgresql.org/pgsql-hackers/2006-07/msg00323.php
>
> This idea can work and has many benefits,
Hi there,
I want to center a content of table's cell
(ex. http://mira.sai.msu.su/~megera/pgsql/lockmatrix/c2.html),
but jade seems doesn't generate a right html code.
sgml code looks like:
Lock Matrix
I run
jade -d stylesheet.dsl -i output-html -t sgml test.sgml
What
Joachim Wieland wrote:
> On Fri, Jan 26, 2007 at 10:10:20PM +0100, Magnus Hagander wrote:
I would like to build pg on VC2005. How do I use pthreads that is
mentioned in the README file. Do I need the DLL? Sources? LIB?
Where do I install or copy them..
>
>>> Err, pthreads is a threa
On Fri, Jan 26, 2007 at 10:10:20PM +0100, Magnus Hagander wrote:
> >> I would like to build pg on VC2005. How do I use pthreads that is
> >> mentioned in the README file. Do I need the DLL? Sources? LIB?
> >> Where do I install or copy them..
> > Err, pthreads is a threads library for Unix, I don'
Greg Sabino Mullane wrote:
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Surely, I've created one (nickname: Nikolay) and are
trying to do things being logged in :-)
You should be able to edit now with the "Nikolay" account.
If anyone else is having problems, please send me an email.
I'll wo
Kevin Barnard wrote:
> The basic idea of my proposal would be to have a function that checks
> for the existence of C libraries. The next piece I would need would
> be a mechanism for psql to halt the restore SQL script if these
> checks failed. Finally I would need to add a switch to tell pg_dump
Joshua D. Drake wrote:
> Add directory /modules
Moving stuff around in the source code probably won't matter much at all
since few users will actually look into the source code. What we need
is better presentation and accessibility of the installed items, for
example documentation and installa
33 matches
Mail list logo
