Re: [HACKERS] Build farm

2003-11-24 Thread Jim C. Nasby
much better. Would it be reasonable to promote users testing daily snapshots with popular applications? I'm guessing there's not many applications that have automated test frameworks, but any that do would theoretically provide another good test of PGSQL changes. -- Jim C. Nasby, Database

Re: [HACKERS] Release cycle length

2003-11-24 Thread Jim C. Nasby
while the old version is still live. With some sophisticated middleware, you could theoretically migrate without any downtime. -- Jim C. Nasby, Database Consultant [EMAIL PROTECTED] Member: Triangle Fraternity, Sports Car Club of America Give your computer some brain candy

Re: [HACKERS] Release cycle length

2003-12-08 Thread Jim C. Nasby
Any chance you might be able to put together a HOWTO on this? I think it would be extremely valuable to a lot of people. On Tue, Nov 25, 2003 at 11:25:34PM -0500, Andrew Sullivan wrote: On Mon, Nov 24, 2003 at 11:08:44PM -0600, Jim C. Nasby wrote: Has anyone looked at using replication

Re: [HACKERS] RFC: Security documentation

2004-02-11 Thread Jim C. Nasby
, such a guide could serve both experienced DBAs as well as people who are very new to databases, since every database has it's own prefered way of doing things. -- Jim C. Nasby, Database Consultant [EMAIL PROTECTED] Member: Triangle Fraternity, Sports Car Club of America Give your

Re: [HACKERS] [pgsql-advocacy] What can we learn from MySQL?

2004-04-23 Thread Jim C. Nasby
enterprise-class features in, like multi-master replication, partitioning, and clustering. But since people tend to think most about the technology, I'm sure those will make it in eventually anyway. :) -- Jim C. Nasby, Database Consultant [EMAIL PROTECTED] Member: Triangle Fraternity

Re: [HACKERS] More Hashing questions

2004-05-06 Thread Jim C. Nasby
-- Jim C. Nasby, Database Consultant [EMAIL PROTECTED] Member: Triangle Fraternity, Sports Car Club of America Give your computer some brain candy! www.distributed.net Team #1828 Windows: Where do you want to go today? Linux: Where do you want to go tomorrow? FreeBSD: Are you

Re: [HACKERS] Usability, MySQL, Postgresql.org, gborg, contrib, etc.

2004-04-26 Thread Jim C. Nasby
database procedural languages to pickup. Asking a DBA to learn java or perl or PHP is asking a lot. If anything I'd like to see more features brought into plpgsql, like packages (ala Oracle). -- Jim C. Nasby, Database Consultant [EMAIL PROTECTED] Member: Triangle Fraternity, Sports

Re: [HACKERS] What can we learn from MySQL?

2004-04-26 Thread Jim C. Nasby
of broadcast)--- TIP 8: explain analyze is your friend -- Jim C. Nasby, Database Consultant [EMAIL PROTECTED] Member: Triangle Fraternity, Sports Car Club of America Give your computer some brain candy! www.distributed.net Team #1828 Windows: Where do

Re: [HACKERS] Usability, MySQL, Postgresql.org, gborg, contrib,

2004-04-27 Thread Jim C. Nasby
, by standard, I meant installed by default, not to the exclusion of all else. I would still argue that if any language should be installed by default it should be plpgsql and not java. As I mentioned, everyone using a database already knows SQL; not nearly as many know java. -- Jim C. Nasby, Database

Re: [HACKERS] Usability, MySQL, Postgresql.org, gborg, contrib,

2004-04-27 Thread Jim C. Nasby
someone who is more of a coder than a DBA might disagree. -- Jim C. Nasby, Database Consultant [EMAIL PROTECTED] Member: Triangle Fraternity, Sports Car Club of America Give your computer some brain candy! www.distributed.net Team #1828 Windows: Where do you want to go today

Re: [HACKERS] PITR Phase 2 - Design Planning

2004-04-27 Thread Jim C. Nasby
a log viewer with enough detail, that would suffice; otherwise you'd need to test for some specific condition. Of course timestamps would still be useful in this scenario since they can get you close to the transaction in question. -- Jim C. Nasby, Database Consultant [EMAIL

Re: [HACKERS] Frequently updated tables

2004-06-09 Thread Jim C. Nasby
dead tuples? I am guessing you mean the latter, but best to be sure :-) The best phrasing would be the accumulating overhead of deletes and updates. Yes. Doesn't pg_autovacuum largely take care of this issue? -- Jim C. Nasby, Database Consultant [EMAIL PROTECTED] Member

Re: [HACKERS] Anybody have an Oracle PL/SQL reference at hand?

2004-08-02 Thread Jim C. Nasby
it yourself. CREATE OR REPLACE PACKAGE symer AS en_missing_data CONSTANT NUMBER := -20999; exc_missing_data EXCEPTION; PRAGMA EXCEPTION_INIT (exc_missing_data, -20999); END; -- Jim C. Nasby, Database Consultant [EMAIL PROTECTED] Member: Triangle Fraternity, Sports

Re: [HACKERS] Anybody have an Oracle PL/SQL reference at hand?

