Re: [HACKERS] What X86/X64 OS's do we need coverage for?

2007-04-19 Thread Darcy Buskermolen
On Thursday 05 April 2007 16:28, Larry Rosenman wrote: > I might use that as the base then, since the hardware finishes getting here > tomorrow. > > My question still stands on what OS's we need coverage for. One I see as missing right now is Solaris 10 X86 with gcc building 64bit binaries (we ha

Re: [HACKERS] GUC time unit spelling a bit inconsistent

2007-06-21 Thread Darcy Buskermolen
On Thursday 21 June 2007 08:34, Andrew Sullivan wrote: > On Thu, Jun 21, 2007 at 03:24:51PM +0200, Michael Paesold wrote: > > There are valid reasons against 5m as mega-bytes, because here m does > > not refer to a unit, it refers to a quantifier (if that is a reasonable > > English word) of a unit

Re: [HACKERS] Why so many out-of-disk-space failures on buildfarm machines?

2007-07-04 Thread Darcy Buskermolen
On Tuesday 03 July 2007 19:35, Tom Lane wrote: > It seems like we see a remarkable number of occurrences of $subject. > For instance, right now we have these members failing on various > branches: > > echidna No space left on device > asp No space left on device > herring

Re: [HACKERS] XID wraparound and busy databases

2007-08-15 Thread Darcy Buskermolen
On Wednesday 15 August 2007 09:49:52 Tom Lane wrote: > Heikki Linnakangas <[EMAIL PROTECTED]> writes: > > Maybe we can do something to reduce the xid consumption? For example, > > reuse xids for read-only queries. > > Hmm, that's an idea. > > More simply, just keep the current transaction open (res

Re: [HACKERS] build farm failures

2007-08-16 Thread Darcy Buskermolen
On Thursday 16 August 2007 04:29:41 Andrew Dunstan wrote: > Michael Meskes wrote: > > Hi, > > > > we have two build farm members failing to make since I committed teh > > ecpg changes: echidna and herring. > > > > It looks like they are still using an old preproc.c although they > > checked out the

Re: [HACKERS] autovacuum launcher eating too much CPU

2007-09-13 Thread Darcy Buskermolen
On Thursday 13 September 2007 09:16:52 Alvaro Herrera wrote: > Hi, > > Darcy Buskermolen noticed that when one has many databases, the autovac > launcher starts eating too much CPU. Don't forget the memory leak as well. after 3 or 4 days of running I end up with a 2GB+ AVL.

Re: [HACKERS] autovacuum launcher eating too much CPU

2007-09-14 Thread Darcy Buskermolen
On September 14, 2007 06:36 am, Alvaro Herrera wrote: > Alvaro Herrera wrote: > > Darcy Buskermolen wrote: > > > On Thursday 13 September 2007 09:16:52 Alvaro Herrera wrote: > > > > Hi, > > > > > > > > Darcy Buskermolen noticed that when one h

Re: [HACKERS] autovacuum launcher eating too much CPU

2007-09-24 Thread Darcy Buskermolen
On September 23, 2007 09:12 pm, Alvaro Herrera wrote: > Darcy Buskermolen wrote: > > On September 14, 2007 06:36 am, Alvaro Herrera wrote: > > > Darcy, please also apply the following patch and see if it reduces the > > > CPU consumption to a reasonable level. > >

Re: [HACKERS] Getting to 8.3 beta1

2007-09-27 Thread Darcy Buskermolen
--(end of broadcast)--- > TIP 1: if posting/reading through Usenet, please send an appropriate >subscribe-nomail command to [EMAIL PROTECTED] so that your >message can get through to the mailing list cleanly -- Darcy Buskermolen The PostgreSQL company, Command Prompt Inc. http://www.commandprompt.com/ ---(end of broadcast)--- TIP 2: Don't 'kill -9' the postmaster

Re: [HACKERS] Seems we need a post-beta1 initdb already

2007-10-12 Thread Darcy Buskermolen
On Friday 12 October 2007 15:41:58 Tom Lane wrote: > As Martin Pitt pointed out in this pgsql-bugs thread > http://archives.postgresql.org/pgsql-bugs/2007-10/msg00089.php > we have managed to create an ABI break between 8.2 and 8.3 libpq > by renumbering encoding IDs in pg_wchar.h. Although perhap

Re: [HACKERS] Bug: Unreferenced temp tables disables vacuum to update xid

2008-01-07 Thread Darcy Buskermolen
p* CASCADE; before coming up in interactive mode? Doing this would at least have allowedthe manual vacuum to do what it needed and not have caused confusion on the part of the user? Also it would have greatly reduced the total time to resolution, and not requiring hacking the backen

