Re: [HACKERS] 2-phase commit

2003-10-10 Thread Dann Corbit
Why not apply the effort to something already done and compatibly licensed? This: http://dog.intalio.com/ots.html Appears to be a Berkeley style licensed: http://dog.intalio.com/license.html Transaction monitor. Overview The OpenORB Transaction Service is a very scalable transaction monitor

Re: [HACKERS] 2-phase commit

2003-10-10 Thread Dann Corbit
Here is a sourceforge version of the same thing http://openorb.sourceforge.net/ -Original Message- From: Dann Corbit Sent: Friday, October 10, 2003 9:38 PM To: Christopher Browne; [EMAIL PROTECTED] Subject: Re: [HACKERS] 2-phase commit Why not apply the effort to something

Re: [HACKERS] Dreaming About Redesigning SQL

2003-10-07 Thread Dann Corbit
-Original Message- From: Seun Osewa [mailto:[EMAIL PROTECTED] Sent: Friday, October 03, 2003 11:52 AM To: [EMAIL PROTECTED] Subject: [HACKERS] Dreaming About Redesigning SQL Hi, This is for relational database theory experts on one hand and imlementers of real-world

Re: [HACKERS] 2-phase commit

2003-09-29 Thread Dann Corbit
-Original Message- From: Bruce Momjian [mailto:[EMAIL PROTECTED] Sent: Monday, September 29, 2003 7:10 AM To: Marc G. Fournier Cc: Hiroshi Inoue; Tom Lane; 'Zeugswetter Andreas SB SD'; 'Andrew Sullivan'; [EMAIL PROTECTED] Subject: Re: [HACKERS] 2-phase commit Marc G. Fournier

Re: [HACKERS] 2-phase commit

2003-09-29 Thread Dann Corbit
Commercial systems use: Mainframe: CICS UNIX: Tuxedo Encina Win32: MTS DEC/COMPAQ/HP: ACMS Probably lots of others that I have never heard about. ---(end of broadcast)--- TIP 5: Have you checked our extensive FAQ?

Re: [HACKERS] 2-phase commit

2003-09-29 Thread Dann Corbit
A really nice overview of how various transaction managers are modeled: http://www.ti5.tu-harburg.de/Lecture/99ws/TP/06-OverviewOfTPSystemsAndPr oducts/sld001.htm ---(end of broadcast)--- TIP 3: if posting/reading through Usenet, please send an

Re: [HACKERS] Threads vs Processes

2003-09-26 Thread Dann Corbit
-Original Message- From: Tom Lane [mailto:[EMAIL PROTECTED] Sent: Friday, September 26, 2003 9:27 AM To: Bruce Momjian Cc: Shridhar Daithankar; [EMAIL PROTECTED]; [EMAIL PROTECTED] Subject: Re: [HACKERS] Threads vs Processes Bruce Momjian [EMAIL PROTECTED] writes: One

Re: [HACKERS] Maximum table size

2003-09-09 Thread Dann Corbit
-Original Message- From: Jeroen Ruigrok/asmodai [mailto:[EMAIL PROTECTED] Sent: Tuesday, September 09, 2003 1:23 PM To: Bruce Momjian Cc: Tatsuo Ishii; [EMAIL PROTECTED]; [EMAIL PROTECTED] Subject: Re: [HACKERS] Maximum table size -On [20030909 20:32], Bruce Momjian ([EMAIL

Re: [HACKERS] pgsql vc++|win32

2003-09-08 Thread Dann Corbit
-Original Message- From: luke [mailto:[EMAIL PROTECTED] Sent: Monday, September 08, 2003 9:16 AM To: Hackers Subject: [HACKERS] pgsql vc++|win32 Hi guys, I'm planning with some friends to develop a port of pgsql, to native win32 environment using vc++; We read about MingW

Re: [HACKERS] Win32 native port

2003-09-04 Thread Dann Corbit
Cygwin requires a license for commercial use. -Original Message- From: Peter Eisentraut [mailto:[EMAIL PROTECTED] Sent: Thursday, September 04, 2003 10:20 AM To: Joerg Hessdoerfer Cc: Bruce Momjian; [EMAIL PROTECTED] Subject: Re: [HACKERS] Win32 native port Joerg Hessdoerfer

Re: [HACKERS] Win32 native port

2003-09-04 Thread Dann Corbit
, 2003 11:36 AM To: [EMAIL PROTECTED] Subject: Re: [HACKERS] Win32 native port On Thu, 4 Sep 2003, Dann Corbit wrote: Use the Cygwin tools. Cygwin requires a license for commercial use. It does? I don't see it: http://cygwin.com/licensing.html Jon

Re: [HACKERS] Win32 native port

2003-09-04 Thread Dann Corbit
-Original Message- From: Jon Jensen [mailto:[EMAIL PROTECTED] Sent: Thursday, September 04, 2003 1:32 PM To: [EMAIL PROTECTED] Subject: Re: [HACKERS] Win32 native port On Thu, 4 Sep 2003, Dann Corbit wrote: Did you read this: This means that unless you modify the tools so

Re: [HACKERS] Win32 native port

2003-09-04 Thread Dann Corbit
-Original Message- From: Andrew Dunstan [mailto:[EMAIL PROTECTED] Sent: Thursday, September 04, 2003 2:35 PM To: Postgresql Hackers Subject: Re: [HACKERS] Win32 native port Dann Corbit wrote: -Original Message- From: Jon Jensen [mailto:[EMAIL PROTECTED] Sent

Re: [HACKERS] [GENERAL] 7.4Beta

2003-08-15 Thread Dann Corbit
-Original Message- From: Andreas Pflug [mailto:[EMAIL PROTECTED] Sent: Friday, August 15, 2003 10:49 AM To: Stephan Szabo Cc: PostgreSQL-development Subject: Re: [HACKERS] [GENERAL] 7.4Beta Stephan Szabo wrote: I don't know if there will be or not, but in one case it's a

Re: [HACKERS] [GENERAL] 7.4Beta

2003-08-15 Thread Dann Corbit
-Original Message- From: Andreas Pflug [mailto:[EMAIL PROTECTED] Sent: Friday, August 15, 2003 11:36 AM To: Dann Corbit Cc: Stephan Szabo; PostgreSQL-development Subject: Re: [HACKERS] [GENERAL] 7.4Beta Dann Corbit wrote: Simplification of bulk operations can be very important

Re: [HACKERS] Thread-safe configuration option appears to

2003-08-07 Thread Dann Corbit
-Original Message- From: Bruce Momjian [mailto:[EMAIL PROTECTED] Sent: Wednesday, August 06, 2003 4:29 PM To: Peter Eisentraut Cc: Lee Kindness; Larry Rosenman; PostgreSQL Development Subject: Re: [HACKERS] Thread-safe configuration option appears to Peter Eisentraut wrote:

Re: [HACKERS] 7.4 feature freeze is here

2003-07-02 Thread Dann Corbit
-Original Message- From: Philip Yarra [mailto:[EMAIL PROTECTED] Sent: Wednesday, July 02, 2003 5:17 PM To: Bruce Momjian Cc: [EMAIL PROTECTED] Subject: Re: [HACKERS] 7.4 feature freeze is here On Thu, 3 Jul 2003 12:14 am, you wrote: I usually do it, but it might take a week

Re: [HACKERS] Two weeks to feature freeze

2003-06-24 Thread Dann Corbit
-Original Message- From: The Hermit Hacker [mailto:[EMAIL PROTECTED] Sent: Tuesday, June 24, 2003 6:10 PM To: Dann Corbit Cc: The Hermit Hacker; Jan Wieck; scott.marlowe; Bruce Momjian; Tom Lane; Jason Earl; PostgreSQL-development Subject: RE: [HACKERS] Two weeks to feature freeze

Re: [HACKERS] Two weeks to feature freeze

2003-06-23 Thread Dann Corbit
-Original Message- From: The Hermit Hacker [mailto:[EMAIL PROTECTED] Sent: Sunday, June 22, 2003 12:30 PM To: Jan Wieck Cc: The Hermit Hacker; Dann Corbit; Tom Lane; Jason Earl; PostgreSQL-development Subject: Re: [HACKERS] Two weeks to feature freeze On Sun, 22 Jun 2003, Jan

Re: [HACKERS] Two weeks to feature freeze

2003-06-23 Thread Dann Corbit
-Original Message- From: Jan Wieck [mailto:[EMAIL PROTECTED] Sent: Sunday, June 22, 2003 5:45 AM To: Dann Corbit Cc: Tom Lane; Jason Earl; PostgreSQL-development Subject: Re: [HACKERS] Two weeks to feature freeze Dann Corbit wrote: -Original Message- From: Tom Lane

Re: [HACKERS] Two weeks to feature freeze

2003-06-23 Thread Dann Corbit
-Original Message- From: Bruce Momjian [mailto:[EMAIL PROTECTED] Sent: Saturday, June 21, 2003 8:50 PM To: Dann Corbit Cc: Tom Lane; Jason Earl; PostgreSQL-development Subject: Re: [HACKERS] Two weeks to feature freeze Dann Corbit wrote: That is the worst possible test plan

Re: [HACKERS] Two weeks to feature freeze

2003-06-23 Thread Dann Corbit
-Original Message- From: scott.marlowe [mailto:[EMAIL PROTECTED] Sent: Monday, June 23, 2003 12:25 PM To: Dann Corbit Cc: Bruce Momjian; Tom Lane; Jason Earl; PostgreSQL-development Subject: Re: [HACKERS] Two weeks to feature freeze On Mon, 23 Jun 2003, Dann Corbit wrote

Re: [HACKERS] Two weeks to feature freeze

2003-06-23 Thread Dann Corbit
-Original Message- From: Nigel J. Andrews [mailto:[EMAIL PROTECTED] Sent: Monday, June 23, 2003 1:30 PM To: Dann Corbit Cc: scott.marlowe; Bruce Momjian; Tom Lane; Jason Earl; PostgreSQL-development Subject: Re: [HACKERS] Two weeks to feature freeze [snip] So you've never worked

Re: [HACKERS] Two weeks to feature freeze

2003-06-23 Thread Dann Corbit
-Original Message- From: Jan Wieck [mailto:[EMAIL PROTECTED] Sent: Monday, June 23, 2003 10:10 PM To: scott.marlowe Cc: Dann Corbit; Bruce Momjian; Tom Lane; Jason Earl; PostgreSQL-development Subject: Re: [HACKERS] Two weeks to feature freeze scott.marlowe wrote: On Mon

Re: [HACKERS] Two weeks to feature freeze

2003-06-23 Thread Dann Corbit
Here is a list of a small sample of the citations available from the ACM on software testing: http://portal.acm.org/citation.cfm?id=581358coll=portaldl=ACMCFID=657 0092CFTOKEN=81653602 http://portal.acm.org/citation.cfm?id=376180coll=portaldl=ACMCFID=657 0092CFTOKEN=81653602

Re: [HACKERS] Two weeks to feature freeze

2003-06-23 Thread Dann Corbit
-Original Message- From: Jan Wieck [mailto:[EMAIL PROTECTED] Sent: Monday, June 23, 2003 10:30 PM To: Dann Corbit Cc: scott.marlowe; Bruce Momjian; Tom Lane; Jason Earl; PostgreSQL-development Subject: Re: [HACKERS] Two weeks to feature freeze [snip] I personally think you don't

Re: [HACKERS] Two weeks to feature freeze

2003-06-23 Thread Dann Corbit
-Original Message- From: Josh Berkus [mailto:[EMAIL PROTECTED] Sent: Monday, June 23, 2003 10:50 PM To: Dann Corbit; Jan Wieck Cc: scott.marlowe; Bruce Momjian; Tom Lane; Jason Earl; PostgreSQL-development Subject: Re: [HACKERS] Two weeks to feature freeze Dann, Astute

Re: [HACKERS] Two weeks to feature freeze

2003-06-21 Thread Dann Corbit
-Original Message- From: Tom Lane [mailto:[EMAIL PROTECTED] Sent: Friday, June 20, 2003 11:47 PM To: Dann Corbit Cc: Jason Earl; PostgreSQL-development Subject: Re: [HACKERS] Two weeks to feature freeze Dann Corbit [EMAIL PROTECTED] writes: Look at this: http

Re: [HACKERS] Two weeks to feature freeze

2003-06-20 Thread Dann Corbit
-Original Message- From: Jason Earl [mailto:[EMAIL PROTECTED] Sent: Friday, June 20, 2003 10:45 AM To: The Hermit Hacker Cc: Robert Treat; Tom Lane; Christopher Kings-Lynne; Bruce Momjian; PostgreSQL-development Subject: Re: [HACKERS] Two weeks to feature freeze The Hermit

Re: [HACKERS] Two weeks to feature freeze

2003-06-20 Thread Dann Corbit
-Original Message- From: Jason Earl [mailto:[EMAIL PROTECTED] Sent: Friday, June 20, 2003 3:32 PM To: Dann Corbit Cc: Jason Earl; The Hermit Hacker; PostgreSQL-development Subject: Re: [HACKERS] Two weeks to feature freeze Dann Corbit [EMAIL PROTECTED] writes: Why couldn't

Re: [HACKERS] Two weeks to feature freeze

2003-06-20 Thread Dann Corbit
-Original Message- From: Jason Earl [mailto:[EMAIL PROTECTED] Sent: Friday, June 20, 2003 4:43 PM To: Dann Corbit Cc: Jason Earl; PostgreSQL-development Subject: Re: [HACKERS] Two weeks to feature freeze Dann Corbit [EMAIL PROTECTED] writes: -Original Message

Re: [HACKERS] Two weeks to feature freeze

2003-06-20 Thread Dann Corbit
-Original Message- From: Tom Lane [mailto:[EMAIL PROTECTED] Sent: Friday, June 20, 2003 8:36 PM To: Dann Corbit Cc: Jason Earl; PostgreSQL-development Subject: Re: [HACKERS] Two weeks to feature freeze Dann Corbit [EMAIL PROTECTED] writes: If there is no procedure

Re: [HACKERS] Two weeks to feature freeze

2003-06-20 Thread Dann Corbit
-Original Message- From: Tom Lane [mailto:[EMAIL PROTECTED] Sent: Friday, June 20, 2003 8:58 PM To: Jason Earl Cc: Dann Corbit; PostgreSQL-development Subject: Re: [HACKERS] Two weeks to feature freeze Jason Earl [EMAIL PROTECTED] writes: Hmm... I must have missed the huge

Re: [HACKERS] Two weeks to feature freeze

2003-06-20 Thread Dann Corbit
-Original Message- From: Tom Lane [mailto:[EMAIL PROTECTED] Sent: Friday, June 20, 2003 9:19 PM To: Dann Corbit Cc: Jason Earl; PostgreSQL-development Subject: Re: [HACKERS] Two weeks to feature freeze Dann Corbit [EMAIL PROTECTED] writes: ...ROTFL... Crash-Me

Re: [HACKERS] Two weeks to feature freeze

2003-06-20 Thread Dann Corbit
-Original Message- From: Alvaro Herrera [mailto:[EMAIL PROTECTED] Sent: Friday, June 20, 2003 10:00 PM To: Dann Corbit Cc: Tom Lane; Jason Earl; PostgreSQL-development Subject: Re: [HACKERS] Two weeks to feature freeze On Fri, Jun 20, 2003 at 09:25:08PM -0700, Dann Corbit wrote

Re: [HACKERS] contrib and licensing

2003-04-02 Thread Dann Corbit
[snip] a program in /contrib linking to an LGPL lib has never been an issue. Linking to LGPL libs doesn't encumber the software linking to it. If that is a real objective, I'm surprised. The base source tree has always been as BSD pure as we can make it ... its never been kept

Re: [HACKERS] PostgreSQL Tuning Results

2003-02-11 Thread Dann Corbit
-Original Message- From: Christopher Kings-Lynne [mailto:[EMAIL PROTECTED]] Sent: Tuesday, February 11, 2003 8:54 PM To: Hackers; Advocacy Subject: [HACKERS] PostgreSQL Tuning Results Hi Everyone, I have just completed a basic set of benchmarking on our new database server.

Re: [pgsql-advocacy] [HACKERS] PostgreSQL Benchmarks

2003-02-11 Thread Dann Corbit
-Original Message- From: ow [mailto:[EMAIL PROTECTED]] Sent: Tuesday, February 11, 2003 10:32 PM To: Shridhar Daithankar[EMAIL PROTECTED]; [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Subject: Re: [pgsql-advocacy] [HACKERS] PostgreSQL Benchmarks There's The Open Source Database

Re: [pgsql-advocacy] [HACKERS] PostgreSQL Benchmarks

2003-02-11 Thread Dann Corbit
A financial database benchmark: http://www.cs.nyu.edu/cs/faculty/shasha/fintime.html ---(end of broadcast)--- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]

Re: [pgsql-advocacy] [HACKERS] PostgreSQL Benchmarks

2003-02-11 Thread Dann Corbit
This is how to get the FIPS benchmark. It measures CONFORMANCE rather than performance: http://www.itl.nist.gov/div897/ctg/sql_form.htm ---(end of broadcast)--- TIP 6: Have you searched our list archives? http://archives.postgresql.org

Re: [pgsql-advocacy] [HACKERS] PostgreSQL Benchmarks

2003-02-11 Thread Dann Corbit
The benchmark handbook: http://www.benchmarkresources.com/handbook/contents.asp ---(end of broadcast)--- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]

[HACKERS] Win32 and fsync()

2003-02-03 Thread Dann Corbit
For Win32, in order to emulate fsync() we will need to call FlushFileBuffers(): http://msdn.microsoft.com/library/default.asp?url=/library/en-us/fileio/ base/flushfilebuffers.asp ---(end of broadcast)--- TIP 1: subscribe and unsubscribe commands go

Re: [HACKERS] Win32 and fsync()

2003-02-03 Thread Dann Corbit
-Original Message- From: Merlin Moncure [mailto:[EMAIL PROTECTED]] Sent: Monday, February 03, 2003 3:00 PM To: Andrew Dunstan Cc: [EMAIL PROTECTED] Subject: Re: [HACKERS] Win32 and fsync() I'm having difficulty digging up the reference, but I think I recall seeing something

Re: [HACKERS] Win32 and fsync()

2003-02-03 Thread Dann Corbit
-Original Message- From: Andrew Dunstan [mailto:[EMAIL PROTECTED]] Sent: Monday, February 03, 2003 3:31 PM To: Dann Corbit; Merlin Moncure Cc: [EMAIL PROTECTED] Subject: Re: [HACKERS] Win32 and fsync() I'm not sure what the provenance of this code for _commit is - I thought

Re: [HACKERS] Windows Build System - My final thoughts

2003-01-31 Thread Dann Corbit
-Original Message- From: Bruce Momjian [mailto:[EMAIL PROTECTED]] Sent: Friday, January 31, 2003 12:21 AM To: Lamar Owen Cc: PostgreSQL-development Subject: Re: [HACKERS] Windows Build System - My final thoughts Man, I go away for one day, and look what you guys get into. :-)

Re: [mail] Re: [HACKERS] Windows Build System

2003-01-31 Thread Dann Corbit
For MySQL: There is no Cygwin needed. Period. I did a build last night. Using nothing but Visual Studio with the Intel C++ compiler for Win32. Here is what got built: E:\mysql-3.23.55dir /s *.dll, *.exe Volume in drive E has no label. Volume Serial Number is 7496-C335 Directory of

Re: [mail] Re: [HACKERS] Windows Build System

2003-01-31 Thread Dann Corbit
-Original Message- From: Tom Lane [mailto:[EMAIL PROTECTED]] Sent: Friday, January 31, 2003 8:24 PM To: mlw Cc: Lamar Owen; Dann Corbit; PostgresSQL Hackers Mailing List Subject: Re: [mail] Re: [HACKERS] Windows Build System mlw [EMAIL PROTECTED] writes: Like

Re: [mail] Re: [HACKERS] Windows Build System

2003-01-31 Thread Dann Corbit
-Original Message- From: Greg Copeland [mailto:[EMAIL PROTECTED]] Sent: Friday, January 31, 2003 10:39 PM To: Dann Corbit Cc: Christopher Browne; Justin Clift; Jeff Davis; PostgresSQL Hackers Mailing List Subject: RE: [mail] Re: [HACKERS] Windows Build System On Fri, 2003-01

Re: [mail] Re: [HACKERS] Windows Build System

2003-01-30 Thread Dann Corbit
-Original Message- From: Tom Lane [mailto:[EMAIL PROTECTED]] Sent: Thursday, January 30, 2003 12:30 PM To: Lamar Owen Cc: Dave Page; Vince Vielhaber; Ron Mayer; [EMAIL PROTECTED] Subject: Re: [mail] Re: [HACKERS] Windows Build System Lamar Owen [EMAIL PROTECTED] writes:

Re: [HACKERS] Win32 port patches submitted

2003-01-29 Thread Dann Corbit
-Original Message- From: Jan Wieck [mailto:[EMAIL PROTECTED]] Sent: Wednesday, January 29, 2003 11:47 AM To: Peter Eisentraut Cc: Justin Clift; Hannu Krosing; Bruce Momjian; Tom Lane; Postgres development Subject: Re: [HACKERS] Win32 port patches submitted Peter Eisentraut

Re: [HACKERS] Terrible performance on wide selects

2003-01-22 Thread Dann Corbit
-Original Message- From: Tom Lane [mailto:[EMAIL PROTECTED]] Sent: Wednesday, January 22, 2003 3:15 PM To: Steve Crawford Cc: [EMAIL PROTECTED]; [EMAIL PROTECTED] Subject: Re: [HACKERS] Terrible performance on wide selects Steve Crawford sent me some profiling results for

Re: [HACKERS] Terrible performance on wide selects

2003-01-22 Thread Dann Corbit
-Original Message- From: Tom Lane [mailto:[EMAIL PROTECTED]] Sent: Wednesday, January 22, 2003 4:18 PM To: Dann Corbit Cc: Steve Crawford; [EMAIL PROTECTED]; [EMAIL PROTECTED] Subject: Re: [HACKERS] Terrible performance on wide selects Dann Corbit [EMAIL PROTECTED] writes

Re: [HACKERS] Terrible performance on wide selects

2003-01-22 Thread Dann Corbit
[snip] So (for instance) if you have 12 variable fields, you would store 12 integers at the start of the record. Additionally, you could implicitly size the integers from the properties of the column. A varchar(255) would only need an unsigned char to store the offset, but a varchar(8)

Re: [HACKERS] [mail] Re: Win32 port patches submitted

2003-01-21 Thread Dann Corbit
-Original Message- From: Jan Wieck [mailto:[EMAIL PROTECTED]] Sent: Tuesday, January 21, 2003 4:04 PM To: Emmanuel Charpentier Cc: [EMAIL PROTECTED] Subject: Re: [HACKERS] [mail] Re: Win32 port patches submitted Emmanuel Charpentier wrote: Mingw and mingw-ported tools ?

Re: [mail] Re: [HACKERS] Win32 port patches submitted

2003-01-21 Thread Dann Corbit
-Original Message- From: Hans-Jürgen Schönig [mailto:[EMAIL PROTECTED]] Sent: Tuesday, January 21, 2003 10:54 PM To: Brian Bruns; [EMAIL PROTECTED] Subject: Re: [mail] Re: [HACKERS] Win32 port patches submitted Brian Bruns wrote: Problem is, nobody builds packages on windows

Re: [HACKERS] Dollar in identifiers

2003-01-09 Thread Dann Corbit
-Original Message- From: Bruce Momjian [mailto:[EMAIL PROTECTED]] Sent: Thursday, January 09, 2003 1:55 PM To: Peter Eisentraut Cc: Tom Lane; Jan Wieck; PostgreSQL HACKERS Subject: Re: [HACKERS] Dollar in identifiers Peter Eisentraut wrote: Tom Lane writes: Quite awhile

Re: [HACKERS] Dollar in identifiers

2003-01-09 Thread Dann Corbit
-Original Message- From: Tom Lane [mailto:[EMAIL PROTECTED]] Sent: Thursday, January 09, 2003 2:27 PM To: Jan Wieck Cc: Bruce Momjian; Peter Eisentraut; PostgreSQL HACKERS Subject: Re: [HACKERS] Dollar in identifiers Jan Wieck [EMAIL PROTECTED] writes: The problem is,

Re: [GENERAL] [HACKERS] I feel the need for speed. What am I doing wrong?

2003-01-08 Thread Dann Corbit
-Original Message- From: scott.marlowe [mailto:[EMAIL PROTECTED]] Sent: Wednesday, January 08, 2003 6:30 AM To: Dann Corbit Cc: johnn; [EMAIL PROTECTED] Subject: Re: [GENERAL] [HACKERS] I feel the need for speed. What am I doing wrong? No analyze for 7.1.3. Just ran

Re: [GENERAL] [HACKERS] I feel the need for speed. What am I doing wrong?

2003-01-07 Thread Dann Corbit
-Original Message- From: johnn [mailto:[EMAIL PROTECTED]] Sent: Tuesday, January 07, 2003 3:33 PM To: [EMAIL PROTECTED] Subject: Re: [GENERAL] [HACKERS] I feel the need for speed. What am I doing wrong? On Tue, Jan 07, 2003 at 03:10:06PM -0800, Dann Corbit wrote: NOTICE

Re: [GENERAL] [HACKERS] I feel the need for speed. What am I doing wrong?

2003-01-07 Thread Dann Corbit
-Original Message- From: Jean-Luc Lachance [mailto:[EMAIL PROTECTED]] Sent: Tuesday, January 07, 2003 2:43 PM To: Tom Lane Cc: Dann Corbit; Nigel J. Andrews; [EMAIL PROTECTED]; [EMAIL PROTECTED] Subject: Re: [GENERAL] [HACKERS] I feel the need for speed. What am I doing wrong

[HACKERS] I feel the need for speed. What am I doing wrong?

2003-01-06 Thread Dann Corbit
I have a query using two postgres tables. One is called CNX_DS_53_SIS_STU_OPT_FEE_TB and the other is called CNX_DS2_53_SIS_STU_OPT_FEE_TB. I am getting 3 times slower performance than Microsoft Access when performing a left outer join. Here are the tables in question: connxdatasync=# \d

Re: [HACKERS] OS/400 support?

2003-01-06 Thread Dann Corbit
-Original Message- From: Tom Lane [mailto:[EMAIL PROTECTED]] Sent: Monday, January 06, 2003 5:27 PM To: Justin Clift Cc: [EMAIL PROTECTED] Subject: Re: [HACKERS] OS/400 support? Justin Clift [EMAIL PROTECTED] writes: We don't support OS/400 yet do we? Never heard of it.

Re: [HACKERS] I feel the need for speed. What am I doing wrong?

2003-01-06 Thread Dann Corbit
-Original Message- From: Nigel J. Andrews [mailto:[EMAIL PROTECTED]] Sent: Monday, January 06, 2003 4:58 PM To: Dann Corbit Cc: [EMAIL PROTECTED]; [EMAIL PROTECTED] Subject: Re: [HACKERS] I feel the need for speed. What am I doing wrong? Added -general list so that the next

Re: [HACKERS] I feel the need for speed. What am I doing wrong?

2003-01-06 Thread Dann Corbit
-Original Message- From: Tom Lane [mailto:[EMAIL PROTECTED]] Sent: Monday, January 06, 2003 5:26 PM To: Nigel J. Andrews Cc: Dann Corbit; [EMAIL PROTECTED]; [EMAIL PROTECTED] Subject: Re: [HACKERS] I feel the need for speed. What am I doing wrong? Nigel J. Andrews [EMAIL

[HACKERS] PostgreSQL and memory usage

2003-01-06 Thread Dann Corbit
Title: Message I have a machine with 4 CPU's and 2 gigabytes of physical ram. I would like to get PostgreSQL to use as much memory as possible. I can't seem to get PostgreSQL to use more than 100 megabytes or so. How can I optimize the use of PostgreSQL to get the maximum throughput in a

Re: [HACKERS] [GENERAL] PostgreSQL and memory usage

2003-01-06 Thread Dann Corbit
-Original Message- From: Tom Lane [mailto:[EMAIL PROTECTED]] Sent: Monday, January 06, 2003 7:30 PM To: Dann Corbit Cc: [EMAIL PROTECTED]; [EMAIL PROTECTED] Subject: Re: [GENERAL] PostgreSQL and memory usage Dann Corbit [EMAIL PROTECTED] writes: I have a machine with 4 CPU's

Re: [HACKERS] Threads

2003-01-03 Thread Dann Corbit
-Original Message- From: mlw [mailto:[EMAIL PROTECTED]] Sent: Friday, January 03, 2003 12:47 PM To: Shridhar Daithankar Cc: PGHackers Subject: Re: [HACKERS] Threads Please no threading threads!!! Has anyone calculated the interval and period of PostgreSQL needs threads

Re: [HACKERS] more compile warnings

2002-12-06 Thread Dann Corbit
-Original Message- From: Bruce Momjian [mailto:[EMAIL PROTECTED]] Sent: Friday, December 06, 2002 7:58 PM To: Joe Conway Cc: [EMAIL PROTECTED]; PostgreSQL-development Subject: Re: [HACKERS] more compile warnings Rod, can you comment on these warnings Joe Conway's compiler is

[HACKERS] Design decision curiosity

2002-10-19 Thread Dann Corbit
I am curious as to why it is necessary to add PL/pgSQL as a language instead of including it by default. Is it to save space on small systems or??? Since the code necessary PL/pgSQL is very small, it does not seem like there would be much savings. I imagine that there is occasionally some

Re: [HACKERS] 7.3beta and ecpg

2002-09-10 Thread Dann Corbit
-Original Message- From: Bruce Momjian [mailto:[EMAIL PROTECTED]] Sent: Tuesday, September 10, 2002 9:10 PM To: Michael Meskes Cc: PostgreSQL Hacker; Marc G. Fournier Subject: Re: [HACKERS] 7.3beta and ecpg I think we should stop playing around with ecpg. Let's get the

Re: [HACKERS] Rule updates and PQcmdstatus() issue

2002-09-09 Thread Dann Corbit
-Original Message- From: Rod Taylor [mailto:[EMAIL PROTECTED]] Sent: Monday, September 09, 2002 10:55 AM To: Steve Howe Cc: PostgreSQL-development Subject: Re: [HACKERS] Rule updates and PQcmdstatus() issue existed, had a brief discussion on the subject, and couldn't reach

Re: [HACKERS] Rule updates and PQcmdstatus() issue

2002-09-09 Thread Dann Corbit
-Original Message- From: Ross J. Reedstrom [mailto:[EMAIL PROTECTED]] Sent: Monday, September 09, 2002 12:26 PM To: Dann Corbit Cc: Rod Taylor; Steve Howe; PostgreSQL-development Subject: Re: [HACKERS] Rule updates and PQcmdstatus() issue On Mon, Sep 09, 2002 at 11:30:52AM

Re: [HACKERS] [7.3devl] Using PGPASSWORDFILE with psql requires -U

2002-08-29 Thread Dann Corbit
-Original Message- From: Tom Lane [mailto:[EMAIL PROTECTED]] Sent: Thursday, August 29, 2002 9:07 PM To: Alvaro Herrera Cc: Gordon Runkle; [EMAIL PROTECTED] Subject: Re: [HACKERS] [7.3devl] Using PGPASSWORDFILE with psql requires -U Alvaro Herrera [EMAIL PROTECTED] writes:

Re: [HACKERS] @(#)Mordred Labs advisory 0x0007: Remove DoS in PostgreSQL

2002-08-26 Thread Dann Corbit
-Original Message- From: Lamar Owen [mailto:[EMAIL PROTECTED]] Sent: Monday, August 26, 2002 10:50 AM To: Bruce Momjian; Tom Lane Cc: Sir Mordred The Traitor; [EMAIL PROTECTED] Subject: Re: [HACKERS] @(#)Mordred Labs advisory 0x0007: Remove DoS in PostgreSQL On Monday 26

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

2002-08-20 Thread Dann Corbit
-Original Message- From: Neil Conway [mailto:[EMAIL PROTECTED]] Sent: Tuesday, August 20, 2002 1:44 PM To: Vince Vielhaber Cc: [EMAIL PROTECTED] Subject: Re: [HACKERS] @(#)Mordred Labs advisory 0x0003: Buffer overflow in PostgreSQL (fwd) Vince Vielhaber [EMAIL PROTECTED]

Re: [HACKERS] @(#)Mordred Labs advisory 0x0004: Multiple buffer overflows inPostgreSQL. (fwd)

2002-08-20 Thread Dann Corbit
-Original Message- From: Vince Vielhaber [mailto:[EMAIL PROTECTED]] Sent: Tuesday, August 20, 2002 1:48 PM To: [EMAIL PROTECTED] Subject: [HACKERS] @(#)Mordred Labs advisory 0x0004: Multiple buffer overflows inPostgreSQL. (fwd) And another one. Sure would be nice if

Re: [HACKERS] @(#)Mordred Labs advisory 0x0004: Multiple buffer overflows inPostgreSQL. (fwd)

2002-08-20 Thread Dann Corbit
-Original Message- From: Frank Wiles [mailto:[EMAIL PROTECTED]] Sent: Tuesday, August 20, 2002 1:57 PM To: Dann Corbit Cc: [EMAIL PROTECTED] Subject: Re: [HACKERS] @(#)Mordred Labs advisory 0x0004: Multiple buffer overflows inPostgreSQL. (fwd) .--[ Dann Corbit wrote

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

2002-08-19 Thread Dann Corbit
-Original Message- From: Neil Conway [mailto:[EMAIL PROTECTED]] Sent: Monday, August 19, 2002 10:22 PM To: Mark Pritchard Cc: Justin Clift; Tom Lane; Christopher Kings-Lynne; [EMAIL PROTECTED] Subject: Re: [HACKERS] @(#) Mordred Labs advisory 0x0001: Buffer overflow in

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

2002-08-19 Thread Dann Corbit
-Original Message- From: Neil Conway [mailto:[EMAIL PROTECTED]] Sent: Monday, August 19, 2002 10:42 PM To: Dann Corbit Cc: Neil Conway; Mark Pritchard; Justin Clift; Tom Lane; Christopher Kings-Lynne; [EMAIL PROTECTED] Subject: Re: [HACKERS] @(#) Mordred Labs advisory 0x0001

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

2002-08-19 Thread Dann Corbit
-Original Message- From: Neil Conway [mailto:[EMAIL PROTECTED]] Sent: Monday, August 19, 2002 10:48 PM To: Dann Corbit Cc: Neil Conway; Mark Pritchard; Justin Clift; Tom Lane; Christopher Kings-Lynne; [EMAIL PROTECTED] Subject: Re: [HACKERS] @(#) Mordred Labs advisory 0x0001

Re: [HACKERS] Proposal: stand-alone composite types

2002-08-09 Thread Dann Corbit
-Original Message- From: Joe Conway [mailto:[EMAIL PROTECTED]] Sent: Friday, August 09, 2002 4:04 PM To: Peter Eisentraut Cc: pgsql-hackers Subject: Re: [HACKERS] Proposal: stand-alone composite types Peter Eisentraut wrote: Joe Conway writes: 3. Modify CREATE FUNCTION to

Re: [HACKERS] Open 7.3 items

2002-08-01 Thread Dann Corbit
To: Dann Corbit Cc: Tom Lane; PostgreSQL-development Subject: Re: [HACKERS] Open 7.3 items If you can contribute it, I think it would be valuable to the two other Win32 projects that are working on porting the 7.3 code to Win32. I don't think they will have any code ready for 7.3

Re: [HACKERS] (A) native Windows port

2002-07-05 Thread Dann Corbit
On generic recovery... What is wrong with this strategy... 0. Put the database in single user mode. 1. Dump the Schema, with creation order properly defined, and with all constraints written to a separate file. (IOW, one file contains the bare tables with no index, constraint or trigger

Re: [HACKERS] Thread discussion

2002-07-05 Thread Dann Corbit
-Original Message- From: Bruce Momjian [mailto:[EMAIL PROTECTED]] Sent: Friday, July 05, 2002 7:59 PM To: PostgreSQL-development Subject: [HACKERS] Thread discussion There was an interesting thread/process discussion in the gproff Slashdot discussion:

Re: [HACKERS] Democracy and organisation : let's make a

2002-06-26 Thread Dann Corbit
-Original Message- From: Josh Berkus [mailto:[EMAIL PROTECTED]] Sent: Wednesday, June 26, 2002 9:18 AM To: Curt Sampson; [EMAIL PROTECTED] Subject: Re: [HACKERS] Democracy and organisation : let's make a Curt, You do point out some good areas in which PostgreSQL needs to

[HACKERS] Database comparison ideas

2002-06-26 Thread Dann Corbit
I think that the people on this list tend to make a mistake. They try to pick apart the competition by focusing on their weak points. From a growth standpoint, I think it is a much better idea to focus on their strong points. Look at the things each competitor can do best. Try to think of ways

Re: [HACKERS] What is wrong with hashed index usage?

2002-06-21 Thread Dann Corbit
-Original Message- From: Bruce Momjian [mailto:[EMAIL PROTECTED]] Sent: Friday, June 21, 2002 9:52 AM To: Tom Lane Cc: Neil Conway; [EMAIL PROTECTED]; Dann Corbit; [EMAIL PROTECTED] Subject: Re: [HACKERS] What is wrong with hashed index usage? Tom Lane wrote: Bruce Momjian

Re: [HACKERS] What is wrong with hashed index usage?

2002-06-21 Thread Dann Corbit
-Original Message- From: Bruce Momjian [mailto:[EMAIL PROTECTED]] Sent: Friday, June 21, 2002 1:31 PM To: Dann Corbit Cc: Tom Lane; Neil Conway; [EMAIL PROTECTED]; [EMAIL PROTECTED] Subject: Re: [HACKERS] What is wrong with hashed index usage? Dann Corbit wrote: I

Re: [HACKERS] [GENERAL] Idea for the statistics collector

2002-06-20 Thread Dann Corbit
Here are some class notes that contain some very good ideas with terrific explanations: http://www.cs.duke.edu/education/courses/fall01/cps216/ ---(end of broadcast)--- TIP 3: if posting/reading through Usenet, please send an appropriate

[HACKERS] Why is CacheMemoryContext declared DLLIMPORT in one place and not in another?

2002-06-18 Thread Dann Corbit
PostgreSQL 7.2.1... We have: C:\CYGWIN\USR\SRC\POSTGRESQL-7.2.1-1\src\include\utils\catcache.h(84):ex tern MemoryContext CacheMemoryContext; C:\CYGWIN\USR\SRC\POSTGRESQL-7.2.1-1\src\include\utils\memutils.h(70):ex tern DLLIMPORT MemoryContext CacheMemoryContext; They cannot both be correct.

Re: [HACKERS] ECPG won't compile anymore

2002-06-18 Thread Dann Corbit
-Original Message- From: Bruce Momjian [mailto:[EMAIL PROTECTED]] Sent: Tuesday, June 18, 2002 11:13 AM To: Michael Meskes Cc: PostgreSQL Hacker Subject: Re: [HACKERS] ECPG won't compile anymore Michael Meskes wrote: On Tue, Jun 18, 2002 at 10:29:10AM -0400, Tom Lane wrote:

Re: [HACKERS] PostGres Doubt

2002-06-13 Thread Dann Corbit
-Original Message- From: Michael Meskes [mailto:[EMAIL PROTECTED]] Sent: Thursday, June 13, 2002 3:06 AM To: [EMAIL PROTECTED] Subject: Re: [HACKERS] PostGres Doubt On Wed, Jun 12, 2002 at 11:46:47AM -0700, Dann Corbit wrote: I should apologize for being rather harsh about

Re: [HACKERS] PostGres Doubt

2002-06-12 Thread Dann Corbit
-Original Message- From: Michael Meskes [mailto:[EMAIL PROTECTED]] Sent: Wednesday, June 12, 2002 5:41 AM To: Dann Corbit Cc: [EMAIL PROTECTED] Subject: Re: [HACKERS] PostGres Doubt On Mon, Jun 10, 2002 at 02:08:22PM -0700, Dann Corbit wrote: ECPG is single threading. Hence

Re: [HACKERS] PostGres Doubt

2002-06-12 Thread Dann Corbit
I should apologize for being rather harsh about embedded SQL for PostgreSQL. To be fair, it does function and it certainly isn't trivial to implement. I am sure that those who have worked on this project have invested very many hours of blood, sweat and tears making it work. I actually spent a

[HACKERS] Feature request: Truncate table

2002-06-12 Thread Dann Corbit
Deletion of data from a PostgreSQL table is very slow. It would be nice to have a very fast delete like truncate table. Now, truncate is a very dangerous command because it is not logged (but the same is true for other operations like bulk copy and select into). So one needs to be careful how

Re: [HACKERS] Feature request: Truncate table

2002-06-12 Thread Dann Corbit
-Original Message- From: Larry Rosenman [mailto:[EMAIL PROTECTED]] Sent: Wednesday, June 12, 2002 12:36 PM To: Dann Corbit Cc: [EMAIL PROTECTED] Subject: Re: [HACKERS] Feature request: Truncate table On Wed, 2002-06-12 at 14:32, Dann Corbit wrote: Deletion of data from

Re: [HACKERS] PostGres Doubt

2002-06-12 Thread Dann Corbit
-Original Message- From: Bruce Momjian [mailto:[EMAIL PROTECTED]] Sent: Wednesday, June 12, 2002 2:42 PM To: Dann Corbit Cc: Michael Meskes; [EMAIL PROTECTED] Subject: Re: [HACKERS] PostGres Doubt Dann Corbit wrote: I should apologize for being rather harsh about embedded SQL

Re: [HACKERS] PostGres Doubt

2002-06-12 Thread Dann Corbit
-Original Message- From: Bruce Momjian [mailto:[EMAIL PROTECTED]] Sent: Wednesday, June 12, 2002 3:20 PM To: Dann Corbit Cc: Michael Meskes; [EMAIL PROTECTED] Subject: Re: [HACKERS] PostGres Doubt Dann Corbit I assume this is because you wrote your code assuming a feature

Re: [HACKERS] PostGres Doubt

2002-06-11 Thread Dann Corbit
Are you using crypt on the connection? Unfortunately, crypt is not reentrant. -Original Message- From: David Ford [mailto:[EMAIL PROTECTED]] Sent: Monday, June 10, 2002 6:16 PM To: Dann Corbit Cc: vikas p verma; [EMAIL PROTECTED] Subject: Re: [HACKERS] PostGres Doubt Is libpq

Re: [HACKERS] PostGres Doubt

2002-06-10 Thread Dann Corbit
-Original Message- From: vikas p verma [mailto:[EMAIL PROTECTED]] Sent: Monday, June 10, 2002 1:10 PM To: [EMAIL PROTECTED] Subject: [HACKERS] PostGres Doubt Hi , I am extremely new to PostGreSql. If any one can please answer this question of mine. I want to insert/update

<    1   2   3   4   5   >