2004-08-03 Thread Jim C. Nasby
deciding on a system to handle it. On Mon, Aug 02, 2004 at 09:24:29PM -0400, Tom Lane wrote: Jim C. Nasby [EMAIL PROTECTED] writes: Oracle defines very few named exceptions. Instead, the intention is that you define a name for a numeric exception and use it yourself. Yeah, I noticed

Re: [HACKERS] Anybody have an Oracle PL/SQL reference at hand?

2004-08-03 Thread Jim C. Nasby
abort the transaction, they might rollback whatever work the command that failed had done; I'm not really sure how that's handled. -- Jim C. Nasby, Database Consultant [EMAIL PROTECTED] Give your computer some brain candy! www.distributed.net Team #1828 Windows: Where do you want

Re: [HACKERS] Anybody have an Oracle PL/SQL reference at hand?

2004-08-04 Thread Jim C. Nasby
this internally would be much more performant than using pgsql for it. Chris ---(end of broadcast)--- TIP 2: you can get off all lists at once with the unregister command (send unregister YourEmailAddressHere to [EMAIL PROTECTED]) -- Jim C. Nasby

Re: [HACKERS] Calling PL functions with named parameters

2004-08-13 Thread Jim C. Nasby
: explain analyze is your friend -- Jim C. Nasby, Database Consultant [EMAIL PROTECTED] Give your computer some brain candy! www.distributed.net Team #1828 Windows: Where do you want to go today? Linux: Where do you want to go tomorrow? FreeBSD: Are you guys coming, or what

Re: [HACKERS] Calling PL functions with named parameters

2004-08-13 Thread Jim C. Nasby
number of overloaded functions when functions are created, to ensure it can always resolve what function to call. IOW, their function resolution code treats a(int, int default 0) as being equivalent to a(int) and a(int, int). -- Jim C. Nasby, Database Consultant [EMAIL PROTECTED] Give

Re: [HACKERS] Thesis on PostgreSQL

2004-09-03 Thread Jim C. Nasby
if there was such a thing :). PostgreSQL would also be a generation or two behind Oracle. -- Jim C. Nasby, Database Consultant [EMAIL PROTECTED] Give your computer some brain candy! www.distributed.net Team #1828 Windows: Where do you want to go today? Linux: Where do you want to go

Re: [HACKERS] Thesis on PostgreSQL

2004-09-04 Thread Jim C. Nasby
On Sat, Sep 04, 2004 at 09:24:04AM -0400, D'Arcy J.M. Cain wrote: On Fri, 3 Sep 2004 15:11:54 -0500 Jim C. Nasby [EMAIL PROTECTED] wrote: I'm not aware of any generally accepted definitions of generations of database management systems. Nor am I, but I'd say MySQL would be at least

Re: [HACKERS] APR 1.0 released

2004-09-14 Thread Jim C. Nasby
that follows exactly this model). -- Pip-pip Sailesh http://www.cs.berkeley.edu/~sailesh ---(end of broadcast)--- TIP 4: Don't 'kill -9' the postmaster -- Jim C. Nasby, Database Consultant [EMAIL PROTECTED] Give your

[HACKERS] 'TID index'

2004-09-15 Thread Jim C. Nasby
cause contention issues. -- Jim C. Nasby, Database Consultant [EMAIL PROTECTED] Give your computer some brain candy! www.distributed.net Team #1828 Windows: Where do you want to go today? Linux: Where do you want to go tomorrow? FreeBSD: Are you guys coming, or what

Re: [HACKERS] 'TID index'

2004-09-15 Thread Jim C. Nasby
(something I could probably do)? -- Jim C. Nasby, Database Consultant [EMAIL PROTECTED] Give your computer some brain candy! www.distributed.net Team #1828 Windows: Where do you want to go today? Linux: Where do you want to go tomorrow? FreeBSD: Are you guys coming, or what

Re: [HACKERS] SQL-Invoked Procedures for 8.1

2004-09-23 Thread Jim C. Nasby
; Though, I would prefer if you could define internal procedures/functions *after* the main code; I think it would greatly improve readability. I'm not suggesting you try and implement these features now, but you might want to consider what impact they might have on your design. -- Jim C. Nasby

Re: [HACKERS] SQL-Invoked Procedures for 8.1

2004-09-24 Thread Jim C. Nasby
is it's less work/code. The advantage to Oracle is there's no ambiguity. -- Jim C. Nasby, Database Consultant [EMAIL PROTECTED] Give your computer some brain candy! www.distributed.net Team #1828 Windows: Where do you want to go today? Linux: Where do you want to go tomorrow

Re: Reviving Time Travel (was Re: [HACKERS] 'TID index')

2004-09-30 Thread Jim C. Nasby
there which I remember being discussed was having the page-write daemon do a vacuum of a page before it's written; has this been done already? -- Jim C. Nasby, Database Consultant [EMAIL PROTECTED] Give your computer some brain candy! www.distributed.net Team #1828 Windows: Where do

Re: Reviving Time Travel (was Re: [HACKERS] 'TID index')