Re: 8.3.0 release schedule (Was:Re: [HACKERS] [BUGS] BUG #3852: Could not create complex aggregate)

2008-01-07 Thread Darcy Buskermolen
t; packagers or release the source and have the binary packages ready later. Also to be fair I've seen no real announcement of RC1, probabbly because it's been bundled in with "security releases" for the other branched.. can we maybe do an RC1 announcement, let people ac

Re: [HACKERS] Simple thing to make pg_autovacuum more useful

2008-01-18 Thread Darcy Buskermolen
tirely, correct? > > > > Yup. > > Wait .reloptions is a column... how are we going to populate it and > array? ALTER TABLE foo SET autovacuum to true; ALTER TABLE foo SET autovacuum_naptime to '1min'; (or there about) I suppose we could also have pg_autovacuum becom

Re: [HACKERS] modules

2008-04-03 Thread Darcy Buskermolen
The PostgreSQL Company since 1997: http://www.commandprompt.com/ > PostgreSQL Community Conference: http://www.postgresqlconference.org/ > United States PostgreSQL Association: http://www.postgresql.us/ > Donate to the PostgreSQL Project: http://www.postgresql.org/about/donate -- Darcy Buskermo

Re: [HACKERS] Proof-of-concept for initdb-time shared_buffers selection

2003-07-04 Thread Darcy Buskermolen
is a bug fix. > > Michael I'm with you Michael/Tom on this one as well, Lets at least get this framework inplace, we can always experment with what values we settle on. -- Darcy Buskermolen Wavefire Technologies Corp. ph: 250.717.0200 fx: 250.763.1759 http://www.wavefire.com --

Re: [HACKERS] DB2's row_number()

2003-07-17 Thread Darcy Buskermolen
called first. > Is there an easy way to check that inside an "ordinary" C function > returning just one value? > Currently my function counts the number of times it has been called per > connection. I could write a second function for resetting the counter > but this is not to

Re: [HACKERS] Select distinct question ... complicated

2003-08-06 Thread Darcy Buskermolen
ady spent 7 hours on this one. > > Thanks a lot / Alex > > > > __ > Do you Yahoo!? > Yahoo! SiteBuilder - Free, easy-to-use web site design software > http://sitebuilder.yahoo.com > > ---(end of broadcast)--- > T

Re: [HACKERS] Transaction status in default psql prompt?

2003-09-03 Thread Darcy Buskermolen
ed transactions), this becomes most annoying when having to do a large manual set of updates and one gets sloppy with typing? -- Darcy Buskermolen Wavefire Technologies Corp. ph: 250.717.0200 fx: 250.763.1759 http://www.wavefire.com ---(end of broadcast)---

[HACKERS] misbehaving planer?

2006-10-20 Thread Darcy Buskermolen
13 | 427860 tbl_ps_type_14 | 353278 tbl_ps_type_15 | 195064 tbl_ps_type_16 | 244756 tbl_ps_type_17 | 1.17223e+06 tbl_ps_type_18 | 194896 tbl_ps_type_19 | 507272 tbl_ps_type_20 | 332233 tbl_ps_type_21 | 184148 tbl_ps_type_22 | 207495 tbl_ps_type_23 | 181174 tbl_ps_typ

Re: [HACKERS] misbehaving planer?

2006-10-20 Thread Darcy Buskermolen
On Friday 20 October 2006 08:26, Tom Lane wrote: > Darcy Buskermolen <[EMAIL PROTECTED]> writes: > > I have a setup in which a table has been partitioned into 30 partitions > > on type (1 -30), however no matter what I do i can't make the planner try > > to use co

Re: [HACKERS] misbehaving planer?

2006-10-20 Thread Darcy Buskermolen
On Friday 20 October 2006 09:27, Tom Lane wrote: > Darcy Buskermolen <[EMAIL PROTECTED]> writes: > > Yes CE is on (you can see it in the session paste). The other child > > tables have simular CHECK's of type=2, type=3, type=4 and so on.. 1 for > > each of the 30 ta

Re: [HACKERS] [GENERAL] Index greater than 8k

2006-10-31 Thread Darcy Buskermolen
e, then there is a bug - pls, make test suite demonstrating the > > problem. > > > >> Is recompiling the block size the option there? > >> What are the downsides, except for the custom build? > > > > Can you send exact error message? > > I am training this wee

Re: [HACKERS] [GENERAL] Index greater than 8k

