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
Curt Sampson wrote:
> 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
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,
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.
>
> N
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, 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 N
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 reco
> 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.
Merli
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) whi
"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.
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
Tom Lane <[EMAIL PROTECTED]> writes:
> Kevin Brown <[EMAIL PROTECTED]> writes:
> > Hmm...any chance, then, of giving aggregate functions a means of
> > asking which table(s) and column(s) the original query referred to so
> > that it could do proper optimization on its own?
>
> You can't usefully
> -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 FreeB
"D'Arcy J.M. Cain" <[EMAIL PROTECTED]> writes:
> 100Mb instead of 100Mb -->1000Mb. I tried mounting with and without the TCP
> option and it seemed to act the same but it was better than before. Now it
> doesn't crash but trying to load a large table hangs. It gets to a point
> where it is ca
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 se
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 broadcast)--
"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 b
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 http://sources.r
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 blesse
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
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 indicate
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
> n
On Sat, 2003-02-01 at 00:46, Dann Corbit wrote:
> MySQL for Win32 has no connection whatsoever with anything from Cygwin
> or Mingw
Excellent. Thanks for humoring me. ;)
--
Greg Copeland <[EMAIL PROTECTED]>
Copeland Computer Consulting
---(end of broadcast)-
Kevin Brown <[EMAIL PROTECTED]> writes:
> Hmm...any chance, then, of giving aggregate functions a means of
> asking which table(s) and column(s) the original query referred to so
> that it could do proper optimization on its own?
You can't usefully do that without altering the aggregate paradigm.
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
non-Postgres code ... everyone
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 t
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, to
Tom Lane wrote:
> Sean Chittenden <[EMAIL PROTECTED]> writes:
> > Now, there are some obvious problems:
>
> You missed the real reason why this will never happen: it completely
> kills any prospect of concurrent updates. If transaction A has issued
> an update on some row, and gone and modified t
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 U
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:
> [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 sh
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, which
> 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
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 wi
On Fri, Jan 31, 2003 at 06:51:49PM -0500, Andrew Sullivan wrote:
> On Fri, Jan 31, 2003 at 08:21:21PM +0100, Kurt Roeckx wrote:
> > What do you mean with "compatibility addresses"? I don't know of
> > any such thing.
>
> | 96-bits | 32-bits|
>
Why on earth are you using a CVS version!?!?!?!
Chris
On Fri, 31 Jan 2003, wade wrote:
> Hello,
> We recently upgraded a project from 7.2 to 7.3.1 to make use of some of
> the cool new features in 7.3. The installed version is CVS stable from
> yesterday. However, we noticed a major performa
I'll volunteer to do some docs...
Chris
On Fri, 31 Jan 2003, Oleg Bartunov wrote:
> Hi there,
>
> we've discussed with Teodor about adding ranking feature to tsearch and
> seems we've found a way to do that. New version of tsearch will have
> ranking supports, friendly configurability, linguist
On Saturday 01 February 2003 01:26, Lamar Owen wrote:
> On Friday 31 January 2003 03:21, Bruce Momjian wrote:
> > Man, I go away for one day, and look what you guys get into. :-)
>
> No duh. Whew.
>
> > Lastly, SRA just released _today_ their first Win32 port of PostgreSQL,
> > and it is _threade
38 matches
Mail list logo