2004-09-30 Thread Jim C. Nasby
is the vacuum running later, having to bring in the base data page, and then all the indexes anyway. But once there is a list of pages with dead tuples only one read and one write would be saved, which probably isn't worth the extra code. -- Jim C. Nasby, Database Consultant [EMAIL

Re: [HACKERS] SQL-Invoked Procedures for 8.1

2004-10-04 Thread Jim C. Nasby
. I realize that even if procedures/functions aren't defined using quotes there will still be cases where things need to be multi-quoted, but those cases are much rarer. -- Jim C. Nasby, Database Consultant [EMAIL PROTECTED] Give your computer some brain candy! www.distributed.net Team

Re: [HACKERS] SQL-Invoked Procedures for 8.1

2004-10-06 Thread Jim C. Nasby
On Mon, Oct 04, 2004 at 03:10:24PM -0400, Alvaro Herrera wrote: So you aren't aware of the dollar-quoting feature? You may want to take a look at that ... Can someone point me to a url? I haven't been able to find anything about this... -- Jim C. Nasby, Database Consultant

Re: [HACKERS] SQL-Invoked Procedures for 8.1

2004-10-21 Thread Jim C. Nasby
you need to overload to have 5 default arguments; that equates to 4 stub functions/prodecudes. In the case of adding a single parameter it's not that bad, but it becomes very onerous if you're trying to provide default values for a bunch of parameters. -- Jim C. Nasby, Database Consultant

Re: [HACKERS] plans for bitmap indexes?

2004-10-21 Thread Jim C. Nasby
-info.de/postgresql/postgres-gotchas.html would also be likely candidates. -- Jim C. Nasby, Database Consultant [EMAIL PROTECTED] Give your computer some brain candy! www.distributed.net Team #1828 Windows: Where do you want to go today? Linux: Where do you want to go tomorrow

Re: [HACKERS] MAX/MIN optimization via rewrite (plus query rewrites generally)

2004-11-10 Thread Jim C. Nasby
this in such a way that SELECT min(foo), max(foo) FROM bar will end up as SELECT (SELECT foo FROM bar ORDER BY foo ASC LIMIT 1), (SELECT ... DESC LIMIT 1) ? -- Jim C. Nasby, Database Consultant [EMAIL PROTECTED] Give your computer some brain candy! www.distributed.net Team #1828 Windows

