IMHO, replication, performance improvements, cross-db queries, etc is
much better use of time than Windows port.
Because you don't use Windows. On a personal level, I couldn't agree more. But
I have been in a project where they chose MySQL because it had to run on
Windows. I would like to be
I think I have sorted through the confusion.
Looks like the only thing cygwin might be used for is a client. Here's what
the manual that comes with the 4.0.9gamma source says:
There are two versions of the MySQL command-line tool: Binary Description
mysql Compiled on native Windows,
Try it with FreeBSD's UFS and FreeBSD 5.0's new UFS2 filesystems perhaps -
or I could!
Chris
On 1 Feb 2003, Greg Copeland wrote:
On Fri, 2003-01-31 at 14:36, Dave Page wrote:
I intend to run the tests on a Dual PIII 1GHz box, with 1Gb of Non-ECC
RAM and a 20Gb (iirc) IDE disk. I will run
Kurt Roeckx wrote:
[SIO] [Option Start] If _POSIX_SYNCHRONIZED_IO is defined, the
fsync() function shall force all currently queued I/O operations
associated with the file indicated by file descriptor fildes to the
synchronized I/O completion state. All I/O operations shall
Curt Sampson wrote:
On Fri, 31 Jan 2003, Shridhar Daithankar[EMAIL PROTECTED] wrote:
Besides file locking is implemented using setgid bit on most unices. And
everybody is free to do what he/she thinks right with it.
I don't believe it's implemented with the setgid bit on most Unices. As
Christopher Kings-Lynne [EMAIL PROTECTED] writes:
Why on earth are you using a CVS version!?!?!?!
I assume he meant tip of REL7_3 branch --- which is a perfectly
reasonable thing to install, even if there are still a few fixes
to go before we call it 7.3.2.
regards, tom
On Sat, Feb 01, 2003 at 08:15:17AM -0800, Kevin Brown wrote:
Kurt Roeckx wrote:
[SIO] [Option Start] If _POSIX_SYNCHRONIZED_IO is defined, the
fsync() function shall force all currently queued I/O operations
associated with the file indicated by file descriptor fildes to the
Tom Lane wrote:
Kevin Brown [EMAIL PROTECTED] writes:
So if we wanted to make use of mandatory locks, we'd have to refrain
from using flock().
We have no need for mandatory locks; the advisory style will do fine.
This is true because we have no desire to interoperate with any
In CVS tip, create an empty database. pg_dump it. Try to restore the
dump. The first thing it does is
REVOKE ALL ON SCHEMA public FROM PUBLIC;
which fails with
ERROR: dependent privileges exist (use CASCADE to revoke them too)
This message seems incorrect --- what is a dependent privilege,
Kurt Roeckx wrote:
On Sat, Feb 01, 2003 at 08:15:17AM -0800, Kevin Brown wrote:
Kurt Roeckx wrote:
[SIO] [Option Start] If _POSIX_SYNCHRONIZED_IO is defined, the
fsync() function shall force all currently queued I/O operations
associated with the file indicated by file
On Sat, 2003-02-01 at 00:34, Adam Haberlach wrote:
On Sat, Feb 01, 2003 at 12:27:31AM -0600, Greg Copeland wrote:
On Fri, 2003-01-31 at 14:36, Dave Page wrote:
I intend to run the tests on a Dual PIII 1GHz box, with 1Gb of Non-ECC
RAM and a 20Gb (iirc) IDE disk. I will run on Windows
On Sat, Feb 01, 2003 at 11:30:17AM -0600, Greg Copeland wrote:
On Sat, 2003-02-01 at 00:34, Adam Haberlach wrote:
On Sat, Feb 01, 2003 at 12:27:31AM -0600, Greg Copeland wrote:
On Fri, 2003-01-31 at 14:36, Dave Page wrote:
Please go with XFS or ext3. There are a number of blessed and
On Saturday 01 February 2003 13:09, Tom Lane wrote:
Very bizarre. Looks like the last page it read was block 104
(851968/8192) in file /source/data/cert/base/16556/17063. Could you
provide a formatted dump of that page? I'm partial to pg_filedump which
you can get from
D'Arcy J.M. Cain [EMAIL PROTECTED] writes:
That's a 4.7 MB file. The dump might be quite huge.
I really just want to see the dump of that one page, and maybe the pages
before and after it for comparison's sake.
regards, tom lane
---(end of
What was the query it failed on, exactly? That last page it read
seems to be an empty index page --- it should have moved on to the
next index page, I'd think, rather than doing anything that could
hang up.
regards, tom lane
---(end of
On Saturday 01 February 2003 14:00, Tom Lane wrote:
What was the query it failed on, exactly? That last page it read
seems to be an empty index page --- it should have moved on to the
next index page, I'd think, rather than doing anything that could
hang up.
Here's the log. As you can see,
-Original Message-
From: Christopher Kings-Lynne [mailto:[EMAIL PROTECTED]]
Sent: 01 February 2003 12:40
To: Greg Copeland
Cc: Dave Page; PostgresSQL Hackers Mailing List; Tom Lane
Subject: Re: [HACKERS] Win32 port powerfail testing
Try it with FreeBSD's UFS and FreeBSD 5.0's
mysql does not have cygwin in the server, either static or otherwise.
We looked at the code a while back and confirmed this. mysql has a much
smaller code base than pg.
If they did, it would be a very strange deal because you can link your
app directly to the mysql server (for 200$...non GPL)
I'm not sure what version of MySQL you were looking at, but that's
certainly doesn't seem to be the case anymore. I just checked: MySQL
4.0.9 has ~435,000 LOC, PgSQL from CVS HEAD has ~372,000.
Hmm, you got me there, tho this was some time back from the last version
of the 3.x series.
Merlin
On Saturday 01 February 2003 14:43, Tom Lane wrote:
D'Arcy J.M. Cain [EMAIL PROTECTED] writes:
Here's the log. As you can see, nothing was logged after the COPY
command.
What else was going on? As far as I can see, the code never does a
semop unless it's waiting for some other backend
D'Arcy J.M. Cain [EMAIL PROTECTED] writes:
On Saturday 01 February 2003 14:43, Tom Lane wrote:
What else was going on? As far as I can see, the code never does a
semop unless it's waiting for some other backend process.
Nothing except the standard background processes are running.
More and
On Sat, Feb 01, 2003 at 15:21:24 -0500,
Greg Stark [EMAIL PROTECTED] wrote:
Tom Lane [EMAIL PROTECTED] writes:
That just means you need some way for aggregates to declare which records they
need. The only values that seem like they would be useful would be first
record last record and all
On Fri, 31 Jan 2003, Kurt Roeckx wrote:
It's a good things that the socket interface can actually work
with all protocol! It doesn't only work with AF_INET, but also
AF_UNIX, and probably others. It's a good things that things
like socket(), bind(), connect() don't need to be replaced by
On Fri, 31 Jan 2003, Tom Lane wrote:
Antti Haapala [EMAIL PROTECTED] writes:
And from SunOS 5.8 flock
Locks are on files, not file descriptors. That is, file
descriptors duplicated through dup(2) or fork(2) do not
result in multiple instances of a lock, but
On Fri, 31 Jan 2003, mlw wrote:
. There are always issues with file locking across various
platforms. I recall reading about mmap issues across NFS a while ago...
Postgres uses neither of these, IIRC, so that should be fine. (Actually,
postgres does effectively use mmap for shared memory on
On Sat, 1 Feb 2003, Peter Eisentraut wrote:
Curtis Faith writes:
a) Running as a service is important as this the way NT/2000
administrators manage server tasks. The fact that PostgreSQL's Cygwin
emulation doesn't do this is very indicative of inferior Windows
support.
No, it is
Curt Sampson wrote:
snip
What I'm hearing here is that all we really need to do to compete with
MySQL on Windows is to make the UI a bit slicker. So what's the problem
with someone building, for each release, a set of appropriate
binaries, and
someone making a slick install program that will
Curt Sampson [EMAIL PROTECTED] wrote:
At any rate, it seems to me highly unlikely that, since the child has
the *same* descriptor as the parent had, that the lock would
disappear.
It depends on the lock function. After fork():
o with flock() the lock continues to be held, but will be
28 matches
Mail list logo
