Re: [HACKERS] Time to move on...

2002-11-15 Thread Mark Pritchard
Hey Thomas, Although we have never corresponded, I just wanted to say thank you to yourself and all the other hackers who have devoted their time voluntarily to PostgreSQL. It really is appreciated. Cheers Mark Pritchard On Fri, 15 Nov 2002 17:38, Thomas Lockhart wrote: > Just a quick n

Re: [HACKERS] @(#) Mordred Labs advisory 0x0001: Buffer overflow in

2002-08-20 Thread Mark Pritchard
On Tue, 20 Aug 2002 23:48, Greg Copeland wrote: > On Tue, 2002-08-20 at 00:35, Dann Corbit wrote: > > Most computer virus problems are caused by buffer overrun. Someone > > decided it wasn't very important. > > This is true. IMO, it is extremely arrogant to ignore a buffer overrun > and announce

Re: [HACKERS] @(#) Mordred Labs advisory 0x0001: Buffer overflow in

2002-08-19 Thread Mark Pritchard
On Tue, 20 Aug 2002 15:35, Dann Corbit wrote: > Most computer virus problems are caused by buffer overrun. Someone > decided it wasn't very important. > > Some computer viruses have caused billions of dollars in damage. Sounds > important to me. > > "Please try our database. Someday, we hope to

Re: [HACKERS] @(#) Mordred Labs advisory 0x0001: Buffer overflow in

2002-08-19 Thread Mark Pritchard
On Tue, 20 Aug 2002 15:22, Neil Conway wrote: > I'd say the two issues are pretty different. IMHO, buffer overruns and > similar security problems are just a special class of software bug > (it's interesting to note that most of the buffer overruns have been > found in the less-maintained parts of

Re: [HACKERS] @(#) Mordred Labs advisory 0x0001: Buffer overflow in

2002-08-19 Thread Mark Pritchard
On Tue, 20 Aug 2002 13:40, Justin Clift wrote: [snip] > For example, thinking about something like the various ISP's around who > host PostgreSQL databases; how much effort would it take to fix the > vulnerabilities that let someone with remote access, but no ability to > run a "trusted" language,

Re: [HACKERS] Index Scans become Seq Scans after VACUUM ANALYSE

2002-04-18 Thread Mark Pritchard
Indeed - I had a delayed post (sent from the wrong email address) which mentioned that the cache is obviously at play here. I still find it amazing that the file system would cache 2gb :) The numbers are definitely correct though...they are actually the second set. I'm running a test with a large

Re: [HACKERS] Index Scans become Seq Scans after VACUUM ANALYSE

2002-04-18 Thread Mark Pritchard
y, I can't rip memory out of this box as I don't have exclusive access. On Thu, 2002-04-18 at 11:49, Mark Pritchard wrote: > I threw together the attached program (compiles fine with gcc 2.95.2 on > Solaris 2.6 and egcs-2.91.66 on RedHat Linux 6.2) and ran it a few > times. Dat

Re: [HACKERS] Index Scans become Seq Scans after VACUUM ANALYSE

2002-04-17 Thread Mark Pritchard
I threw together the attached program (compiles fine with gcc 2.95.2 on Solaris 2.6 and egcs-2.91.66 on RedHat Linux 6.2) and ran it a few times. Data is below. Usual disclaimers about hastily written code etc :) Machine = ghoul (generic intel, 384mb ram, dual p3-800, ide disk running dma) Seque

Re: [HACKERS] Client/Server compression?

2002-03-14 Thread Mark Pritchard
You can get some tremendous gains by compressing HTTP sessions - mod_gzip for Apache does this very well. I believe SlashDot saves in the order of 30% of their bandwidth by using compression, as do sites like http://www.whitepages.com.au/ and http://www.yellowpages.com.au/ The mod_gzip trick is

Re: [HACKERS] PQstatus() detect change in connection...

2001-10-17 Thread Mark Pritchard
. Perhaps those infinitely more knowledgeable on the list have a better/more correct way of doing things? Cheers, Mark Pritchard > -Original Message- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED]]On Behalf Of Matthew Hagerty > Sent: Thursday, 18 October 2001 10:47 AM

Re: [HACKERS] Feature suggestion: Postgresql binding to one IP?

2001-10-04 Thread Mark Pritchard
ers if one dies I run postgres on a box with two interfaces, and I only want it to bind to a single one: # start postgres nohup > /dev/null su -c '/usr/local/pgsql/bin/postmaster -h 10.4.0.1 -i -D /usr/local/pgsql/data > /usr/local/pgsql/log/server.log 2>&1' pos

Re: [HACKERS] [Pgreplication-general] GreatBridge ceases operations

2001-09-06 Thread Mark Pritchard
http://www.yellowpages.com.au and http://www.whitepages.com.au (two of the most popular sites in Australia). By way of a cc to the PostgreSQL hackers list, this offer goes out to anyone else who was effected by the GreatBridge shutdown. Cheers, Mark Pritchard Senior Technical Architect Tangent Systems Aust

RE: [HACKERS] MS interview

2001-08-14 Thread Mark Pritchard
iness guy than a couple of dozen people all over the world. Remember, these are the people that still believe that all programmers are alike and can just be swapped around on projects without any impact. Hopefully, RedHat's involvement will boost the mindshare and image of PostgreSQL and I

RE: [HACKERS] Client Side Connection Pooling

2001-08-07 Thread Mark Pritchard
y.com suggests you may mean a transaction commit may return multiple connections to the pool? I really have no idea what you mean :) Cheers, Mark Pritchard ---(end of broadcast)--- TIP 6: Have you searched our list archives? http://www.postgresql.org/search.mpl

[HACKERS] PostgreSQL and replication

2001-06-07 Thread Mark Pritchard
Hi all, I've been using PostgreSQL for a couple of high performance projects recently and have been extremely impressed - much kudos to all involved in bringing it this far. One thing that is limiting is the lack of fault tolerance and load balancing. Anyway, I've recently started lurking on the