Re: [HACKERS] MAX/MIN optimization via rewrite (plus query rewrites

2004-11-10 Thread Jim C. Nasby
made me realize that the scope of what should be optimized is somewhat subtle. I am inclined to keep it simple (i.e rather limited) for a first cut, and if that works well, then look at extending to more complex rewrites. What do you think? Jim C. Nasby wrote: On Thu, Nov 11, 2004

Re: [HACKERS] MAX/MIN optimization via rewrite (plus query rewrites generally)

2004-11-12 Thread Jim C. Nasby
maximum is small compared to a disk read, but at some point it will be faster to read an index. When a GROUP BY is being used and there isn't an index that can both be used to do the grouping and col order within each group. -- Jim C. Nasby, Database Consultant [EMAIL PROTECTED] Give

Re: [HACKERS] MAX/MIN optimization via rewrite (plus query

2004-11-12 Thread Jim C. Nasby
, and MSSQL. -- Jim C. Nasby, Database Consultant [EMAIL PROTECTED] Give your computer some brain candy! www.distributed.net Team #1828 Windows: Where do you want to go today? Linux: Where do you want to go tomorrow? FreeBSD: Are you guys coming, or what? ---(end

[HACKERS] Easy way to download all .torrents

2004-11-23 Thread Jim C. Nasby
For a while I've been keeping a bittorrent client running with some of the common postgresql torrents that are available, but grabbing the .torrent files is a bit of a pain. Is there an easy way to download all of the appropriate .torrent files that are available? -- Jim C. Nasby, Database

Re: [HACKERS] Increasing the length of

2004-11-30 Thread Jim C. Nasby
Square, Pennsylvania 19073 ---(end of broadcast)--- TIP 6: Have you searched our list archives? http://archives.postgresql.org -- Jim C. Nasby, Database Consultant [EMAIL PROTECTED] Give your computer some brain

[HACKERS] Issue with plpython write_file and read_file tests

2005-06-20 Thread Jim C. Nasby
, so it seems like it might be better to put the cleanup functionality in the test suite. ISTM it would also be good if the test honored $TEMP. -- Jim C. Nasby, Database Consultant [EMAIL PROTECTED] Give your computer some brain candy! www.distributed.net Team #1828 Windows: Where do

Re: [HACKERS] Strange logic for partial index proving

2005-06-21 Thread Jim C. Nasby
. Of course this is a somewhat nonsensical example, but I suspect that there are cases where QBE or other front-ends will generate queries that contain some impossible conditions that can be eliminated. -- Jim C. Nasby, Database Consultant [EMAIL PROTECTED] Give your computer some

Re: [HACKERS] Problem with dblink regression test

2005-06-22 Thread Jim C. Nasby
the contrib_regression database and the user that's running the buildfarm. Is there a way to confirm which libpq.so psql and/or dblink.so has linked to? Are there any other tests I could run to shed some light on this? -- Jim C. Nasby, Database Consultant [EMAIL PROTECTED] Give your computer

Re: [HACKERS] Problem with dblink regression test

2005-06-22 Thread Jim C. Nasby
sense to me. Then the dblink regression test would not specify a port at all, correct? Actually, the regression test currently doesn't specify a port. If it did we wouldn't have found this problem. -- Jim C. Nasby, Database Consultant [EMAIL PROTECTED] Give your computer some

Re: [HACKERS] [PATCHES] O_DIRECT for WAL writes

2005-06-23 Thread Jim C. Nasby
a warning if the drive appears to be caching or if we think the test might not cover everything (ie symlinks in the data directory). -- Jim C. Nasby, Database Consultant [EMAIL PROTECTED] Give your computer some brain candy! www.distributed.net Team #1828 Windows: Where do you want

Re: [GENERAL] [HACKERS] [PATCHES] Removing Kerberos 4

2005-06-23 Thread Jim C. Nasby
the mailling lists. Has Kerb4 been marked as depricated in the docs at all? If not it might be best to just do that and then yank it later. -- Jim C. Nasby, Database Consultant [EMAIL PROTECTED] Give your computer some brain candy! www.distributed.net Team #1828 Windows: Where do you want

Re: [HACKERS] [PATCHES] O_DIRECT for WAL writes

2005-06-24 Thread Jim C. Nasby
lab? -- Jim C. Nasby, Database Consultant [EMAIL PROTECTED] Give your computer some brain candy! www.distributed.net Team #1828 Windows: Where do you want to go today? Linux: Where do you want to go tomorrow? FreeBSD: Are you guys coming, or what? ---(end

Re: [HACKERS] HaveNFreeProcs ?

2005-06-24 Thread Jim C. Nasby
a performance issue, right?) -- Jim C. Nasby, Database Consultant [EMAIL PROTECTED] Give your computer some brain candy! www.distributed.net Team #1828 Windows: Where do you want to go today? Linux: Where do you want to go tomorrow? FreeBSD: Are you guys coming, or what

Re: [HACKERS] Server instrumentation patch

2005-06-24 Thread Jim C. Nasby
with the file sizes. -- Jim C. Nasby, Database Consultant [EMAIL PROTECTED] Give your computer some brain candy! www.distributed.net Team #1828 Windows: Where do you want to go today? Linux: Where do you want to go tomorrow? FreeBSD: Are you guys coming, or what

Re: [GENERAL] [HACKERS] [PATCHES] Removing Kerberos 4

2005-06-24 Thread Jim C. Nasby
in the future. Having said that, that statement means it's removal shouldn't come as a shock to anyone. -- Jim C. Nasby, Database Consultant [EMAIL PROTECTED] Give your computer some brain candy! www.distributed.net Team #1828 Windows: Where do you want to go today? Linux: Where do you want

Re: [HACKERS] Fundamental error in no WAL log index/file creation stuff

2005-06-26 Thread Jim C. Nasby
database WAL replay continues Would this resolve the PITR issues with CREATE DATABASE? -- Jim C. Nasby, Database Consultant [EMAIL PROTECTED] Give your computer some brain candy! www.distributed.net Team #1828 Windows: Where do you want to go today? Linux: Where do you want to go

Re: [HACKERS] Problem with dblink regression test

2005-06-27 Thread Jim C. Nasby
On Mon, Jun 27, 2005 at 02:10:47PM -0500, Jim C. Nasby wrote: http://stats.distributed.net/~buildfarm/libcheck.log. Note that Tom's theory is correct: psql is linking against the buildfarm libpq while dblink is linking against the system one. BTW, after looking through that logfile, it appears

Re: [HACKERS] Problem with dblink regression test

2005-06-27 Thread Jim C. Nasby
On Mon, Jun 27, 2005 at 03:44:41PM -0400, Andrew Dunstan wrote: Jim C. Nasby wrote: On Mon, Jun 27, 2005 at 02:10:47PM -0500, Jim C. Nasby wrote: http://stats.distributed.net/~buildfarm/libcheck.log. Note that Tom's theory is correct: psql is linking against the buildfarm libpq

Re: [HACKERS] Problem with dblink regression test

2005-06-27 Thread Jim C. Nasby
-farm.conf), could the --with-libraries=/usr/local/lib be the issue, and if so, what's the proper way to handle system libraries (like libintl) living in /usr/local/lib and not /usr/lib? -- Jim C. Nasby, Database Consultant [EMAIL PROTECTED] Give your computer some brain candy

Re: [HACKERS] Problem with dblink regression test

2005-06-28 Thread Jim C. Nasby
either put that file somewhere we can look at it or extract the relevant lines and post in a reply? thanks andrew Jim C. Nasby wrote: I have no clue why the mailling list is eating my original messages, unless it's because I attached a diff to them... in any case, applying http

Re: [HACKERS] Role syntax (or, SQL99 versus sanity)

2005-06-28 Thread Jim C. Nasby
. -- Jim C. Nasby, Database Consultant [EMAIL PROTECTED] Give your computer some brain candy! www.distributed.net Team #1828 Windows: Where do you want to go today? Linux: Where do you want to go tomorrow? FreeBSD: Are you guys coming, or what? ---(end

