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
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
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
, 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
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
--
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
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
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
, 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
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
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
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
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
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
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
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
: 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
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
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
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
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
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
(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
;
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
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
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
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
. 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
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
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
-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
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
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
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
, 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
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
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
, 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
. 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
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
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
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
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
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
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
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
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
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
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
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
-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
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
.
--
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
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
,
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
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
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
/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
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
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
--
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
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
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
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
/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
]
___
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
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
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
(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
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
] 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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
/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
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
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
/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
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
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
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
, 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
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
On Tue, Jul 26, 2005 at 10:17:05PM +0200, Palle Girgensohn wrote:
--On tisdag, juli 26, 2005 15.17.57 -0400 Tom Lane [EMAIL PROTECTED]
wrote:
Larry Rosenman ler@lerctr.org writes:
On Jul 26 2005, Jim C. Nasby wrote:
So the question now is: how do we fix the issue with threaded python
1 - 100 of 1317 matches
Mail list logo
