[EMAIL PROTECTED] writes:
> I have a few people in Europe trying out the rc1 port for OS/2 and they
> have run into a problem with the locale settings
> They have a locale set as de_DE_EURO and the initdb program really does
> not like this because the setlocale(LC_MESSAGES, NULL) call returns a z
Gavin Sherry <[EMAIL PROTECTED]> writes:
> I was also thinking of benchmarking the effect of changing the algorithm
> in StrategyDirtyBufferList(): currently, for each iteration of the loop we
> read a buffer from each of T1 and T2. I was wondering what effect reading
> T1 first then T2 and vice ve
Will do...
thanks
Lorne
In <[EMAIL PROTECTED]>, on 12/21/04
at 01:56 AM, "Marc G. Fournier" <[EMAIL PROTECTED]> said:
>check her over ..
>
>Marc G. Fournier Hub.Org Networking Services
>(http://www.hub.org) Email: [EMAIL PROTECTED] Yahoo!: yscrappy
>
>
check her over ..
Marc G. Fournier Hub.Org Networking Services (http://www.hub.org)
Email: [EMAIL PROTECTED] Yahoo!: yscrappy ICQ: 7615664
---(end of broadcast)---
TIP 9: the planner will ignore your desire to cho
Postgresql-8.0.0rc1
hardware: HP Dual PPro
os: Linux Slackware 10.0.0
kernel: 2.6.9-ac16 SMP
gcc: 3.3.4
configure: ./configure --prefix=/usr/local/pgsql --with-tcl --with-perl
--with-x --enable-syslog --with-openssl --with-pgport=5432 --with-odbc
--enable-thread-safety
8.0.0beta4 was installed
Respected Sir
This is srinvas.
I have been working with Postgresql and have
created tables,constraints and so on.
Now i am writing stored functions using refcursor
and the stored function have created successfully. But i have problem to
validate the parameters passed in the call functio
Le 16 déc. 04, à 22:48, Bruce Momjian a écrit :
I am confused by the threading failure. I don't see any free() call in
thread_test.c. Would you go to the tools/thread directory and run the
program manually and use a debugger to see the failure line? Is there
some threading flag NetBSD requires
Gavin Sherry wrote:
> Neil and I spoke with Jan briefly last week and he mentioned a few
> different approaches he'd been tossing over. Firstly, for alternative
> runs, start X% on from the LRU, so that we aren't scanning clean buffers
> all the time. Secondly, follow something like the approach yo
On Mon, 20 Dec 2004, Tom Lane wrote:
> Bruce Momjian <[EMAIL PROTECTED]> writes:
> > Tom Lane wrote:
> >> Exactly. But 1% would be uselessly small with this definition. Offhand
> >> I'd think something like 50% might be a starting point; maybe even more.
> >> What that says is that a page isn't
Tom Lane wrote:
> Bruce Momjian <[EMAIL PROTECTED]> writes:
> > Tom Lane wrote:
> >> Exactly. But 1% would be uselessly small with this definition. Offhand
> >> I'd think something like 50% might be a starting point; maybe even more.
> >> What that says is that a page isn't a candidate to be writ
Hi
I have a few people in Europe trying out the rc1 port for OS/2 and they
have run into a problem with the locale settings
They have a locale set as de_DE_EURO and the initdb program really does
not like this because the setlocale(LC_MESSAGES, NULL) call returns a zero
length string. When the po
Bruce Momjian <[EMAIL PROTECTED]> writes:
> Tom Lane wrote:
>> Exactly. But 1% would be uselessly small with this definition. Offhand
>> I'd think something like 50% might be a starting point; maybe even more.
>> What that says is that a page isn't a candidate to be written out by the
>> bgwriter
Tom Lane wrote:
> Bruce Momjian <[EMAIL PROTECTED]> writes:
> > I am confused. If we change the percentage to be X% of the entire
> > buffer cache, and we set it to 1%, and we exit when either the dirty
> > pages or % are reached, don't we end up just scanning the first 1% of
> > the cache over an
Bruce Momjian <[EMAIL PROTECTED]> writes:
> I am confused. If we change the percentage to be X% of the entire
> buffer cache, and we set it to 1%, and we exit when either the dirty
> pages or % are reached, don't we end up just scanning the first 1% of
> the cache over and over again?
Exactly. B
Bruce Momjian <[EMAIL PROTECTED]> writes:
> You need a "clock sweep" like BSD uses (and probably others).
No, that's *fundamentally* wrong.
The reason we are going to the trouble of maintaining a complicated
cache algorithm like ARC is so that we can tell the heavily used pages
from the lesser us
On Mon, 20 Dec 2004, Bruce Momjian wrote:
Marc G. Fournier wrote:
On Tue, 14 Dec 2004, Peter Eisentraut wrote:
Am Samstag, 4. Dezember 2004 00:12 schrieb Marc G. Fournier:
look her over ... I forced a sync to the ftp.postgresql.org server, so its
available there ... will announce later this evening
Marc G. Fournier wrote:
> On Tue, 14 Dec 2004, Peter Eisentraut wrote:
>
> > Am Samstag, 4. Dezember 2004 00:12 schrieb Marc G. Fournier:
> >> look her over ... I forced a sync to the ftp.postgresql.org server, so its
> >> available there ... will announce later this evening baring any 'its
> >> b
Tom Lane wrote:
> Bruce Momjian <[EMAIL PROTECTED]> writes:
> > I think the ideal solution would be to remove bgwriter_percent or change
> > it to be a percentage of all buffers, not just dirty buffers, so we
> > don't have to scan the entire list. If we set the new value to 10% with
> > a delay o
Ok,
I didn't think you could do a restore as a non-superuser. I had
executed the command on the remote(cygwin) machine in this case. I
didn't specify a user to have it run as on the windows side (thought it
would default to postgres).
On the cygwin side I did execute it under a non-superuser
At 2004-12-19 17:56:00 +0530, [EMAIL PROTECTED] wrote:
>
> I've asked the Ethereal people if they want to distribute this with
> Ethereal.
It's in Ethereal CVS now.
-- ams
---(end of broadcast)---
TIP 2: you can get off all lists at once with the u
On Tue, 14 Dec 2004, Peter Eisentraut wrote:
Am Samstag, 4. Dezember 2004 00:12 schrieb Marc G. Fournier:
look her over ... I forced a sync to the ftp.postgresql.org server, so its
available there ... will announce later this evening baring any 'its
broken' commends ;)
You are building the document
Andrew Dunstan <[EMAIL PROTECTED]> writes:
> I am abandoning further effort altogether, because of this:
> adunstan: ~/tcl8.4.9/win
> $ ./configure --enable-shared
> checking for Cygwin environment... yes
> configure: error: Compiling under Cygwin is not currently supported.
> A maintainer for the
Bruce Momjian <[EMAIL PROTECTED]> writes:
> I think the ideal solution would be to remove bgwriter_percent or change
> it to be a percentage of all buffers, not just dirty buffers, so we
> don't have to scan the entire list. If we set the new value to 10% with
> a delay of 1 second, and the bgwrit
Tom Lane wrote:
here's what is in /usr/lib/tclConfig.sh - maybe there's a clue in there
- or maybe it's just a problem with the Cygwin-supplied package - I have
deliberately not tried to fix this by installing my own build of tcl.
The Cygwin-supplied package is evidently broken beyond be
Andrew Dunstan <[EMAIL PROTECTED]> writes:
> Tom Lane wrote:
>> Agreed on missing -ltcl. It seems odd given that the Cygwin case in
>> Makefile.shlib does include $(SHLIB_LINK) and pltcl's Makefile does add
>> $(TCL_LIB_SPEC) to SHLIB_LINK. Is TCL_LIB_SPEC getting set reasonably
>> by configure?
We are now packaging RC2. If nothing comes up after RC2 is released, we
can move to final release.
The open items list is attached. The doc changes can be easily
completed before final. The only code issue left is with bgwriter. We
always knew we needed to find better defaults for its paramete
Both added to TODO:
---
Simon Riggs wrote:
> On Mon, 2004-11-29 at 13:10, Bruce Momjian wrote:
> > Or TODO maybe worded as:
> >
> > * Allow the PITR process to be debugged and data examined
> >
>
> Yes, thats good fo
Andrew Dunstan <[EMAIL PROTECTED]> writes:
> Tom Lane wrote:
>> Nope. What are the symptoms exactly?
> log attached. Looks like there is at least a missing "-ltcl" in the call
> to dllwrap, but that's not all.
Agreed on missing -ltcl. It seems odd given that the Cygwin case in
Makefile.shlib d
Andrew Dunstan <[EMAIL PROTECTED]> writes:
> Tom Lane wrote:
>> "Andrew Dunstan" <[EMAIL PROTECTED]> writes:
>>> I have not been able to build Cygwin with pltcl, and neither has anyone else
>>> to the best of my knowledge.
>>
>> Has that worked in prior releases?
> I have no idea. It's hard to th
Tom Lane wrote:
"Andrew Dunstan" <[EMAIL PROTECTED]> writes:
Anybody got last-minute stuff?
I have not been able to build Cygwin with pltcl, and neither has anyone else
to the best of my knowledge.
Has that worked in prior releases?
I have no idea. It's hard to think of a reas
"Andrew Dunstan" <[EMAIL PROTECTED]> writes:
>> Anybody got last-minute stuff?
> I have not been able to build Cygwin with pltcl, and neither has anyone else
> to the best of my knowledge.
Has that worked in prior releases?
regards, tom lane
---(e
Goal: on a prduction server, to gradually shrink a table (no matter how
large) back to < 10% free space without "noticeably" interrupting write
access to it. ("noticeably" = without taking any exclusive locks for
more than a few seconds at a time.)
I am thinking about making this if it proves
Tom Lane said:
> Barring loud squawks, Marc will bundle up 8.0RC2 this evening sometime.
> Anybody got last-minute stuff?
>
I have not been able to build Cygwin with pltcl, and neither has anyone else
to the best of my knowledge.
I will investigate - probably a makefile issue - unless someone el
8.0.0rc1 builds and passes 'make check' on Gentoo Linux (amd64) with the
dependencies I have to hand (no tcl or kerberos):
$ ./configure --prefix=/home/oliver/pg/8.0.0rc1 --with-pgport=5800
-enable-thread-safety --with-perl --with-python --with-pam -with-openssl
$ uname -a
Linux extrashiny 2.6.
Tom Lane <[EMAIL PROTECTED]> wrote on 20.12.2004, 19:34:21:
> Alvaro Herrera writes:
> > To solve the problem I want to solve, we have three orthogonal
> > possibilities:
>
> > 1. implement shared row locking using the ideas outlined in the mail
> > starting this thread (pg_clog-like seems to be
Michael Fuhr <[EMAIL PROTECTED]> writes:
> Is the following a plperl problem or does it need to be fixed in
> DBD::PgSPI? I never saw any responses.
> http://archives.postgresql.org/pgsql-bugs/2004-12/msg00097.php
AFAIK it's a PgSPI issue. plperl wraps its spi.c calls in a
subtransaction, but i
On Mon, Dec 20, 2004 at 02:04:46PM -0500, Tom Lane wrote:
> Barring loud squawks, Marc will bundle up 8.0RC2 this evening sometime.
> Anybody got last-minute stuff?
Is the following a plperl problem or does it need to be fixed in
DBD::PgSPI? I never saw any responses.
http://archives.postgresql
Barring loud squawks, Marc will bundle up 8.0RC2 this evening sometime.
Anybody got last-minute stuff?
regards, tom lane
---(end of broadcast)---
TIP 3: if posting/reading through Usenet, please send an appropriate
subs
Alvaro Herrera <[EMAIL PROTECTED]> writes:
> To solve the problem I want to solve, we have three orthogonal
> possibilities:
> 1. implement shared row locking using the ideas outlined in the mail
> starting this thread (pg_clog-like seems to be the winner, details TBD).
> 2. implement shared lock
On Mon, Dec 20, 2004 at 11:58:21AM -0600, Jaime Casanova wrote:
Jaime,
> I was looking in the archives something about this but
> i found nothing. Where can i found the thread (i
> suppose should be one) about this issue?
Did you use the search engine at http://www.pgsql.ru ?
--
Alvaro Herrera
On Mon, Dec 20, 2004 at 11:47:41AM -0500, Tom Lane wrote:
> To me, "performance buster" is better than "random, unrepeatable
> deadlock failures". In any case, if we find we *can't* implement this
> in a non-performance-busting way, then it would be time enough to look
> at alternatives that forc
Jaime Casanova wrote:
> Hi everyone,
>
> >From the TODO items:
> Use index to restrict rows returned by multi-key index
> when used with non-consecutive keys to reduce heap
> accesses.
> For an index on col1,col2,col3, and a WHERE clause of
> col1 = 5 and col3 = 9, spin though the index checking
>
Hi everyone,
>From the TODO items:
Use index to restrict rows returned by multi-key index
when used with non-consecutive keys to reduce heap
accesses.
For an index on col1,col2,col3, and a WHERE clause of
col1 = 5 and col3 = 9, spin though the index checking
for col1 and col3 matches, rather than
"Merlin Moncure" <[EMAIL PROTECTED]> writes:
> I may be over my head here, but I think lock spillover is dangerous. In
> the extreme situations where this would happen, it would be a real
> performance buster. Personally, I would rather see locks escalate when
> the table gets full, or at least a
Tom lane wrote:
> Gavin Sherry <[EMAIL PROTECTED]> writes:
> > I think if we allow the lock manager to spill to disk (and I think
we do
> > need to allow it) then we should also be able to control the amount
of
> > shared memory allocated.
>
> You mean like max_locks_per_transaction?
IMO, max_loc
overbored <[EMAIL PROTECTED]> writes:
> Hi all, I added a new variable-length field to the pg_class catalog, but
> I did something wrong, and I can't tell what else I'd need to change.
> ...
> The REVOKE command invokes ExecuteGrantStmt_Relation() to modify the
> relacl attribute of pg_class, whi
Alvaro Herrera <[EMAIL PROTECTED]> writes:
> Gavin also mentioned to me we should also control the amount of memory
> the shared inval queue uses.
Perhaps, but I've really seen no evidence that there's a need to worry
about that. Without demonstrated problems I'd sooner keep that code a
bit simpl
Gavin Sherry <[EMAIL PROTECTED]> writes:
> I think if we allow the lock manager to spill to disk (and I think we do
> need to allow it) then we should also be able to control the amount of
> shared memory allocated.
You mean like max_locks_per_transaction?
regards, tom lan
On Mon, Dec 20, 2004 at 06:23:24PM +1100, Gavin Sherry wrote:
> On Sat, 18 Dec 2004, Bruce Momjian wrote:
> > Agreed. Once concern I have about allowing the lock table to spill to
> > disk is that a large number of FOR UPDATE locks could push out lock
> > entries used by other backends, causing ve
Hannu Krosing wrote:
Would SECURITY DEFINER not work for pljava ?
Or if you are looking for something that has to be done inside the pl
handler maybe you should use another function with SECURITY DEFINER and
owned by superuser for function lookups ?
Of course. That's even better then a SetUser. Ful
On R, 2004-12-17 at 21:12, Thomas Hallgren wrote:
> I'd like some views on the following issue.
>
> The pljava function call handler will resolve a class name using a
> loader that in turn uses a specific table in the PostgreSQL database.
> Hence, the caller of the function must have select perm
Tom Lane wrote:
Gaetano Mendola <[EMAIL PROTECTED]> writes:
I'm having a bounce of errors because IMMUTABLE and STABLE
attributes for some of my functions. Let me explain with an example,
Hmm. This particular example is a bug in exec_eval_simple_expr() ...
if we're going to bypass SPI then we'd b
Sibtay Abbas wrote:
> what is the value of yyin variable for postgresql
> parser.
We don't use yyin. See scanner_init() in src/backend/parser/scan.l
about the scanner initialization.
--
Peter Eisentraut
http://developer.postgresql.org/~petere/
---(end of broadcast)
On Thu, 2004-12-16 at 11:07, Neil Conway wrote:
> Zeugswetter Andreas DAZ SD wrote:
> > This has the disadvantage of converging against 0 dirty pages.
> > A system that has less than maxpages dirty will write every page with
> > every bgwriter run.
>
> Yeah, I'm concerned about the bgwriter being
On Thu, 2004-12-16 at 17:54, Richard Huxton wrote:
> Josh Berkus wrote:
> >>Clearly, OSDL-DBT2 is not a real world test! That is its benefit, since
> >>it is heavily instrumented and we are able to re-run it many times
> >>without different parameter settings. The application is well known and
> >>
On Mon, 2004-12-20 at 06:34, Jim C. Nasby wrote:
> On Sun, Dec 19, 2004 at 11:35:02PM +0200, Heikki Linnakangas wrote:
> > On Sun, 19 Dec 2004, Tom Lane wrote:
> >
> > >Heikki Linnakangas <[EMAIL PROTECTED]> writes:
> > >>On Sun, 19 Dec 2004, Alvaro Herrera wrote:
> > >>>This is not useful at all,
On Mon, 2004-12-20 at 01:17, Mark Kirkwood wrote:
> Mark Kirkwood wrote:
>
> > It occurs to me that cranking up the number of transactions (say
> > 1000->10) and seeing if said regression persists would be
> > interesting. This would give the smoothing effect of the bgwriter
> > (plus the
57 matches
Mail list logo