Re: [HACKERS] Problem with dblink regression test - FIXED

2005-06-28 Thread Jim C. Nasby
On Tue, Jun 28, 2005 at 02:28:11PM -0400, Andrew Dunstan wrote: Jim C. Nasby wrote: All the logs for the most recent run against HEAD are now at http://stats.distributed.net/~buildfarm/ A quick look shows that when you use --with-libraries=/foo/bar the generated link line

Re: [HACKERS] Open items

2005-07-01 Thread Jim C. Nasby
, DBA will need to know about: - Which SQL generate a disk sort? Good point. An EXPLAIN ANALYZE note about the disk usage for the sort would be really nice. Even nicer would be a way to log queries that generate on-disk sorts. -- Jim C. Nasby, Database Consultant [EMAIL

Re: [HACKERS] HEAD doesn't cope with libraries in non-default locations

2005-07-04 Thread Jim C. Nasby
locations instead of from within the build. -- Jim C. Nasby, Database Consultant [EMAIL PROTECTED] Give your computer some brain candy! www.distributed.net Team #1828 Windows: Where do you want to go today? Linux: Where do you want to go tomorrow? FreeBSD: Are you guys coming, or what

Re: [PATCHES] [HACKERS] HEAD doesn't cope with libraries in non-default

2005-07-05 Thread Jim C. Nasby
Eisentraut http://developer.postgresql.org/~petere/ ---(end of broadcast)--- TIP 7: don't forget to increase your free space map settings -- Jim C. Nasby, Database Consultant [EMAIL PROTECTED] Give your computer some brain candy

Re: [PATCHES] [HACKERS] HEAD doesn't cope with libraries in non-default

2005-07-05 Thread Jim C. Nasby
/cgi-bin/show_log.pl?nm=platypusdt=2005-07-05%2022:03:35 -- Jim C. Nasby, Database Consultant [EMAIL PROTECTED] Give your computer some brain candy! www.distributed.net Team #1828 Windows: Where do you want to go today? Linux: Where do you want to go tomorrow? FreeBSD: Are you guys

Re: [HACKERS] Must be owner to truncate?

2005-07-07 Thread Jim C. Nasby
with the viewpoint that truncate is just a quick DELETE, and so I do not agree that DELETE permissions should be enough to let you do a TRUNCATE. What about adding a truncate permission? I would find it useful, as it seems would others. -- Jim C. Nasby, Database Consultant [EMAIL

Re: [HACKERS] Must be owner to truncate?

2005-07-12 Thread Jim C. Nasby
being able to support concurrent reads against truncate would be a step forward, even if writes were still blocked. That alone means this is probably worth-while, although it might require a slightly different syntax since it would behave differently than the existing truncate does. -- Jim C. Nasby

Re: [HACKERS] Where is the decision about placement of new tuple made ?

2005-07-12 Thread Jim C. Nasby
-- Jim C. Nasby, Database Consultant [EMAIL PROTECTED] Give your computer some brain candy! www.distributed.net Team #1828 Windows: Where do you want to go today? Linux: Where do you want to go tomorrow? FreeBSD: Are you guys coming, or what? ---(end

[HACKERS] pthread stack on FreeBSD WAS: HEAD doesn't cope with libraries in non-default

2005-07-13 Thread Jim C. Nasby
with python 2.3 (octopus is running 2.4). I'm upgrading platypus to 2.4 right now to see what that changes, if anything. -- Jim C. Nasby, Database Consultant [EMAIL PROTECTED] Give your computer some brain candy! www.distributed.net Team #1828 Windows: Where do you want to go today

Re: [HACKERS] Buildfarm issues on specific machines

2005-07-19 Thread Jim C. Nasby
want to poke around with this further? Also, is -hackers the best place to ask about buildfarm issues, or should I post questions elsewhere? -- Jim C. Nasby, Database Consultant [EMAIL PROTECTED] Give your computer some brain candy! www.distributed.net Team #1828 Windows: Where do

Re: [HACKERS] Buildfarm issues on specific machines

2005-07-19 Thread Jim C. Nasby
On Tue, Jul 19, 2005 at 02:29:08PM -0400, Tom Lane wrote: Jim C. Nasby [EMAIL PROTECTED] writes: On Sat, Jul 16, 2005 at 11:17:29PM -0400, Tom Lane wrote: cuckoo [7.3, 7.2]: --enable-nls without OS support This looks like pilot error; but the later branches don't fail on this machine

[HACKERS] More buildfarm stuff

2005-07-19 Thread Jim C. Nasby
/postgresql80-server/files:38 Can anyone comment on what the second one does, specifically the allow_nonpic_in_shlib? As for the first patch, is there any way to make that FreeBSD specific in the makefile without going to a Makefile.in? Could that test be done in Makefile.global? -- Jim C. Nasby

[HACKERS] Enticing interns to PostgreSQL

2005-07-19 Thread Jim C. Nasby
] ___ freebsd-announce@freebsd.org mailing list http://lists.freebsd.org/mailman/listinfo/freebsd-announce To unsubscribe, send any mail to [EMAIL PROTECTED] - End forwarded message - -- Jim C. Nasby, Database Consultant [EMAIL PROTECTED] Give your computer some brain

Re: [HACKERS] More buildfarm stuff

2005-07-19 Thread Jim C. Nasby
On Tue, Jul 19, 2005 at 03:11:31PM -0400, Tom Lane wrote: Jim C. Nasby [EMAIL PROTECTED] writes: http://archives.postgresql.org/pgsql-bugs/2005-07/msg00096.php describes what I think is causing octopus to fail. What's also interesting is these patches from the FreeBSD port: None of those

Re: [HACKERS] Buildfarm issues on specific machines

2005-07-19 Thread Jim C. Nasby
On Tue, Jul 19, 2005 at 03:17:49PM -0400, Andrew Dunstan wrote: Jim C. Nasby wrote: Then I guess the question is... is it more valuable to have a working buildfarm environment for 7.2 and 7.3, or is the obnoxious failure better to spur someone into looking at it? :) Should this maybe

