Hi,
I'm playing with wal parameters and found that wal_sync_method =
open_sync enormously enhance the performance on my machine. Without it
(using default fsync) I got only 90 tps at the best using pgbench (-s
2). However if I set wal_sync_method = open_sync, I get ~200 tps. I
have checked
On Fri, Apr 27, 2001 at 08:45:25PM -0700, Ian Lance Taylor wrote:
This patch adds support for %TYPE in CREATE FUNCTION argument and
return types.
%TYPE is already supported by PL/pgSQL when declaring variables.
However, that does not help with the argument and return types in
CREATE
Slashdot just announced that SAP has released the souce for SAP DB under
GPL. Not sure what this mean, or what people think, but I thought the
hackers list might want to know.
http://slashdot.org/developers/01/04/28/016220.shtml
Dominic,
I like your idea. One of the benefits SQLServer 2000 is that I can assign a
role in the database to a NT group. At that point, all I have to do is add
a user to the group to be able to access that database. Would you solution
include this scenario? This lets me assign all the
What about incremental backup ?
Bruce Momjian [EMAIL PROTECTED] ÓÏÏÂÝÉÌ/ÓÏÏÂÝÉÌÁ × ÎÏ×ÏÓÔÑÈ
ÓÌÅÄÕÀÝÅÅ: [EMAIL PROTECTED]">news:[EMAIL PROTECTED]...
WAL was a difficult feature to add to 7.1. Currently, it is only used
as a performance benefit, but I expect it will be used in the future to
Over the past few months there've been a number of requests for an
interactive type documentation setup like the folks at php.net have.
Great to add to the documentation, but I hope the PostgreSQL project
doesn't take it so far as to make the primary documentation
interactive. A
You actually almost have it right.
You are passing VARDATA(user) to crypt, this is wrong.
You must do something like this:
int ulen = VARSIZE(user)-VARHDRSZ;
char utmp[ulen+]; // This works in newer GCC, cool.
memcpy(utmp,VARDATA(user), len);
utmp[ulen]=0;
crypted=crypt(utmp,salt);
Strings
Hi guys,
I've used the open source SAPDB and the performance is pretty damned
impressive. However, 'open source' in application to it is somewhat
deceptive, since you have to make it with SAP's proprietary build
tools/environment.
In my opinion, however, it would be worth closely auditing SAP
Hi guys,
I've used the open source SAPDB and the performance is pretty damned
impressive. However, 'open source' in application to it is somewhat
deceptive, since you have to make it with SAP's proprietary build
tools/environment.
In my opinion, however, it would be worth closely
Hi,
I'm new to postgresql...but so far i love it...after working with companies
that have spent millions of dollars on the big O i must say pgsql is a
breath of fresh air...nice work to all who contributed.
I'm looking at building a fault tolerant/failover database [hot standby]
system using
I downloaded it. The directories are two characters in length, the
files are numbers, and it is a mixture of C++, Python, and Pascal. Need
I say more. :-)
1.) What is wrong with a mixture of C++, Python and Pascal? Nothing IMHO.
2.) The directory structure is probably the consequence of
11 matches
Mail list logo