2006-10-31 Thread Darcy Buskermolen
gerprint technique (http://webglimpse.net/pubs/TR93-33.pdf). It's pretty > close to trigrams and metrics of similarity is the same, but uses another > signature calculations. And, there are some tips and trics: removing HTML > marking,removing punctuation, lowercasing text and so on - it&

Re: [HACKERS] -f option for pg_dumpall

2007-01-05 Thread Darcy Buskermolen
On Friday 05 January 2007 09:40, Andrew Dunstan wrote: > Dave Page wrote: > > In pgAdmin we use pg_dump's -f option to write backup files. The IO > > streams are redirected to display status and errors etc. in the GUI. > > > > In order to enhance the interface to allow backup of entire clusters as

Re: [HACKERS] Autovacuum improvements

2007-01-14 Thread Darcy Buskermolen
On Sunday 14 January 2007 05:18, Alvaro Herrera wrote: > I've been thinnking how to improve autovacuum so that we can convince > more people that it can be enabled by default. Here are my thoughts. > There are two areas of improvements: > > 1. scheduling, and > 2. process handling, i.e., how to ha

Re: [HACKERS] Autovacuum improvements

2007-01-15 Thread Darcy Buskermolen
On Sunday 14 January 2007 08:45, Joshua D. Drake wrote: > > While we are talking autovacuum improvements, I'd like to also see some > > better logging, something that is akin to the important information of > > vacuum verbose being logged to a table or baring that the error_log. I'd > > like to be

Re: [HACKERS] Autovacuum improvements

2007-01-15 Thread Darcy Buskermolen
On Monday 15 January 2007 15:23, Joshua D. Drake wrote: > Darcy Buskermolen wrote: > > On Sunday 14 January 2007 08:45, Joshua D. Drake wrote: > >>> While we are talking autovacuum improvements, I'd like to also see some > >>> better logging, something that i

Re: [HACKERS] Autovacuum improvements

2007-01-16 Thread Darcy Buskermolen
On Monday 15 January 2007 15:13, Darcy Buskermolen wrote: > On Sunday 14 January 2007 08:45, Joshua D. Drake wrote: > > > While we are talking autovacuum improvements, I'd like to also see some > > > better logging, something that is akin to the important information of

Re: [HACKERS] [GENERAL] Autovacuum Improvements

2007-01-16 Thread Darcy Buskermolen
her topic. > > I'd like to hear other people's opinions on Darcy Buskermolen proposal > to have a log table, on which we'd register what did we run, at what > time, how long did it last, how many tuples did it clean, etc. I feel > having it on the regular text log is use

Re: [HACKERS] [GENERAL] Autovacuum Improvements

2007-01-19 Thread Darcy Buskermolen
On Friday 19 January 2007 01:47, Simon Riggs wrote: > On Tue, 2007-01-16 at 07:16 -0800, Darcy Buskermolen wrote: > > On Tuesday 16 January 2007 06:29, Alvaro Herrera wrote: > > > elein wrote: > > > > Have you made any consideration of providing feedback on autovacu

[HACKERS] high CPU usage for stats collector in 8.2

2007-02-27 Thread Darcy Buskermolen
.conf parameters stats_command_string = off stats_start_collector = on stats_block_level = on stats_row_level = on -- Darcy Buskermolen Command Prompt, Inc. Sales/Support: +1.503.667.4564 || 24x7/Emergency: +1.800.492.2240 PostgreSQL solutions since 1997 http://www.commandprompt.com/

Re: [HACKERS] Possible Bug: high CPU usage for stats collector in 8.2

2007-03-01 Thread Darcy Buskermolen
On Wednesday 28 February 2007 14:31, Joshua D. Drake wrote: > Joshua D. Drake wrote: > > Darcy Buskermolen wrote: > >> I'm observing high CPU usage (95%) of a 2.6GHz opteron by the stats > >> collector on an 8.2.3 box investigation has lead me to belive that the

Re: [HACKERS] Possible Bug: high CPU usage for stats collector in 8.2

2007-03-02 Thread Darcy Buskermolen
On Thursday 01 March 2007 11:57, Tom Lane wrote: > Darcy Buskermolen <[EMAIL PROTECTED]> writes: > > I'm observing high CPU usage (95%) of a 2.6GHz opteron by the stats > > collector on an 8.2.3 box investigation has lead me to belive that the > > stats file is wr

Re: [HACKERS] Progress bar updates

2006-07-19 Thread Darcy Buskermolen
(end of broadcast)------- > TIP 3: Have you checked our extensive FAQ? > >http://www.postgresql.org/docs/faq -- Darcy Buskermolen Wavefire Technologies Corp. http://www.wavefire.com ph: 250.717.0200 fx: 250.763.1759 ---(end of broadcast)--- TIP 5: don't forget to increase your free space map settings

Re: [HACKERS] Units in postgresql.conf

2006-07-20 Thread Darcy Buskermolen
ted, I'd just revert to the default > behavior. This is probably what we'd want to do in PostgreSQL as > well. > > The only issue in PostgreSQL is knowing what the unit conversion and > scaling factor is for each parameter (8K, 1K, milliseconds, etc); > though, this wou

Re: [HACKERS] [PATCHES] [PATCH] Provide 8-byte transaction IDs to user level

2006-07-26 Thread Darcy Buskermolen
versions older than it was ported into) before we would make use of it. > > regards, tom lane > > ---(end of broadcast)--- > TIP 2: Don't 'kill -9' the postmaster -- Darcy Buskermolen CommandPrompt, Inc.

Re: [HACKERS] [PATCHES] [PATCH] Provide 8-byte transaction IDs to user level

2006-07-26 Thread Darcy Buskermolen
On Wednesday 26 July 2006 14:03, Tom Lane wrote: > Darcy Buskermolen <[EMAIL PROTECTED]> writes: > >> The question though is if we did that, would Slony actually use it? > > > > If it made sence to do it, then yes we would do it. The problem ends up > > bein

Re: [HACKERS] [PATCHES] [PATCH] Provide 8-byte transaction IDs to user level

2006-07-27 Thread Darcy Buskermolen
On Wednesday 26 July 2006 14:27, Darcy Buskermolen wrote: > On Wednesday 26 July 2006 14:03, Tom Lane wrote: > > Darcy Buskermolen <[EMAIL PROTECTED]> writes: > > >> The question though is if we did that, would Slony actually use it? > > > > > > If it