Re: [HACKERS] Buildfarm issues on specific machines

2005-07-19 Thread Jim C. Nasby
(trimming cc list...) On Tue, Jul 19, 2005 at 02:25:38PM -0500, Jim C. Nasby wrote: OK, I'll tweak cuckoo's config accordingly then. And now it's failing on make, at least for 7.2... ccache gcc -O3 -pipe -traditional-cpp -g -O2 -g -Wall -Wmissing-prototypes -Wmissing-declarations -I. -I

Re: [HACKERS] More buildfarm stuff

2005-07-19 Thread Jim C. Nasby
On Tue, Jul 19, 2005 at 03:47:48PM -0400, Tom Lane wrote: Jim C. Nasby [EMAIL PROTECTED] writes: On Tue, Jul 19, 2005 at 03:11:31PM -0400, Tom Lane wrote: None of those patches are necessary; if they were, we'd be seeing the failures at the build stage, not at runtime. Anyone have any

Re: [HACKERS] More buildfarm stuff

2005-07-19 Thread Jim C. Nasby
U pthread_attr_destroy U pthread_attr_destroy [EMAIL PROTECTED]:01]~:15ldd /usr/local/lib/libpython2.4.so | grep thread ; ldd /usr/local/lib/python2.4/config/libpython2.4.so | grep thread [EMAIL PROTECTED]:01]~:16 -- Jim C. Nasby, Database Consultant [EMAIL PROTECTED] Give

Re: [HACKERS] Buildfarm issues on specific machines

2005-07-19 Thread Jim C. Nasby
] Error 2 See http://pgbuildfarm.org/cgi-bin/show_log.pl?nm=cuckoodt=2005-07-19%2019:38:17 and http://pgbuildfarm.org/cgi-bin/show_log.pl?nm=cuckoodt=2005-07-19%2019:28:30 -- Jim C. Nasby, Database Consultant [EMAIL PROTECTED] Give your computer some brain candy! www.distributed.net

Re: [HACKERS] [PATCHES] Patch to fix plpython on OS X

2005-07-19 Thread Jim C. Nasby
On Tue, Jul 19, 2005 at 01:54:00PM -0600, Michael Fuhr wrote: On Tue, Jul 19, 2005 at 02:48:52PM -0400, Tom Lane wrote: Jim C. Nasby [EMAIL PROTECTED] writes: I don't think it's a version issue; cuckoo is at 2.4, platypus used to be at 2.3 but I upgraded it to 2.4 to see

Re: [HACKERS] [PATCHES] Patch to fix plpython on OS X

2005-07-19 Thread Jim C. Nasby
On Tue, Jul 19, 2005 at 02:42:07PM -0600, Michael Fuhr wrote: On Tue, Jul 19, 2005 at 03:11:35PM -0500, Jim C. Nasby wrote: On Tue, Jul 19, 2005 at 01:54:00PM -0600, Michael Fuhr wrote: Does this machine have ldd or the equivalent? If so, can you compare ldd /path/to/python and ldd /path

Re: [HACKERS] Constraint Exclusion on all tables

2005-07-19 Thread Jim C. Nasby
ALL, maybe it would be better if there was an option to explain that told it either to show or not show info about eliminated partitions. That would seem to serve the general case better than coding it according to table type. -- Jim C. Nasby, Database Consultant [EMAIL PROTECTED

Re: [HACKERS] [PATCHES] Patch to fix plpython on OS X

2005-07-19 Thread Jim C. Nasby
On Tue, Jul 19, 2005 at 04:51:03PM -0500, Jim C. Nasby wrote: Can you search the system for all files named libpython* and post what you find? [EMAIL PROTECTED]:42]~:11%locate libpython /Applications/NeoOfficeJ.app/Contents/MacOS/libpython.dylib /Applications/NeoOfficeJ.app/Contents/MacOS

Re: [HACKERS] Buildfarm issues on specific machines

2005-07-20 Thread Jim C. Nasby
On Wed, Jul 20, 2005 at 10:32:00AM -0400, Tom Lane wrote: In short, OS X 10.2 wasn't a supported platform when 7.2/7.3 came out, and I don't want to retroactively try to make it so. All I needed to hear. I'll pull those from cuckoo's config. -- Jim C. Nasby, Database Consultant

