Rewriting pg_upgrade (was Re: [GENERAL] State of Beta 2)

2003-09-27 Thread Ron Johnson
On Sat, 2003-09-27 at 16:50, Nigel J. Andrews wrote: > On Sat, 27 Sep 2003, Bruce Momjian wrote: > > > Tom Lane wrote: > > > Bruce Momjian <[EMAIL PROTECTED]> writes: > > > > With all the discussion and pg_upgrade, I saw no one offer to work on > > > > it. > > > > Does someone want to convert it t

Re: [GENERAL] Can't Build 7.3.4 on OS X

2003-09-27 Thread Tom Lane
Eric Ridge <[EMAIL PROTECTED]> writes: > I don't think the OS X 10.3 betas are readily available (I've payed to > be in Apple's developer program), so if you don't have access to 10.3 > but have some idea as to what would cause this problem with tas, I'll > do whatever I can to help test. I hav

Re: [GENERAL] Can't Build 7.3.4 on OS X

2003-09-27 Thread Eric B . Ridge
On Sep 27, 2003, at 3:43 PM, Tom Lane wrote: Eric Ridge <[EMAIL PROTECTED]> writes: I don't think the OS X 10.3 betas are readily available (I've payed to be in Apple's developer program), so if you don't have access to 10.3 but have some idea as to what would cause this problem with tas, I'll do

Re: [GENERAL] Can't Build 7.3.4 on OS X

2003-09-27 Thread Tom Lane
"Eric B. Ridge" <[EMAIL PROTECTED]> writes: > Were you ever able to figure out why 7.3.4 wouldn't build? Didn't really look, since the 7.4 inlined version of TAS is a better solution anyway. regards, tom lane ---(end of broadcast)--

Re: [GENERAL] Can't Build 7.3.4 on OS X

2003-09-27 Thread Vincent Janelle
Eric B.Ridge wrote: On Sep 27, 2003, at 3:43 PM, Tom Lane wrote: Eric Ridge <[EMAIL PROTECTED]> writes: I don't think the OS X 10.3 betas are readily available (I've payed to be in Apple's developer program), so if you don't have access to 10.3 but have some idea as to what would cause this prob

Re: [GENERAL] Can't Build 7.3.4 on OS X

2003-09-27 Thread Eric B . Ridge
if you execute 'select_gcc 3.1' as root it should change your default GCC to a compiler that works. That fixes the problems with -traditional-cpp v/s -no-cpp-precomp, but it doesn't fix: ld: Undefined symbol _tas eric ---(end of broadcast)--- TI

Re: Rewriting pg_upgrade (was Re: [GENERAL] State of Beta 2)

2003-09-27 Thread Marc G. Fournier
On Sat, 27 Sep 2003, Ron Johnson wrote: > Isn't Perl pretty ubiquitous on "Unix" now, though? Except maybe > Unixware I know that Solaris now has it included by default ... ---(end of broadcast)--- TIP 8: explain analyze is your friend

Re: Rewriting pg_upgrade (was Re: [GENERAL] State of Beta 2)

2003-09-27 Thread Larry Rosenman
perl ships on UnixWare (5.005, but that will change in UP3). LER --On Saturday, September 27, 2003 22:42:02 -0300 "Marc G. Fournier" <[EMAIL PROTECTED]> wrote: On Sat, 27 Sep 2003, Ron Johnson wrote: Isn't Perl pretty ubiquitous on "Unix" now, though? Except maybe Unixware I know that S

Re: [GENERAL] State of Beta 2

2003-09-27 Thread Joshua D. Drake
$$$ -- I wasn't looking to purchase a programmer. :-) Well sometimes it takes money to get things done. Personally I don't see a big need for pg_upgrade but there was enough people making noise about it that it made sense to make the proposal. Several people did come back and offer to cough

Re: [GENERAL] Can't Build 7.3.4 on OS X

2003-09-27 Thread Eric Ridge
On Sep 27, 2003, at 7:41 PM, Tom Lane wrote: I'm not sure whether we are planning another 7.3 release or not. I'd like to push forward to a 7.4 release, myself. Do you have any idea when OS X 10.3 will be released? If it's further out than next month, we could probably plan that 7.4 will win the

Re: [GENERAL] State of Beta 2

2003-09-27 Thread Lamar Owen
On Saturday 27 September 2003 09:45 pm, Joshua D. Drake wrote: > >$$$ -- I wasn't looking to purchase a programmer. :-) > Well sometimes it takes money to get things done. Personally I don't see > a big need > for pg_upgrade but there was enough people making noise about it that it > made sense >

Re: Rewriting pg_upgrade (was Re: [GENERAL] State of Beta 2)

2003-09-27 Thread Marc G. Fournier
On Sat, 27 Sep 2003, Larry Rosenman wrote: > perl ships on UnixWare (5.005, but that will change in UP3). In what way? :) It won't ship anymore ... or upgraded? > > LER > > > --On Saturday, September 27, 2003 22:42:02 -0300 "Marc G. Fournier" > <[EMAIL PROTECTED]> wrote: > > > > > > > On Sat,

Re: Rewriting pg_upgrade (was Re: [GENERAL] State of Beta 2)

2003-09-27 Thread Larry Rosenman
--On Sunday, September 28, 2003 00:14:18 -0300 "Marc G. Fournier" <[EMAIL PROTECTED]> wrote: On Sat, 27 Sep 2003, Larry Rosenman wrote: perl ships on UnixWare (5.005, but that will change in UP3). In what way? :) It won't ship anymore ... or upgraded? upgraded to 5.8.0 (sorry, should have

Re: [GENERAL] State of Beta 2

2003-09-27 Thread Dennis Gearon
Ron Johnson wrote: There's always the general point that C has more pitfalls (mainly from pointers/free()/malloc(), and HLLs do more for you, thus you have to code less, and, consequently, there are fewer bugs. Someday, they're going to make a langauge called: CBC, "C Bounds Checked" No buffe

[GENERAL] Tuning/performance question.

2003-09-27 Thread David Griffiths
We are doing some performance testing among various databases (Oracle, MySQL and Postgres). One of the queries is showing Postgres lagging quite a bit: SELECT count(*) FROM commercial_entity, country, user_account, address_list LEFT JOIN state_province ON address_list.state_province_id = state_p

Re: [GENERAL] State of Beta 2

2003-09-27 Thread Ron Johnson
On Sat, 2003-09-27 at 22:19, Dennis Gearon wrote: > Ron Johnson wrote: > > >There's always the general point that C has more pitfalls (mainly > >from pointers/free()/malloc(), and HLLs do more for you, thus you > >have to code less, and, consequently, there are fewer bugs. > > > Someday, they're g

Re: Rewriting pg_upgrade (was Re: [GENERAL] State of Beta 2)

2003-09-27 Thread Greg Stark
Ron Johnson <[EMAIL PROTECTED]> writes: > > > Tom Lane wrote: > > > > The reason that it needs to be rewritten in C is that it needs access to > > > > internal stuff that the backend doesn't expose. (For example, the > > > > transaction counter, end-of-WAL pointer, etc.) I don't think Perl woul