Tom Lane wrote:
Gaetano Mendola [EMAIL PROTECTED] writes:
The fact that a non-volatile function can not perform
update is a good improvement but on the other side will
limit too much if I know what I'm doing.
I've got zero sympathy for this argument. It's been documented right
along
, of course you have
to create a memory manager that handle not ccntinuous segments.
Of course this only if the effort to do it can justify the man power working
on it.
Regards
Gaetano Mendola
---(end of broadcast)---
TIP 7: don't forget to increase
Neil Conway wrote:
Gaetano Mendola wrote:
Right but we can create a new segment and use it too. I don't know how
these segments are used but I used to do it in the past, of course you
have
to create a memory manager that handle not ccntinuous segments.
The TelegraphCQ folks have already
(and/or arch) for source control, so that some developer groups
and also our system administrators could get some experience with it.
I good very start point is see if cvs2svn can handle the postgresql CVS without
errors.
Regards
Gaetano Mendola
---(end of broadcast
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Robert Treat wrote:
| On Friday 05 November 2004 07:48, Gaetano Mendola wrote:
|
|Neil Conway wrote:
| Gaetano Mendola wrote:
| Right but we can create a new segment and use it too. I don't know how
| these segments are used but I used to do
important here is the
client side and now that the win environment matter more then before, I have to
say that TortoiseSVN ( tortoisesvn.tigris.org ) is much better then WinCVS.
Regards
Gaetano Mendola
---(end of broadcast)---
TIP 9: the planner
home
page.
Regards
Gaetano Mendola
-BEGIN PGP SIGNATURE-
Version: GnuPG v1.2.5 (MingW32)
Comment: Using GnuPG with Thunderbird - http://enigmail.mozdev.org
iD8DBQFBi9bJ7UpzwH2SGd4RAgraAKCcNLaMJPPjVxfqRQ1yGG2+GssiAACeJFg3
zULofgK2ouUum3wNSjUmG3U=
=Bq/a
-END PGP SIGNATURE
is enforce the check between functions call
( I prefer even only this one), and at the same time provide a mutable
attribute for tables ( a mutable table can be updated even inside an
immutable contest ).
Regards
Gaetano Mendola
---(end of broadcast
Hi all,
the on line doc still show the 7.4.5.
Regards
Gaetano Mendola
---(end of broadcast)---
TIP 8: explain analyze is your friend
.
Regards
Gaetano Mendola
---(end of broadcast)---
TIP 9: the planner will ignore your desire to choose an index scan if your
joining column's datatypes do not match
marked as VOLATILE ( that IMHO is not so good... ).
Regards
Gaetano Mendola
---(end of broadcast)---
TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]
Hi all,
I don't know how much is effective or if it's applicable
to postgresql processe but it's an interesting article:
http://www.onlamp.com/pub/a/onlamp/2004/10/28/design_by_contract_in_c.html
Regards
Gaetano Mendola
---(end of broadcast)---
TIP
status marked as mutable. ( For example
you need to count how many time a const function was called ).
I think a clean solution is be able to declare a table as
mutable as well.
Am I completely wrong or out of mind ?
Regards
Gaetano Mendola
---(end of broadcast
Tom Lane wrote:
Gaetano Mendola [EMAIL PROTECTED] writes:
The fact that a non-volatile function can not perform
update is a good improvement but on the other side will
limit too much if I know what I'm doing.
I've got zero sympathy for this argument. It's been documented right
along
of dependencies
with other objects.
Regards
Gaetano Mendola
---(end of broadcast)---
TIP 6: Have you searched our list archives?
http://archives.postgresql.org
as
known-dead or known-good.
I found one.
Are you going to fix it for the 8.0 and/or back patch it ?
Regards
Gaetano Mendola
---(end of broadcast)---
TIP 4: Don't 'kill -9' the postmaster
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Gavin Sherry wrote:
| On Fri, 8 Oct 2004, Gaetano Mendola wrote:
|
|
|Gavin Sherry wrote:
| On Wed, 6 Oct 2004, Josh Berkus wrote:
|
| [snip]
|
|
| Of course, this is as true of functions as it will be of procedures. So half
| the functionality
city =
Regards
Gaetano Mendola
---(end of broadcast)---
TIP 5: Have you checked our extensive FAQ?
http://www.postgresql.org/docs/faqs/FAQ.html
Here http://www.sans.org/top20/#u9
are listed postgres vulnerability it's sad see that almost all
are related to third part components
Regards
Gaetano Mendola
---(end of broadcast)---
TIP 6: Have you searched our list archives?
http
Stephan Szabo wrote:
On Sat, 9 Oct 2004, Stephan Szabo wrote:
On Sat, 9 Oct 2004, Gaetano Mendola wrote:
Here http://www.sans.org/top20/#u9
are listed postgres vulnerability it's sad see that almost all
are related to third part components
I'd go further than sad and say irresponsible
Bruce Momjian wrote:
I just made some major Win32 modifications in the past few days. Would
you try Cygwin compile and see if the following warnings are removed and
the rest of the system builds OK?
Now that postgres 8.0 is win32 native is it still necessary support the cygwin ?
Regards
Gaetano
the world ( it could be wrong ) these two functions above have
the same signature, so the second declaration shall be not allowed, do you
want put also the formal parameters names in the function signature ?
Orrible.
Regards
Gaetano Mendola
---(end of broadcast
word,
but that suggestion seems not to have garnered any support.
I'm too for use the AS instead of '='.
Regards
Gaetano Mendola
---(end of broadcast)---
TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]
Anyone interested ?
Regards
Gaetano Mendola
Gaetano Mendola wrote:
Hi all,
in my development server running a 7.4.5 I can replicate
continuously this error:
ERROR: left link changed unexpectedly
I obtain this with a vacuum full:
test=# vacuum full verbose ua_user_data_exp;
INFO: vacuuming
Alvaro Herrera wrote:
On Tue, Oct 05, 2004 at 12:08:26AM +0200, Gaetano Mendola wrote:
Anyone interested ?
I saw the code involved, and I think the only way this can happen is if
the index file itself was corrupted by previous operation. How could
that happen elludes me; maybe a previous VACUUM
)))
! ereport(ERROR,
! (errcode(ERRCODE_NUMERIC_VALUE_OUT_OF_RANGE),
! errmsg(integer out of range)));
! PG_RETURN_INT32(result);
}
May be is a good idea postpone the division as second OR argument in order to
hope to avoid
it.
Regards
Gaetano Mendola
---(end
Gaetano Mendola
---(end of broadcast)---
TIP 4: Don't 'kill -9' the postmaster
[31356]: [1269-1] ERROR: XX000: left link changed
unexpectedly
Oct 1 21:35:38 porto postgres[31356]: [1269-2] LOCATION: _bt_pagedel, nbtpage.c:888
I don't care to fix the problem immediatelly, so if you want dig on it let me
know.
Regards
Gaetano Mendola
-BEGIN PGP SIGNATURE
me know.
Regards
Gaetano Mendola
---(end of broadcast)---
TIP 3: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to [EMAIL PROTECTED] so that your
message can get through to the mailing list cleanly
condition
is still there but with less chance to pops up.
Is it so dangerous teach the postmaster to solve this kind of problems without
a direct user intervention ?
Regards
Gaetano Mendola
On 9/30/2004 6:16 AM, Gaetano Mendola wrote:
Hi all,
I'm running postgres 7.4.5 on a linux box
Tom Lane wrote:
Gaetano Mendola [EMAIL PROTECTED] writes:
I'm running postgres 7.4.5 on a linux box, this morning I got this error on my logs:
WARNING: FlushRelationBuffers(exp_provider, 1836): block 1460 is referenced
(private 0, global 1)
ERROR: FlushRelationBuffers returned -2
Info
is a table that implement a materialized view so is
heavily updated by triggers.
Regards
Gaetano Mendola
---(end of broadcast)---
TIP 5: Have you checked our extensive FAQ?
http://www.postgresql.org/docs/faqs/FAQ.html
=
Regards
Gaetano Mendola
---(end of broadcast)---
TIP 9: the planner will ignore your desire to choose an index scan if your
joining column's datatypes do not match
(1.5.2?).
This is the check that I suggest to add recently :-(
See the thread x86_64 configure problem on hackers
You need to install the distutils, and how I wrote in that thread, it's
not clear that that module is installed by default when you install
python.
Regards
Gaetano Mendola
have python 1.5(1.5.2?).
This is the check that I suggest to add recently :-(
See the thread x86_64 configure problem on hackers
You need to install the distutils, and how I wrote in that thread, it's
not clear that that module is installed by default when you install
python.
Regards
Gaetano
Hi all,
I'm using the RSS on Mozilla Thundebird and I'm noticing that all
entries are with the date: 01/01/1970 other sites are not affected
by this issue.
Regards
Gaetano Mendola
---(end of broadcast)---
TIP 8: explain analyze is your friend
Gaetano Mendola wrote:
Hi all,
I'm using the RSS on Mozilla Thundebird and I'm noticing that all
entries are with the date: 01/01/1970 other sites are not affected
by this issue.
Of course I'm speaking about www.postgresql.org :-)
Watching at the two RSS:
http://www.postgresql.org/news.rss
http
.
Create your own plpgsql function and call it.
Regards
Gaetano Mendola
---(end of broadcast)---
TIP 6: Have you searched our list archives?
http://archives.postgresql.org
this by myself but for lack of time and lack of postgres
code knowledge I'm stuck.
Regards
Gaetano Mendola
---(end of broadcast)---
TIP 8: explain analyze is your friend
Andreas Pflug wrote:
Gaetano Mendola wrote:
I'd like to fix this by myself but for lack of time and lack of postgres
code knowledge I'm stuck.
What you want is
CREATE VIEW foo AS
SELECT p1, p2, bar('theValidParameter') as p3
FROM othertab;
GRANT ALL ON TABLE foo TO public;
and don't want
on V
2) Exceute permission + Security Definer attr on F.
this last point give to the user the possibility to execute F with any
aribitrary value, instead of only the values present on the view ( already
filtered ).
Regards
Gaetano Mendola
---(end of broadcast
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Joe Conway wrote:
| Gaetano Mendola wrote:
|
| python -c from distutils import * /dev/null 21 || (echo You
| need distutils installed; exit 1)
|
|
| Sorry for the delay -- things got busy around here all of a sudden.
|
| Attached is a version
Marc G. Fournier wrote:
In recognition of his role as lead developer on the internationalization
front, as well as his invaluble work in both the build and release
processes, Peter Eisentraut has been invited, and has accepted, to join
the Core Committee.
Good work, Peter.
Regards
Gaetano
ON foo
FOR EACH ROW EXECUTE PROCEDURE trigger_foo('field1');
insert into foo values ( 3 );
I got the error in the subject, it's like the EXECUTE open another contest and
forget that is inside a rule.
Any idea someone ?
Regards
Gaetano Mendola
-BEGIN PGP SIGNATURE-
Version: GnuPG v1.2.4
in a command string given to
EXECUTE. You probably need to set up an IF...ELSIF...ELSE...END IF
structure to get the value to put into the command string.
I can't because the combination are not a limited number.
Regards
Gaetano Mendola
---(end of broadcast
Hi all,
one year ago I did this post:
http://archives.postgresql.org/pgsql-admin/2003-04/msg00137.php
however I had no reply att all, do you know why there is not a
concept of: security definer on views too ?
If in that post I was not clear please let me know.
Regards
Gaetano Mendola
is removed the local variable shadow the formal
parameter. Some compilers do not warning you, IIRC the Digital had this funny omission,
( however you can miss the warning ) and hours of debugging are behind the corner.
I hope that Bruce change his mind...
Regards
Gaetano Mendola
Gaetano Mendola
---(end of broadcast)---
TIP 5: Have you checked our extensive FAQ?
http://www.postgresql.org/docs/faqs/FAQ.html
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Bruce Momjian wrote:
| Gaetano Mendola wrote:
|
|I had that argument a while ago with Bruce and lost :-) . It does horrible
|things to if/else constructs too. The workaround is to put a comment in the
|block. On the whole I agree with you, though. If I
on this, the only reason this feature is needed is to continue
to have a well table structure, see my last post.
Regards
Gaetano Mendola
---(end of broadcast)---
TIP 8: explain analyze is your friend
Joe Conway wrote:
Gaetano Mendola wrote:
Joe Conway wrote:
# python -c from distutils.sysconfig import get_python_lib as f;
import os; print
os.path.join(f(plat_specific=1,standard_lib=1),'config')
/usr/lib64/python2.3/config
Any other proposals? If not, any objections to the attached patch
Joe Conway wrote:
Gaetano Mendola wrote:
Joe Conway wrote:
What version of python comes with RH2.1?
1.5.2
In any case, the online documentation for python suggests that it is
reasonable to expect that distutils is already installed (by default
for python = 1.6, and by the user for python 1.5.2
Joe Conway wrote:
Gaetano Mendola wrote:
Joe Conway wrote:
I wasn't going to -- python's own docs say I shouldn't need to. From
the link above:
the Distutils work just fine with Python 1.5.2, and it is reasonable
(and expected to become commonplace) to expect users of Python 1.5.2
to download
with backward compatability.
One thing is emerging from this thread: the \xyzk functionality is overloaded.
Time to switch to something more human readable ?
Regards
Gaetano Mendola
---(end of broadcast)---
TIP 8: explain analyze is your friend
your customers then this information shall be stored in an
encrypted form. The bast way I found to accomplish this is using an
encrypted file system. Google for cryptoloop or if you are brave enough
look for StegFS.
Regards
Gaetano Mendola
---(end of broadcast
/config
Any other proposals? If not, any objections to the attached patch?
No one, we have to check also for the presence of distutils package installation.
It's not installed by default and I was bitten by it during the RPM building for
RH AS 2.1
Regards
Gaetano Mendola
a glitch.
Regards
Gaetano Mendola
---(end of broadcast)---
TIP 9: the planner will ignore your desire to choose an index scan if your
joining column's datatypes do not match
the opportunity to do this, and I look forward to doing what I can to
improve PostgreSQL over the next year.
-Neil
Congratulation.
Regards
Gaetano Mendola
---(end of broadcast)---
TIP 9: the planner will ignore your desire to choose an index scan
. So far my thoughts
are to classify by Architecture,OS+Version,Compiler+Version.
Thoughts?
This can be a good model to follow:
http://boost.sourceforge.net/regression-logs/
Regards
Gaetano Mendola
---(end of broadcast)---
TIP 1: subscribe
or so.
Feel free to bump up PGSTAT_ACTIVITY_SIZE to 1000 or so in
src/include/pgstat.h (and yes, this is already done for 8.0).
I didn't see this changement in the 8.0 release note, don't you think shall
be added ?
Regards
Gaetano Mendola
---(end of broadcast
...
Isn't enough have the related costs for table spaces ?
Regards
Gaetano Mendola
---(end of broadcast)---
TIP 6: Have you searched our list archives?
http://archives.postgresql.org
- New fields must be added at the end.
Regards
Gaetano Mendola
-BEGIN PGP SIGNATURE-
Version: GnuPG v1.2.4 (MingW32)
Comment: Using GnuPG with Thunderbird - http://enigmail.mozdev.org
iD8DBQFBOt717UpzwH2SGd4RAuuZAJwKkDVpwgRNI0vQJ4TC7qllQjH5XgCgmrKv
kqwKVVO3ha+FUsQHggyfyvU=
=z9y4
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Tom Lane wrote:
| Gaetano Mendola [EMAIL PROTECTED] writes:
|
|| ERROR: invalid string enlargement request size 1476395004
|| DEBUG: AbortCurrentTransaction
|| WARNING: AbortTransaction and not in in-progress state
|| ERROR: could not send data
...
However I'm with Tom Lane, this feature have a big impact on the code and
give a not so big improvement.
Regards
Gaetano Mendola
---(end of broadcast)---
TIP 6: Have you searched our list archives?
http://archives.postgresql.org
. just curious.
No IIRC. The core doesn't think this is a valid feature.
I had in the past my reasons to ask for it too. If you
have yours may be...
Regards
Gaetano Mendola
---(end of broadcast)---
TIP 1: subscribe and unsubscribe commands go to [EMAIL
that _don't_ forcibly have an order, because sets
are unordered.
Means the order that \d show the columns ( for example ).
Regards
Gaetano Mendola
---(end of broadcast)---
TIP 6: Have you searched our list archives?
http
Hi all,
now that Apache Portable Runtime was release why don't
use it on Postgres?
Regards
Gaetano Mendola
---(end of broadcast)---
TIP 7: don't forget to increase your free space map settings
Tom Lane wrote:
Gaetano Mendola [EMAIL PROTECTED] writes:
now that Apache Portable Runtime was release why don't
use it on Postgres?
The sense of the question is backwards. Why *should* we use it?
In order to avoid all the annoyance that someone else had in
write code portable. I mean, how much
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
I don't see the last post about the issue I had
and that was solved ( due I think to last days problems),
I post it here again:
Tom Lane wrote:
| Gaetano Mendola [EMAIL PROTECTED] writes
Christopher Browne wrote:
... And since APR isn't BSD licensed, that would probably cause a
problem.
They are changin license for APR and I'll be not surprised if they
adopth the BSD one.
Regards
Gaetano Mendola
---(end of broadcast)---
TIP 3
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Tom Lane wrote:
| Gaetano Mendola [EMAIL PROTECTED] writes:
|I don't know if APR provide a spin lock mechanism,
|
|
| You don't even know that, but you're confident that we can throw away
| our spinlock work and use APR anyway. You're wasting our time
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Hi all,
what is that: myGeek balance authentication page ?
Regards
Gaetano Mendola
-BEGIN PGP SIGNATURE-
Version: GnuPG v1.2.4 (MingW32)
Comment: Using GnuPG with Thunderbird - http://enigmail.mozdev.org
iD8DBQFBOG3A7UpzwH2SGd4RAkfDAJ95/Y
Jan Wieck wrote:
On 9/1/2004 9:02 PM, Gaetano Mendola wrote:
Jan Wieck wrote:
Which is another point I was about to ask. How do these people,
running those huge and horribly important databases, ever test a
single application change? Or any schema changes for that matter. Do
they really
any idea on what could be the reason ?
Regards
Gaetano Mendola
-BEGIN PGP SIGNATURE-
Version: GnuPG v1.2.4 (MingW32)
Comment: Using GnuPG with Thunderbird - http://enigmail.mozdev.org
iD8DBQFBNlh77UpzwH2SGd4RAqfoAJ4zEPgG/0Yr8YTKN+PpbYQvbU7TigCggQ+3
ie8oxH9jFgFDDMlZfNnKj4w=
=5epB
-END
after an alter
schema operation.
Regards
Gaetano Mendola
---(end of broadcast)---
TIP 2: you can get off all lists at once with the unregister command
(send unregister YourEmailAddressHere to [EMAIL PROTECTED])
Tom Lane wrote:
Gaetano Mendola [EMAIL PROTECTED] writes:
ERROR: invalid string enlargement request size 1476395004
DEBUG: AbortCurrentTransaction
WARNING: AbortTransaction and not in in-progress state
ERROR: could not send data to client: Broken pipe
PANIC: error during error recovery
Hi all,
today I tried this tool:
http://www-106.ibm.com/developerworks/linux/library/l-ccache.html
and the second full compilation, after a make clean
took: 47 seconds. Amazing.
Regards
Gaetano Mendola
---(end of broadcast)---
TIP 4: Don't 'kill -9
to postgresql
development, having seen some proprietary database becoming Open Source
who never know ?
Regards
Gaetano Mendola
-BEGIN PGP SIGNATURE-
Version: GnuPG v1.2.4 (MingW32)
Comment: Using GnuPG with Thunderbird - http://enigmail.mozdev.org
iD8DBQFBL3tR7UpzwH2SGd4RAiF9AJ0U
?
Regards
Gaetano Mendola
-BEGIN PGP SIGNATURE-
Version: GnuPG v1.2.4 (MingW32)
Comment: Using GnuPG with Thunderbird - http://enigmail.mozdev.org
iD8DBQFBL6Hk7UpzwH2SGd4RAtraAJ4gLV3InpVdgtjhyK1Xaoe0f9Et/gCffzDq
WhQakLMGcB+in0H2qDV7qmY=
=/aUP
-END PGP SIGNATURE
with
the same level of caution as you would a new product.
What about: ... Unix like platforms ...
Regards
Gaetano Mendola
---(end of broadcast)---
TIP 7: don't forget to increase your free space map settings
: Python Makefile not found
error: Bad exit status from /var/tmp/rpm-tmp.56347 (%build)
Regards
Gaetano Mendola
---(end of broadcast)---
TIP 3: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to [EMAIL
Devrim GUNDUZ wrote:
Hi,
On Wed, 25 Aug 2004, Gaetano Mendola wrote:
anyone succesfull create all the rpm for RH AS 2.1 ?
I was able to do it using the srpms for RH9 but I did
it with --define 'python 0'. Any idea on how to obtain also
the postgresql-python.rpm ?
Without 'pyhton 0
? I'm seeing that with --enable-debug only the
option -g is passed to the compiler and the option -O2 is
still there, is it not better compile with -O0 if you are
going to debug it?
Regards
Gaetano Mendola
---(end of broadcast)---
TIP 6: Have you
Tom Lane wrote:
Gaetano Mendola [EMAIL PROTECTED] writes:
Christopher Kings-Lynne wrote:
./configure --enable-debug
Is this enough? I'm seeing that with --enable-debug only the
option -g is passed to the compiler and the option -O2 is
still there, is it not better compile with -O0 if you
Hi all,
I knew there was an evaluation on the futex vs spinlock,
and Josh Berkus on IRC told me that there was only a 20%
performance increase, is this increase to throw away ?
Regards
Gaetano Mendola
---(end of broadcast)---
TIP 8: explain analyze
Hi all,
I don't want be a pain in the but now that 7.4.5 is
officially out I think is time to change the version doc on:
http://www.postgresql.org/docs/7.4/interactive/index.html
Regards
Gaetano Mendola
---(end of broadcast)---
TIP 2: you can
Hi all,
in order to debug step by step the postmaster,
just to understand better the code, is it enough
to compile it after having exported:
CFLAGS='-O0 -g' ?
do you have any hint and/or tips ?
BTW what do you use for this task ?
Regards
Gaetano Mendola
---(end
Bruce Momjian wrote:
Gaetano Mendola wrote:
Hi all,
I don't want be a pain in the but now that 7.4.5 is
officially out I think is time to change the version doc on:
http://www.postgresql.org/docs/7.4/interactive/index.html
I have updated the FAQ.
??
However I see now the right
/2004-08/msg00704.php
and my success: http://archives.postgresql.org/pgsql-hackers/2004-08/msg00852.php
Am I right ?
Regards
Gaetano Mendola
---(end of broadcast)---
TIP 5: Have you checked our extensive FAQ?
http://www.postgresql.org
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Tom Lane wrote:
| Gaetano Mendola [EMAIL PROTECTED] writes:
|
|I think we should just call gettimeofday() at postmaster start and store
|it somewhere.
|
|
|Isn't the shared memory a good place ?
|
|
| Depends. Do you want to reset it during a backend
or something.
|
| However, adding a new function requires a re-initdb, so it's quite
| unlikely this will be in for 8.0.
Even if the re-initdb was not necessary we are in beta, and usualy the
new features are not allowed.
Regards
Gaetano Mendola
-BEGIN PGP SIGNATURE-
Version: GnuPG v1.2.4 (MingW32
Tom Lane wrote:
I'd like to see more than one person requesting this (and with solider
rationales) before it gets added to TODO. If I wanted to be picky I
would suggest that knowledge of the server start time might be useful
information to an attacker. It would for instance narrow down the
more difficult retrieve this value.
Regards
Gaetano Mendola
---(end of broadcast)---
TIP 9: the planner will ignore your desire to choose an index scan if your
joining column's datatypes do not match
-ip.com/rpm745.htm
Regards
Gaetano Mendola
-BEGIN PGP SIGNATURE-
Version: GnuPG v1.2.4 (MingW32)
Comment: Using GnuPG with Thunderbird - http://enigmail.mozdev.org
iD8DBQFBJjZ17UpzwH2SGd4RAivQAJ9LNWsjYMxYG7dK29PYGVbUxheGOACgriVe
mzWhNZxy6zRIdHfVArBJjAA=
=rco3
-END PGP SIGNATURE
think we should just call gettimeofday() at postmaster start and store
it somewhere.
Isn't the shared memory a good place ?
Regards
Gaetano Mendola
---(end of broadcast)---
TIP 7: don't forget to increase your free space map settings
Hi all,
reading this article:
http://www.devx.com/dbzone/Article/20743
I notice on page 2:
New versions of PostgreSQL support standard row-level
locking as an option, but MVCC is the preferred method
What this does mean ?
Regards
Gaetano Mendola
---(end of broadcast
Gavin Sherry wrote:
On Wed, 18 Aug 2004, Gaetano Mendola wrote:
Gavin Sherry wrote:
On Wed, 18 Aug 2004, Gaetano Mendola wrote:
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Hi all,
now that we have the tablespace support don't you think that
each tablespace needs his own costs instead
that windows version is out I believe a platform
indipendent way is required. Any objection to add it ?
Regards
Gaetano Mendola
---(end of broadcast)---
TIP 7: don't forget to increase your free space map settings
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Hi all,
now that we have the tablespace support don't you think that
each tablespace needs his own costs instead of a system wide
one ?
I searched in the archives and on the TODO list without success.
Regards
Gaetano Mendola
-BEGIN PGP SIGNATURE
of change the default port.
I did it as usual changing it in postgresql.conf but that parameter
is overriden by:
PGPORT=5432
present on the start up script.
There is any reason to still pass this parameter to postmaster ?
Regards
Gaetano Mendola
---(end of broadcast
101 - 200 of 411 matches
Mail list logo