Re: [HACKERS] Constraint Exclusion on all tables

2005-07-20 Thread Jim C. Nasby
program convenient table? I would absolutely love to see this happen. -- Jim C. Nasby, Database Consultant [EMAIL PROTECTED] Give your computer some brain candy! www.distributed.net Team #1828 Windows: Where do you want to go today? Linux: Where do you want to go tomorrow? FreeBSD

Re: [HACKERS] [PATCHES] Patch to fix plpython on OS X

2005-07-20 Thread Jim C. Nasby
On Tue, Jul 19, 2005 at 05:47:37PM -0600, Michael Fuhr wrote: On Tue, Jul 19, 2005 at 06:06:00PM -0500, Jim C. Nasby wrote: [EMAIL PROTECTED]:00]~/buildfarm/HEAD/pgsqlkeep.1121809875/src/pl/plpython:41%otool -L libplpython.0.0.so libplpython.0.0.so: /System/Library/Frameworks

Re: [HACKERS] Enticing interns to PostgreSQL

2005-07-20 Thread Jim C. Nasby
On Wed, Jul 20, 2005 at 03:43:04PM -0700, Jeff Davis wrote: Jim C. Nasby wrote: The email below about FreeBSD's involvement in Google's Summer of Code got me thinking; would there be value in trying to attract college students to working on either PostgreSQL development, or using

Re: [HACKERS] More buildfarm stuff

2005-07-25 Thread Jim C. Nasby
But I do have a /usr/local/lib/python2.4/config/libpython2.4.a that has a bunch of symbols, though I'm not sure if that means anything or what I'm looking for in the nm output. -- Jim C. Nasby, Database Consultant [EMAIL PROTECTED] Give your computer some brain candy! www.distributed.net

Re: [HACKERS] regression failure on latest CVS

2005-07-25 Thread Jim C. Nasby
dream a reality. (St Exupery) ---(end of broadcast)--- TIP 6: explain analyze is your friend -- Jim C. Nasby, Database Consultant [EMAIL PROTECTED] Give your computer some brain candy! www.distributed.net Team #1828 Windows: Where

Re: [HACKERS] Couple of minor buildfarm issues

2005-07-25 Thread Jim C. Nasby
a summary report of what different options have how much coverage, etc. -- Jim C. Nasby, Database Consultant [EMAIL PROTECTED] Give your computer some brain candy! www.distributed.net Team #1828 Windows: Where do you want to go today? Linux: Where do you want to go tomorrow? FreeBSD

Re: [HACKERS] More buildfarm stuff

2005-07-25 Thread Jim C. Nasby
programming language [EMAIL PROTECTED]:34]~:40 I can give you an account if it would help. Feel free to drop my an email if you have any questions or if I can help in some way. -- Jim C. Nasby, Database Consultant [EMAIL PROTECTED] Give your computer some brain candy

Re: [HACKERS] [PATCHES] Patch to fix plpython on OS X

2005-07-25 Thread Jim C. Nasby
this? Yes --- just let pg_regress deal with it as if it were a locale problem. I've committed it that way. regards, tom lane FYI, cuckoo went green with this build: http://pgbuildfarm.org/cgi-bin/show_log.pl?nm=cuckoodt=2005-07-25%2008:05:02 -- Jim C. Nasby, Database

Re: [HACKERS] ORDER BY field not in return list

2005-07-25 Thread Jim C. Nasby
On Mon, Jul 25, 2005 at 07:06:46PM -0300, Marc G. Fournier wrote: On Mon, 25 Jul 2005, Jim C. Nasby wrote: On Mon, Jul 25, 2005 at 06:11:08PM -0300, Marc G. Fournier wrote: Just curious as to whether or not a warning or something should be issued in a case like: SELECT c

Re: [HACKERS] More buildfarm stuff