[HACKERS] Bug in sql_fmgr when envoked via copy

2006-08-04 Thread Darcy Buskermolen
ing=0x854a01c "copy sql_table from stdin;") at postgres.c:1004 #15 0x081c4116 in PostgresMain (argc=4, argv=0x840b680, username=0x840b650 "pgsql") at postgres.c:3182 #16 0x0819d898 in ServerLoop () at postmaster.c:2845 #17 0x0819ed59 in PostmasterMain (argc=1, argv=0xbfbfed5c

[HACKERS] New beginings

2006-08-14 Thread Darcy Buskermolen
Dear Community members, It is with great enthuasim I announce that I have accepted an offer from Joshua D. Drake of Command Prompt Inc, to join his team. As former Vice President of Software Development with Wavefire Technologies Corp, I endeavor to leverage over 10 years of technical experti

Re: [HACKERS] Chocked

2005-07-29 Thread Darcy Buskermolen
ot;The world's most popular open source database" > > Isn't it the title for postgresql? > > It seems weird for both projects to have the same claim (although it's > true for postgreql...) > > Regards -- Darcy Buskermolen Wavefire Technolog

Re: [HACKERS] [GENERAL] Cascades Failing

2005-08-17 Thread Darcy Buskermolen
nting me from upgrading a couple of 7.4 boxen to 8.x, if you need testers for this patch, please let me know and I'll be glad to try it out and see if it solves the cascade problems I am experiencing. > > ---(end of broadcast)--- > TIP 2: Don't 'kill -9' th

Re: [HACKERS] distributed performance testing

2005-08-22 Thread Darcy Buskermolen
ownside is it requires dbt, but that doesn't seem to be a major > issue. Also, using dbt means we can test different use cases (dbt2 ~= > TPC-C, dbt3 ~= TPC-H, etc), while pgbench is just a single benchmark. And there is always http://pgfoundry.org/projects/tpc-w-php/ for a ~=

Re: [HACKERS] tablespaces and DB administration

2004-05-27 Thread Darcy Buskermolen
eferably on different I/O channels is proveable nonsense and you > should know that. One other huge advantage that tablespaces will bring, it the ability to place data based on "cost" ie, you can put your 10 most used tables on fast disk (or perhaps solid state devices), and move the

Re: [HACKERS] [COMMITTERS] pgsql-server: Clean up generation of default

2004-06-11 Thread Darcy Buskermolen
or our app, since we would no longer have to > have hard-coded sequence names in our code. (For getting last sequence > val on oid-less tables) > > Chris -- Darcy Buskermolen Wavefire Technologies Corp. ph: 250.717.0200 fx: 250.763.1759 http://www.wavefire.com ---(end of broadcast)--- TIP 7: don't forget to increase your free space map settings

Re: [HACKERS] 8.0 Open Items

2004-08-20 Thread Darcy Buskermolen
p a full and proper solution the real problem. > * have plpython reject pseudotype arguments because it crashes > * add i386 solaris spinlock code -- Darcy Buskermolen Wavefire Technologies Corp. ph: 250.717.0200 fx: 250.763.1759 http://www.wavefire.com --

Re: [HACKERS] 8.0 Open Items

2004-08-23 Thread Darcy Buskermolen
On August 20, 2004 09:01 pm, Bruce Momjian wrote: > Tom Lane wrote: > > Bruce Momjian <[EMAIL PROTECTED]> writes: > > > Darcy Buskermolen wrote: > > >>> * remove to_char(interval) if we initdb or mention removal > > >> > > >> I vot

[HACKERS] Effective Cache Size

2004-08-24 Thread Darcy Buskermolen
a boon or a bust to the planner/optimizer. -- Darcy Buskermolen Wavefire Technologies Corp. ph: 250.717.0200 fx: 250.763.1759 http://www.wavefire.com ---(end of broadcast)--- TIP 2: you can get off all lists at once with the unregister command

Re: [pgsql-hackers-win32] [HACKERS] Win32 release warning

2004-08-26 Thread Darcy Buskermolen
s Have the installer automagiclay http-post the required info (that they filled in) ? -- Darcy Buskermolen Wavefire Technologies Corp. ph: 250.717.0200 fx: 250.763.1759 http://www.wavefire.com ---(end of broadcast)--- TIP 3: if posting/reading thro

Re: [HACKERS] gettimeofday() goes backwards on FreeBSD 4.9

2003-11-28 Thread Darcy Buskermolen
rintf(stderr, "out of order tv_usec: %ld %ld, prev %ld > %ld\n", > (long int) curtime.tv_sec, > (long int) curtime.tv_usec, > (long int) prevtime.tv_sec, >

Re: [HACKERS] gettimeofday() goes backwards on FreeBSD 4.9

2003-11-28 Thread Darcy Buskermolen
- snip Further to my last email, after 30 minutes of running I was able to get simular behavior off the 5.2 test system. -- Darcy Buskermolen Wavefire Technologies Corp. ph: 250.717.0200 fx: 250.763.1759 http://www.wavefire.com ---(end of broadcast)--

Re: [HACKERS] gettimeofday() goes backwards on FreeBSD 4.9

2003-11-28 Thread Darcy Buskermolen
order tv_sec: 1070064937 497925, prev 1070064241 411391 > out of order tv_sec: 1070064251 811548, prev 1070064947 337739 > <--- out of order tv_sec: 1070064947 508364, prev 1070064251 811548 > out of order tv_usec: 1070064947 508364, prev 1070064251 811548 > > Ma

Re: [HACKERS] Anyone want to admit to being presinet.com?

2006-02-13 Thread Darcy Buskermolen
, ie, one not pointing back > > at yourself. > > The really amusing thing is that presinet.com claim to be "Network Security > Experts". Security through effective banning of incoming mail.. At least they don't claim to be email delevery experts ;-) -- Darcy Bus

Re: [HACKERS] [COMMITTERS] pgsql: Remove Christof Petig copyright on include file,

2006-03-10 Thread Darcy Buskermolen
ls in our source > > > tree. If Jan's is in there, it should be removed too (with his > > > approval). The only copyright holder should be PostgreSQL Global > > > Development Group. > > > > > > Jan, would you fix that? > > > > We've been the

Re: [HACKERS] qsort, once again

2006-03-16 Thread Darcy Buskermolen
(end of broadcast)------- > TIP 5: don't forget to increase your free space map settings -- Darcy Buskermolen Wavefire Technologies Corp. http://www.wavefire.com ph: 250.717.0200 fx: 250.763.1759 ---(end of broadcast)--- TIP 6: explain analyze is your friend

Re: [HACKERS] Seperate command-line histories for seperate databases

2006-03-17 Thread Darcy Buskermolen
that. I'd not be all that > keen on the change... I'm with Chris on this one, I routinly execute the same command on 6 or 7 of our databases, all from the same management consol. I would find a change of this sort soemewhat frustrating, I'd probably be inclined to symlink all

Re: [HACKERS] How to put back??

2006-03-22 Thread Darcy Buskermolen
-- > TIP 4: Have you searched our list archives? > > http://archives.postgresql.org -- Darcy Buskermolen Wavefire Technologies Corp. http://www.wavefire.com ph: 250.717.0200 fx: 250.763.1759 ---(end of broadcast)--- TIP 6: explain analyze is your friend

Re: [HACKERS] Accessing schema data in information schema

2006-03-22 Thread Darcy Buskermolen
with documentation notes that this will be deprecated in favor of information_schema in an upcoming release ? > > Plan C would be to say that we don't need to preserve "SELECT * FROM > seqname", but I'll bet there would be some hollering. ? > >

Re: [HACKERS] Exposing DEFAULT_PGSOCKET_DIR via a libpq function?

2006-03-28 Thread Darcy Buskermolen
--version output (or some other > switch, I'm agnostic). > > for those weird times when some distro changes it, and you then > overwrite parts of it, > it would be useful for diagnostics. is it not shown by, (if it's not default of /tmp) ? pg_config --configure > &g

Re: [HACKERS] 8.1.3 and unused files

2006-05-05 Thread Darcy Buskermolen
gers. No, there are no calls to exit() in the database loaded funcs. > > regards, tom lane > > ---(end of broadcast)--- > TIP 5: don't forget to increase your free space map settings -- Darcy Buskermole

Re: [HACKERS] 8.1 release notes

2005-08-23 Thread Darcy Buskermolen
an connect as as a specific uesr or to a specific database. Setting the limit to zero disables user or database connections. -- Darcy Buskermolen Wavefire Technologies Corp. http://www.wavefire.com ph: 250.717.0200 fx: 250.763.1759 ---(end of broadcast)---

Re: [HACKERS] 8.1 release notes

2005-08-23 Thread Darcy Buskermolen
view and for beta1. I will work on it more tomorrow. Also I think Allow TRUNCATE to truncate multiple files in a single command (Alvaro) Should read tables or relations not files. -- Darcy Buskermolen Wavefire Technologies Corp. http://www.wavefire.com ph: 250.717.020

Re: [HACKERS] Version number in psql banner

2005-09-01 Thread Darcy Buskermolen
banner should say something along the lines of "psql client version foo connected to server bar version sfoo" -- Darcy Buskermolen Wavefire Technologies Corp. http://www.wavefire.com ph: 250.717.0200 fx: 250.763.1759 ---(end of broadcast)---

Re: [HACKERS] pg_config/share_dir

2005-09-07 Thread Darcy Buskermolen
gt; > Why would they need pkglibdir either? I was asked about this by an > author who wanted to use it to find where to put module config/setup > scripts. > > cheers > > andrew > > ---(end of broadcast)--- > TIP 3: Have you c

Re: [HACKERS] pg_config/share_dir

2005-09-08 Thread Darcy Buskermolen
andidate to be the dir we are infact after.. -- Darcy Buskermolen Wavefire Technologies Corp. http://www.wavefire.com ph: 250.717.0200 fx: 250.763.1759 ---(end of broadcast)--- TIP 6: explain analyze is your friend

Re: [HACKERS] pg_config/share_dir

2005-09-08 Thread Darcy Buskermolen
On Wednesday 07 September 2005 17:31, Andrew Dunstan wrote: > Darcy Buskermolen wrote: > >On Wednesday 07 September 2005 15:52, Andrew Dunstan wrote: > >>Peter Eisentraut wrote: > >>>Andrew Dunstan wrote: > >>>>pg_config doesn't currently se

Re: [HACKERS] US Census database (Tiger 2004FE) - 4.4G

2005-09-15 Thread Darcy Buskermolen
t; > I'll mail a DVD to two people who promise to host it for Hackers. I'm wondering if this is now available for consumption by the rest of us?? (ie what's the link) -- Darcy Buskermolen Wavefire Technologies Corp. http://www.wavefire.com ph: 250.717.0200 fx: 25

Re: [HACKERS] [PATCHES] Work-in-progress referential action trigger

2005-10-13 Thread Darcy Buskermolen
--------(end of broadcast)--- > TIP 3: Have you checked our extensive FAQ? > >http://www.postgresql.org/docs/faq -- Darcy Buskermolen Wavefire Technologies Corp. http://www.wavefire.com ph: 250.717.0200 fx: 250.763.1759 ---(end of broadcast)--- TIP 2: Don't 'kill -9' the postmaster

Re: [HACKERS] Obtaining a source tree from CVS

2005-11-10 Thread Darcy Buskermolen
s, > Gustavo -- Darcy Buskermolen Wavefire Technologies Corp. http://www.wavefire.com ph: 250.717.0200 fx: 250.763.1759 ---(end of broadcast)--- TIP 1: if posting/reading through Usenet, please send an appropriate subscribe-nomail co

Re: [HACKERS] [BUGS] BUG #2052: Federal Agency Tech Hub Refuses to Accept

2005-11-24 Thread Darcy Buskermolen
: http://httpd.apache.org/security_report.html -- Darcy Buskermolen Wavefire Technologies Corp. http://www.wavefire.com ph: 250.717.0200 fx: 250.763.1759 ---(end of broadcast)--- TIP 4: Have you searched our list archives? http://archives.postgresql.org

Re: [HACKERS] Foreign key trigger timing bug?

2005-12-07 Thread Darcy Buskermolen
we > fixed it in 8.1. No it's not yet resolved. -- Darcy Buskermolen Wavefire Technologies Corp. http://www.wavefire.com ph: 250.717.0200 fx: 250.763.1759 ---(end of broadcast)--- TIP 4: Have you searched our list archives? http://archives.postgresql.org

Re: [HACKERS] HOOKS for Synchronous Replication?

2005-12-08 Thread Darcy Buskermolen
- > TIP 9: In versions below 8.0, the planner will ignore your desire to >choose an index scan if your joining column's datatypes do not >match -- Darcy Buskermolen Wavefire Technologies Corp. http://www.wavefire.com ph: 250.717.0200 fx: 250.763.175

[HACKERS] VACUUM FULL taking accessivly long.

2004-09-14 Thread Darcy Buskermolen
23 0x814570d in PostmasterMain (argc=1, argv=0x82b6030) at postmaster.c:891 #24 0x811a885 in main (argc=1, argv=0xbfbffcac) at main.c:214 Please let me know if you require any other information. -- Darcy Buskermolen Wavefire Technologies Corp. ph: 250.717.0200 fx: 250.763.1759 http://www.wavefire.com ---(end of broadcast)--- TIP 7: don't forget to increase your free space map settings

[HACKERS] -HEAD build failure on AIX 4.3.3 PPC

2004-09-30 Thread Darcy Buskermolen
s error can easily be solved by adding an #include to src/port/isinf.c ---(end of broadcast)--- TIP 7: don't forget to increase your free space map settings -- Darcy Buskermolen Wavefire Technologies Corp. ph:

Re: [HACKERS] AIX and V8 beta 3

2004-10-01 Thread Darcy Buskermolen
317 ERROR: Undefined symbol: .pthread_mutex_unlock > > ld: 0711-345 Use the -bloadmap or -bnoquiet option to obtain more > > information. > > collect2: ld returned 8 exit status > > make[3]: *** [pg_ctl] Error 1 > > > > > > Brad. > > > > --

[HACKERS] -HEAD contrib/dblink regress failure on SPARC/Solaris 8

2004-10-20 Thread Darcy Buskermolen
The buildfarm has identified yet another failure under SPARC/Solaris 8 as outlined in. http://oicu.homedns.org:81/cgi/show_log.pl?nm=potorooo&dt=2004-10-20%2002:30:01 dblink causeing PG to die with sig11 -- Darcy Buskermolen Wavefire Technologies Corp. ph: 250.717.0200 fx: 250.763.1759

Re: [HACKERS] Beta 4 on Debian Sarge (MIPS/MIPSEL)

2004-10-28 Thread Darcy Buskermolen
gt; ---(end of broadcast)--- > TIP 2: you can get off all lists at once with the unregister command > (send "unregister YourEmailAddressHere" to [EMAIL PROTECTED]) -- Darcy Buskermolen Wavefire Technologies Corp. ph: 250.717.0200 fx: 250.763.1759 http:

Re: [HACKERS] -HEAD contrib/dblink regress failure on SPARC/Solaris 8

2004-10-28 Thread Darcy Buskermolen
so.1 #3 0xff0266c4 in getConnectionByName (name=0xffbee8a8 "") at dblink.c:2032 (gdb) -- Darcy Buskermolen Wavefire Technologies Corp. ph: 250.717.0200 fx: 250.763.1759 http://www.wavefire.com ---(end of broadcast)--- TIP 6: Hav

Re: [HACKERS] -HEAD contrib/dblink regress failure on SPARC/Solaris 8

2004-10-28 Thread Darcy Buskermolen
On October 28, 2004 03:32 pm, Tom Lane wrote: > Darcy Buskermolen <[EMAIL PROTECTED]> writes: > > On October 20, 2004 10:26 am, you wrote: > >> The buildfarm has identified yet another failure under SPARC/Solaris 8 > >> as outlined in. > > Most likely thi

Re: [HACKERS] OpenBSD/Sparc status

2004-11-23 Thread Darcy Buskermolen
gt; float f; > char *t; > } y; > > y.f = returnfloat(&x); > > printf("x = %g\n", x); > printf("y = %g\n", y.f); > > return 0; > } > > ---(end of broadcas

Re: [HACKERS] OpenBSD/Sparc status

2004-11-23 Thread Darcy Buskermolen
On November 23, 2004 11:37 am, Jim Seymour wrote: > Stefan Kaltenbrunner <[EMAIL PROTECTED]> wrote: > > Darcy Buskermolen wrote: > > > On November 19, 2004 10:55 am, you wrote: > > >>The answer is: it's a gcc bug. The attached program should print > >

Re: [HACKERS] OpenBSD/Sparc status

2004-11-24 Thread Darcy Buskermolen
On November 23, 2004 06:18 pm, Michael Fuhr wrote: > On Tue, Nov 23, 2004 at 12:47:28PM -0800, Darcy Buskermolen wrote: > > I'm guessing we need to add some more configure logic to detect gcc > > versions 3.4 on sparc trying to produce 64bit code and disable > > optimizat

Re: [HACKERS] OK, ready for RC1 or Beta6

2004-12-03 Thread Darcy Buskermolen
src/interfaces/libpq/fe-secure.c?f=h;rev=1.60 and other than that I see noting on the build far that is questionable (other than the win32 regres test notice) > > > Sincerely, > > Joshua D. Drake -- Darcy Buskermolen Wavefire Technologies Corp. ph: 250.717.0200 fx: 250.763.1759 http://www.wavefire.com ---(end of broadcast)--- TIP 7: don't forget to increase your free space map settings

Re: [HACKERS] OK, ready for RC1 or Beta6

2004-12-03 Thread Darcy Buskermolen
On December 3, 2004 11:14 am, Tom Lane wrote: > Darcy Buskermolen <[EMAIL PROTECTED]> writes: > > On December 3, 2004 10:31 am, you wrote: > >> 2. There are critical notices on buildfarm for some more popular > >> platforms such as Solaris 9 and Open BSD. > >

[HACKERS] --prefix="/Program\ Files" and build failures

2004-12-03 Thread Darcy Buskermolen
th': path.c:411: warning: unknown escape sequence `\ ' path.c:411: warning: unknown escape sequence `\ ' -- Darcy Buskermolen Wavefire Technologies Corp. ph: 250.717.0200 fx: 250.763.1759 http://www.wavefire.com ---(end of broadcast)--- TIP 7: don't forget to increase your free space map settings

[HACKERS] port report: [FAILURE] FreeBSD 6, Intel icc7

2004-12-16 Thread Darcy Buskermolen
As per http://www.pgbuildfarm.org/cgi-bin/show_log.pl?nm=herring&dt=2004-12-16%2018:46:18 This combination of OS/compiler does not result in a working copy. Andrew and i have been digging into this for better than a week now, and something just dosent look right. -- Darcy Buskerm

Re: [HACKERS] port report: [FAILURE] FreeBSD 6, Intel icc7

2004-12-16 Thread Darcy Buskermolen
On December 16, 2004 12:37 pm, Tom Lane wrote: > Darcy Buskermolen <[EMAIL PROTECTED]> writes: > > As per > > http://www.pgbuildfarm.org/cgi-bin/show_log.pl?nm=herring&dt=2004-12-16%2 > >018:46:18 This combination of OS/compiler does not result in a worki

Re: [HACKERS] port report: [FAILURE] FreeBSD 6, Intel icc7

2004-12-16 Thread Darcy Buskermolen
On December 16, 2004 02:28 pm, Tom Lane wrote: > Darcy Buskermolen <[EMAIL PROTECTED]> writes: > > On December 16, 2004 12:37 pm, Tom Lane wrote: > >> I think you are in need of the local equivalent to GNU ld's -E or > >> --export-dynamic switch, ie, ma

[HACKERS] buildfarm build failure: icc7 + --enable-cassert

2004-12-10 Thread Darcy Buskermolen
It looks like --enable-cassert isn't handled properly under icc7 http://www.pgbuildfarm.org/cgi-bin/show_log.pl?nm=herring&dt=2004-12-07%2016:30:44 -- Darcy Buskermolen Wavefire Technologies Corp. ph: 250.717.0200 fx: 250.763.1759 http://www.wavefire.com -

Re: [HACKERS] port report: [FAILURE] FreeBSD 6, Intel icc7

2004-12-16 Thread Darcy Buskermolen
On December 16, 2004 01:49 pm, Bruce Momjian wrote: > Andrew Dunstan wrote: > > Bruce Momjian wrote: > > >Darcy Buskermolen wrote: > > >>As per > > >>http://www.pgbuildfarm.org/cgi-bin/show_log.pl?nm=herring&dt=2004-12-16 > > >>%2018:4

Re: [HACKERS] port report: [FAILURE] FreeBSD 6, Intel icc7

2004-12-21 Thread Darcy Buskermolen
On December 16, 2004 04:29 pm, Tom Lane wrote: > Darcy Buskermolen <[EMAIL PROTECTED]> writes: > > On December 16, 2004 12:37 pm, Tom Lane wrote: > > I think you are in need of the local equivalent to GNU ld's -E or > > --export-dynamic switch, ie, make sure that a

Re: [HACKERS] port report: [FAILURE] FreeBSD 6, Intel icc7

2004-12-21 Thread Darcy Buskermolen
On December 21, 2004 09:50 am, Tom Lane wrote: > Darcy Buskermolen <[EMAIL PROTECTED]> writes: > > On December 16, 2004 04:29 pm, Tom Lane wrote: > >> Hmm. I see in Makefile.freebsd: > >> > >> ifdef ELF_SYSTEM > >> export_dynamic = -export-dyn

Re: [HACKERS] port report: [FAILURE] FreeBSD 6, Intel icc7 SUCESS

2004-12-21 Thread Darcy Buskermolen
On December 21, 2004 10:58 am, Tom Lane wrote: > Darcy Buskermolen <[EMAIL PROTECTED]> writes: > > So it looks like icc dosn't like -export-dynamic > > Patch applied, let us know how it goes ... Buildfarm member herring now passes all checks

[HACKERS] IBM releases 500 patents

2005-01-11 Thread Darcy Buskermolen
IBM has just announced they are waving all rights and providing access to 500 patents. In the list of 500 there are several that relate RDBMS and query optimizations, it may be worth a look. http://www.ibm.com/news/us/en/2005/01/patents.html -- Darcy Buskermolen Wavefire Technologies Corp

Re: [HACKERS] IBM releases 500 patents

2005-01-11 Thread Darcy Buskermolen
On January 11, 2005 08:13 am, you wrote: > Darcy Buskermolen wrote: > >IBM has just announced they are waving all rights and providing access to > > 500 patents. In the list of 500 there are several that relate RDBMS and > > query optimizations, it may be worth a

Re: [HACKERS] IBM releases 500 patents

2005-01-11 Thread Darcy Buskermolen
On January 11, 2005 08:32 am, Darcy Buskermolen wrote: > On January 11, 2005 08:13 am, you wrote: > > Darcy Buskermolen wrote: > > >IBM has just announced they are waving all rights and providing access > > > to 500 patents. In the list of 500 there are several that r

Re: [HACKERS] IBM releases 500 patents

2005-01-11 Thread Darcy Buskermolen
On January 11, 2005 08:34 am, Alvaro Herrera wrote: > On Tue, Jan 11, 2005 at 08:13:01AM -0800, Joshua D. Drake wrote: > > Darcy Buskermolen wrote: > > >IBM has just announced they are waving all rights and providing access > > > to 500 patents. In the list of 500 th

Re: [HACKERS] [COMMITTERS] pgsql: Disallow LOAD to non-superusers.

2005-01-24 Thread Darcy Buskermolen
can roll the icc compiler fixes -WI (if I recall right) into there as well? > > regards, tom lane > > ---(end of broadcast)--- > TIP 7: don't forget to increase your free space map settings -- Da

[HACKERS] cvs TIP, tsearch2 and Solaris 8 Sparc

2005-01-26 Thread Darcy Buskermolen
Hello, It looks like teodor's latest commits to tseach2 has broken building on SPARC solaris 8. See http://pgbuildfarm.org/cgi-bin/show_log.pl?nm=potorooo&dt=2005-01-26%2008:30:02 for more details. -- Darcy Buskermolen Wavefire Technologies Corp. ph: 250.717.0200 fx: 250.763.

[HACKERS] -HEAD on FreeBSD 6-CURRENT build failures

2005-01-28 Thread Darcy Buskermolen
There looks to be an issue with gram.y as seen in the following 2 FreeBSD6 boxen: http://pgbuildfarm.org/cgi-bin/show_log.pl?nm=herring&dt=2005-01-28%2018:33:43 http://pgbuildfarm.org/cgi-bin/show_log.pl?nm=echidna&dt=2005-01-28%2018:30:01 -- Darcy Buskermolen Wavefire Technologies

  1   2   >