Clearly I need to learn how to spell 'coalesce'. Nevermind.
On Sun, Mar 06, 2005 at 01:09:12AM -0600, Jim C. Nasby wrote:
> ERROR: function coalence(interval, interval) does not exist
>
> I'm guessing this is an oversight, right? Where would I go about fixing
> it?
> --
> Jim C. Nasby, Database
ERROR: function coalence(interval, interval) does not exist
I'm guessing this is an oversight, right? Where would I go about fixing
it?
--
Jim C. Nasby, Database Consultant [EMAIL PROTECTED]
Give your computer some brain candy! www.distributed.net Team #1828
Windows: "Where do yo
I was profiling a case involving UPDATEs into a table with too many
indexes (brought to mind by mysql's sql-bench, about which more later)
and got this rather surprising result for routines costing more than
1% of the total runtime:
Each sample counts as 0.01 seconds.
% cumulative self
I wouldn't mind being able to provide hints to the planner. For
example, I have some set-returning functions that typically return
10-100 rows and I usually have a good idea of how many rows a
particular set of inputs will generate, and sometimes I know other
characteristics about those rows as we
Just an update, the __INTEL_COMPILER is true on Itanium if icc is
being used. So, the following worked for me-
---BEGIN OLD
s_lock.h-
#if defined(__ia64__) || defined(__ia64) /* __ia64 used by ICC compiler? */
#define HAS_TES
On Sat, Mar 05, 2005 at 07:56:16PM +0200, Alex wrote:
> I was wondering if it's possible to make postgresql backend to
> adjust his priority based by an parameter to begin..
This has come up before -- search the list archives to see past
discussion. Here's a message that sums up the arguments ag
Simon Riggs <[EMAIL PROTECTED]> writes:
> The checkpoints are the source of the peak latency on transactions, so we
> are in complete agreement.
I realize that. I was just supporting your conclusion but saying that latency
is important in its own right, not just as a means to achieving throughpu
Hello,
It's no possible now. But I prepared small patch which implemented
variables sqlcode and sqlerrm for plpgsql. I can send it tomorrow.
regards
Pavel Stehule
On Sat, 5 Mar 2005, Ali Baba wrote:
> Hi ,
>
> I am looking for the way to get the error code
> corresponding to the exception in
On Fri, 2005-03-04 at 20:10 -0500, Greg Stark wrote:
> Simon Riggs <[EMAIL PROTECTED]> writes:
>
> > Amdahl's Law tells me that looking at the checkpoints is the next best
> > action for tuning, since they add considerably to the average response
> > time. Looking at the oprofile for the run as a
Hello..
I was wondering if it's possible to make postgresql
backend to adjust his priority based by an parameter to begin..
i.e: For linux , a "BEGIN -20" to
renice backend priority to -20..
This should be easy (i hope) to implement using
setpriority(..) , but there are a few question
On Sat, Mar 05, 2005 at 11:05:32AM -0500, [EMAIL PROTECTED] wrote:
> Being able to assign "hints" to queries may be able to allow DBAs to tune
> queries in tables who's characteristics are misrepresented by the
> statistics in ANALYZE.
I wouldn't mind being able to provide hints to the planner.
Tom recently said, when talking about allowing the user (in this case me)
from passing a hash table size to "create index:"
"but that doesn't mean I want to make the user deal with it."
I started thinking about this and, maybe I'm old fashioned, but I would
like the ability to deal with it. So m
On Sat, Mar 05, 2005 at 06:03:20AM -0800, Ali Baba wrote:
> I am looking for the way to get the error code
> corresponding to the exception in plpgsql.
What exception? Can you describe what you're trying to do? Are
you using the EXCEPTION clause that's available in the latest
release, or are yo
Hi ,
I am looking for the way to get the error code
corresponding to the exception in plpgsql.
Can any body guide me.
Thanks,
Asif Ali
__
Celebrate Yahoo!'s 10th Birthday!
Yahoo! Netrospective: 100 Moments of the Web
http://birthday.y
Pailloncy Jean-Gerard wrote:
You should have a look to this thread
http://archives.postgresql.org/pgsql-hackers/2005-02/msg00263.php
Take a look at this paper about "lock-free parallel hash table"
http://www.cs.rug.nl/~wim/mechver/hashtable/
Is this relevant? Hash indexes are on-disk data structure
Magnus Hagander wrote:
This is a lot like what I was planning to work towards with the
refactoring of the forkexec code I promised to do for 8.1.
Cool. BTW, have we accepted that EXEC_BACKEND is the way we're going to
workaround the lack of fork() on Win32 for the foreseeable future? I
mean, it _
16 matches
Mail list logo