2005-07-25 Thread Jim C. Nasby
On Mon, Jul 25, 2005 at 04:03:58PM -0600, Michael Fuhr wrote: On Mon, Jul 25, 2005 at 04:40:19PM -0500, Jim C. Nasby wrote: FWIW, AFAICT I did build the port with default options. Though, nm shows no symbols for my libpython(s)... [EMAIL PROTECTED]:38]~:47nm `locate libpython|grep .so

Re: [HACKERS] More buildfarm stuff

2005-07-25 Thread Jim C. Nasby
On Mon, Jul 25, 2005 at 05:54:45PM -0400, Larry Rosenman wrote: Jim C. Nasby wrote: On Sun, Jul 24, 2005 at 07:38:46PM -0400, Larry Rosenman wrote: Andrew Dunstan wrote: Larry, please try building and testing (especially PL installcheck) on that box using as close as possible

Re: [HACKERS] ORDER BY field not in return list

2005-07-25 Thread Jim C. Nasby
that anything in ORDER BY had to also be in SELECT. -- Jim C. Nasby, Database Consultant [EMAIL PROTECTED] Give your computer some brain candy! www.distributed.net Team #1828 Windows: Where do you want to go today? Linux: Where do you want to go tomorrow? FreeBSD: Are you guys coming

Re: [HACKERS] Couple of minor buildfarm issues

2005-07-25 Thread Jim C. Nasby
cover most cases. -- Jim C. Nasby, Database Consultant [EMAIL PROTECTED] Give your computer some brain candy! www.distributed.net Team #1828 Windows: Where do you want to go today? Linux: Where do you want to go tomorrow? FreeBSD: Are you guys coming, or what

Re: [HACKERS] More buildfarm stuff

2005-07-26 Thread Jim C. Nasby
On Mon, Jul 25, 2005 at 05:02:02PM -0500, Jim C. Nasby wrote: Can you try rebuilding python and it's dependencies WITHOUT_THREADS? I think that would get us where we need? Worked: http://pgbuildfarm.org/cgi-bin/show_log.pl?nm=octopusdt=2005-07-26%2015:29:33 So the question now is: how do

[HACKERS] ENUM type

2005-07-26 Thread Jim C. Nasby
/definition convention. In this case, it might be much easier to have an enum that doesn't allow you to define what can go into it at creation time; ie: CREATE TABLE ... blah ENUM NOT NULL ... ... ALTER TABLE SET ENUM blah ALLOWED VALUES(1, 2, 4); -- Jim C. Nasby, Database Consultant

Re: [HACKERS] ENUM type

2005-07-26 Thread Jim C. Nasby
On Wed, Jul 27, 2005 at 12:11:47AM +0200, Jochem van Dieten wrote: On 7/26/05, Jim C. Nasby wrote: On Tue, Jul 26, 2005 at 01:09:11PM -0700, Jeff Davis wrote: Ultimately to do it in a general way I think we'd need functions that return a type that can be used in a table definition. Aside

Re: [HACKERS] [Testperf-general] dbt2 opteron performance

2005-07-28 Thread Jim C. Nasby
to Linux on the box... how hard would it be to do some form of multi-boot? -- Jim C. Nasby, Database Consultant [EMAIL PROTECTED] Give your computer some brain candy! www.distributed.net Team #1828 Windows: Where do you want to go today? Linux: Where do you want to go tomorrow? FreeBSD

Re: [HACKERS] [Testperf-general] dbt2 opteron performance

2005-07-28 Thread Jim C. Nasby
/results/dev4-015/layout-6.html Have you by-chance tried it with the logs and data just going to seperate RAID10s? I'm wondering if a large RAID10 would do a better job of spreading the load than segmenting things to specific drives. -- Jim C. Nasby, Database Consultant [EMAIL PROTECTED

Re: [HACKERS] [Testperf-general] dbt2 opteron performance

2005-07-28 Thread Jim C. Nasby
On Thu, Jul 28, 2005 at 05:14:41PM -0500, Jim C. Nasby wrote: On Wed, Jul 27, 2005 at 09:31:39PM -0700, Mark Wong wrote: After seeing the discussion about how bad the disk performance is with a lot of scsi controllers on linux, I'm wondering if we should run some disk tests to see how

Re: [HACKERS] [Testperf-general] dbt2 opteron performance

2005-07-28 Thread Jim C. Nasby
On Thu, Jul 28, 2005 at 04:15:31PM -0700, Mark Wong wrote: On Thu, 28 Jul 2005 17:17:25 -0500 Jim C. Nasby [EMAIL PROTECTED] wrote: On Wed, Jul 27, 2005 at 07:32:34PM -0700, Josh Berkus wrote: This 4-way has 8GB of memory and four Adaptec 2200s controllers attached to 80 spindles

Re: [HACKERS] [Testperf-general] dbt2 opteron performance

2005-07-29 Thread Jim C. Nasby
On Thu, Jul 28, 2005 at 05:00:44PM -0700, Mark Wong wrote: On Thu, 28 Jul 2005 16:55:55 -0700 Mark Wong [EMAIL PROTECTED] wrote: On Thu, 28 Jul 2005 18:48:09 -0500 Jim C. Nasby [EMAIL PROTECTED] wrote: On Thu, Jul 28, 2005 at 04:15:31PM -0700, Mark Wong wrote: On Thu, 28 Jul 2005

Re: [HACKERS] [Testperf-general] dbt2 opteron performance

2005-07-29 Thread Jim C. Nasby
, that's a pretty stunning difference... any idea why? I think it might be very useful to see some raw disk IO benchmarks... -- Jim C. Nasby, Database Consultant [EMAIL PROTECTED] Give your computer some brain candy! www.distributed.net Team #1828 Windows: Where do you want to go

Re: [HACKERS] [Testperf-general] dbt2 opteron performance

2005-07-29 Thread Jim C. Nasby
On Fri, Jul 29, 2005 at 01:11:35PM -0700, Mark Wong wrote: On Fri, 29 Jul 2005 14:57:42 -0500 Jim C. Nasby [EMAIL PROTECTED] wrote: On Fri, Jul 29, 2005 at 12:51:57PM -0700, Mark Wong wrote: Not sure I fully understand what you're trying to say, but it seems like it might still

  1   2   3   4   5   6   7   8   9   10   >