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
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|
>
> 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, which
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
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
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
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
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
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
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
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
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
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.
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)-
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
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 indicate
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 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 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
"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
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)--
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
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
"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
> -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
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
> 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
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
"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 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
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,
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, 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
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
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
38 matches
Mail list logo
