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 Buskermolen
Command Prompt, Inc
;
ALTER TABLE foo SET autovacuum_naptime to '1min';
(or there about)
I suppose we could also have pg_autovacuum become a view, with rules to manage
relopts.
Sincerely,
Joshua D. Drake
--
Darcy Buskermolen
Command Prompt, Inc.
+1.503.667.4564 X 102
http://www.commandprompt.com/
PostgreSQL
to resolution, and not
requiring hacking the backend to get there.
Sincerely,
Joshua D. Drake
--
Darcy Buskermolen
Command Prompt, Inc.
+1.503.667.4564 X 102
http://www.commandprompt.com/
PostgreSQL solutions since 1997
---(end of broadcast
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 actually test the RC before we push
a gold ?
--
Darcy Buskermolen
Command Prompt, Inc.
+1.503.667.4564 X 102
http
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 perhaps
cleanly
--
Darcy Buskermolen
The PostgreSQL company, Command Prompt Inc.
http://www.commandprompt.com/
---(end of broadcast)---
TIP 2: Don't 'kill -9' the postmaster
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.
This is looking much better now too, it's
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 has many databases, the
autovac launcher starts eating too much CPU
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..
I tried it here
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 new
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 (resetting
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
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. So
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 have
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 written a lot more often that once every
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
stats file is written a lot more often
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/
---(end of broadcast
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 autovacuum
to users? Right now we don't even
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
vacuum verbose being logged
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 useful but it's not good enough.
Keep in mind that in the future we
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 able
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 is akin to the important information of
vacuum
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 have
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
well
build?
Can you send exact error message?
I am training this week, but Darcy can do it. Can you give them a test
case on what we were working on with that customer?
Joshua D. Drake
--
Darcy Buskermolen
Command Prompt, Inc.
Sales/Support: +1.503.667.4564 || 24x7/Emergency: +1.800.492.2240
calculations. And, there are some tips and trics: removing HTML
marking,removing punctuation, lowercasing text and so on - it's interesting
and complex task.
--
Darcy Buskermolen
Command Prompt, Inc.
Sales/Support: +1.503.667.4564 || 24x7/Emergency: +1.800.492.2240
PostgreSQL solutions since 1997
http
=2140 width=4) (actual
time=0.003..0.003 rows=0 loops=1)
Total runtime: 0.040 ms
(2 rows)
--
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/
---(end
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 constraint exclusion on it.
Do you have
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 tables.
[ looks again... ] Oh, here's
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
() at postmaster.c:2845
#17 0x0819ed59 in PostmasterMain (argc=1, argv=0xbfbfed5c) at postmaster.c:949
#18 0x08162092 in main (argc=1, argv=0xbfbfed5c) at main.c:187
--
Darcy Buskermolen
CommandPrompt, Inc.
Sales/Support: +1.503.667.4564 || 24x7/Emergency: +1.800.492.2240
http
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 made sence to do it, then yes we would do it. The problem
, tom lane
---(end of broadcast)---
TIP 2: Don't 'kill -9' the postmaster
--
Darcy Buskermolen
CommandPrompt, Inc.
Sales/Support: +1.503.667.4564 || 24x7/Emergency: +1.800.492.2240
http://www.commandprompt.com
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
being Slony is designed to work across a multitude
the unit conversion and
scaling factor is for each parameter (8K, 1K, milliseconds, etc);
though, this wouldn't be hard to add at all.
Yummy, Yummy, I'd say this would be a big boost in ability to tune for a lot
of people.
--
Darcy Buskermolen
Wavefire Technologies Corp.
http://www.wavefire.com
of the desired features can be
bolted on top of this down the road
regards, tom lane
---(end of broadcast)---
TIP 3: Have you checked our extensive FAQ?
http://www.postgresql.org/docs/faq
--
Darcy Buskermolen
() in the database loaded funcs.
regards, tom lane
---(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
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
Comments?
LER
--
Darcy Buskermolen
Wavefire Technologies Corp
://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
* FROM
seqname, but I'll bet there would be some hollering.
?
regards, tom lane
---(end of broadcast)---
TIP 6: explain analyze is your friend
--
Darcy Buskermolen
Wavefire Technologies Corp.
http://www.wavefire.com
ph
management consol. I would find a change
of this sort soemewhat frustrating, I'd probably be inclined to symlink all
my history files together. The presented way looks perfectly acceptable to
me.
--
Darcy Buskermolen
Wavefire Technologies Corp.
http://www.wavefire.com
ph: 250.717.0200
fx
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
wonder why we still find
more of these, because every time it comes up I agree to removal of it.
Perhaps your name reproduces somehow. :-)
That pesky replication daemon... ;-)
--
Darcy Buskermolen
Wavefire Technologies Corp.
http://www.wavefire.com
ph: 250.717.0200
fx: 250.763.1759
.
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 Buskermolen
Wavefire Technologies Corp.
http://www.wavefire.com
ph: 250.717.0200
fx
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.1759
---(end of broadcast)---
TIP 4: Have you searched our list
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
direct cross reference to their CVE number.)
We really should write the CVE numbers into the commit messages and the
release notes.
I also belive that we should have these referenced visably on the website much
the same way apache does:
http://httpd.apache.org/security_report.html
--
Darcy
--
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 command to [EMAIL PROTECTED
of where this is sitting, and if it's likely to make it's way
into 8.1 gold ?
---(end of broadcast)---
TIP 3: Have you checked our extensive FAQ?
http://www.postgresql.org/docs/faq
--
Darcy Buskermolen
Wavefire Technologies Corp
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: 250.763.1759
---(end of broadcast
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
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 seem to have an option to report the
share_dir. Should
to use it to find where to put module config/setup
scripts.
cheers
andrew
---(end of broadcast)---
TIP 3: Have you checked our extensive FAQ?
http://www.postgresql.org/docs/faq
--
Darcy Buskermolen
Wavefire Technologies Corp
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)---
TIP 1: if posting/reading through Usenet
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)---
TIP 5: don't
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.0200
fx: 250.763.1759
---(end
.
And there is always http://pgfoundry.org/projects/tpc-w-php/ for a ~= TPC-W
workload.
--
Darcy Buskermolen
Wavefire Technologies Corp.
http://www.wavefire.com
ph: 250.717.0200
fx: 250.763.1759
---(end of broadcast)---
TIP 3: Have you checked
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 Technologies Corp.
http://www.wavefire.com
ph: 250.717.0200
fx: 250.763.1759
On Friday 04 March 2005 10:11, Andrew Dunstan wrote:
Now that we've been running for a while there are a few buildfarm issues
that I need to address.
First, do we keep the right data about the members? Essentially, we
keep: operating_system, os_version, compiler, compiler_version,
)---
TIP 8: explain analyze is your friend
--
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
in
FunctionCall2:
fcinfo.arg[0] = arg1;
fcinfo.arg[1] = arg2;
fcinfo.argnull[0] = false;
fcinfo.argnull[1] = false;
If anyone would like to try the results on other platforms, my test
program is attached.
regards, tom lane
--
Darcy Buskermolen
Wavefire
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=potorooodt=2005-01-26%2008:30:02
for more details.
--
Darcy Buskermolen
Wavefire Technologies Corp.
ph: 250.717.0200
fx: 250.763.1759
http
-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
--
Darcy Buskermolen
Wavefire Technologies Corp.
ph: 250.717.0200
fx
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
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 look.
http://www.ibm.com/news/us/en
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 relate RDBMS
and query optimizations
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 there are several that relate RDBMS
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 all global symbols within
the backend
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-dynamic
rpath = -R$(rpathdir)
shlib_symbolic = -Wl,-Bsymbolic -lc
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 and returns a green light.
regards
As per
http://www.pgbuildfarm.org/cgi-bin/show_log.pl?nm=herringdt=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 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=herringdt=2004-12-16%2
018:46:18 This combination of OS/compiler does not result in a working
copy.
The failure is
ascii_and_mic.so
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, make sure that all global symbols within
the backend
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=herringdt=2004-12-16
%2018:46:18
This combination of OS/compiler does not result in a working copy
It looks like --enable-cassert isn't handled properly under icc7
http://www.pgbuildfarm.org/cgi-bin/show_log.pl?nm=herringdt=2004-12-07%2016:30:44
--
Darcy Buskermolen
Wavefire Technologies Corp.
ph: 250.717.0200
fx: 250.763.1759
http://www.wavefire.com
---(end
should be fixed by
http://developer.postgresql.org/cvsweb.cgi/pgsql/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
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.
The OpenBSD error should be fixed by
http
: 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
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
optimizations, or else bail out and ask
, y.f);
return 0;
}
---(end of broadcast)---
TIP 9: 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.
ph: 250.717.0200
fx
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
x = 12.3
y = 12.3
but if compiled with -O or -O2
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://www.wavefire.com
---(end of broadcast
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: Have you searched our list archives
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 this is fixed by Kris Jurka's just-applied patch.
Yes
The buildfarm has identified yet another failure under SPARC/Solaris 8 as
outlined in.
http://oicu.homedns.org:81/cgi/show_log.pl?nm=potorooodt=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
http
.
---(end of broadcast)---
TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]
--
Darcy Buskermolen
Wavefire Technologies Corp.
ph: 250.717.0200
fx: 250.763.1759
http://www.wavefire.com
---(end of broadcast
float.h 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: 250.717.0200
fx: 250.763.1759
http://www.wavefire.com
=0x82bc200) at postmaster.c:2201
#22 0x8145bae in ServerLoop () at postmaster.c:1113
#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
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 through Usenet, please send an appropriate
subscribe-nomail command to [EMAIL
be 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
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 vote just to mention it's removal at this time,
Agreed. Done.
I don't see any
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
---(end of broadcast
..
If someone approves it, i'll work on making it a built-in backend
function, and make pg_dump use it.
This will also be great for 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
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 seldom used data off onto the
slower (lower cost) disks/storage array.
--
Darcy
;
}
---(end of broadcast)---
TIP 8: explain analyze is your friend
--
Darcy Buskermolen
Wavefire Technologies Corp.
ph: 250.717.0200
fx: 250.763.1759
http://www.wavefire.com
---(end of broadcast)---
TIP 2
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)---
TIP 6: Have you searched our list archives?
http://archives.postgresql.org
1070064251 811548
out of order tv_usec: 1070064947 508364, prev 1070064251 811548
Maybe it's a 4.9-PRERELEASE bug?
regards, tom lane
--
Darcy Buskermolen
Wavefire Technologies Corp.
ph: 250.717.0200
fx: 250.763.1759
http://www.wavefire.com
---(end
!?
Yahoo! SiteBuilder - Free, easy-to-use web site design software
http://sitebuilder.yahoo.com
---(end of broadcast)---
TIP 8: explain analyze is your friend
--
Darcy Buskermolen
Wavefire Technologies Corp.
ph: 250.717.0200
fx: 250.763.1759
http
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 too smart ...
Regards,
Hans
--
Darcy Buskermolen
Wavefire Technologies Corp.
ph
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
---(end of broadcast
100 matches
Mail list logo