[HACKERS] Query planner/stored procedure cost

2003-02-20 Thread Jason M. Felice
Hello... I haven't been subscribed in a while, but I've got an issue and am trying to determine if the Right Way(tm) is the quickest way to fix it. Basically, I have some very expensive stored procedures that determine whether a user should have access to particular rows in a query (not a postgre

Re: [HACKERS] SQL99 ARRAY support proposal

2003-03-10 Thread Jason M. Felice
On Mon, Mar 10, 2003 at 09:49:47AM -0500, Tom Lane wrote: > Hannu Krosing <[EMAIL PROTECTED]> writes: > > Joe Conway kirjutas E, 10.03.2003 kell 05:35: > >> CREATE OR REPLACE FUNCTION array_push (anyarray, anyscalar) > >> RETURNS anyarray > > > could you make it > > RETURNS typeof($1) > > Not dir

Re: [HACKERS] PostgreSQL and SOAP, version 7.4/8.0

2003-03-28 Thread Jason M. Felice
First, a SOAP query should be posted in SOAP message format, not using the query string as you do. Second, I like the idea of calling external SOAP services, but consider creating a language 'soap' you could do with a CREATE FUNCTION type thing. e.g. CREATE FUNCTION "foo" (TEXT) RETURNS INTEGER A

Re: [HACKERS] PostgreSQL and SOAP, version 7.4/8.0

2003-03-28 Thread Jason M. Felice
On Fri, Mar 28, 2003 at 01:36:43PM -0500, [EMAIL PROTECTED] wrote: > Of course, CORBA has actually been quite formally standardized, suffers > from many fairly interoperable implementations, and is rather a lot less > bloated than any of the XML-based schemes. It might be worth trying, > too... T

[HACKERS] EXPLAIN ANALYZE in comparable units

2003-03-28 Thread Jason M. Felice
I'm curious if anyone's considered adding logic to count actual disk/cache hits to report for EXPLAIN ANALYZE so that we get a more apples-to-apples comparison? The other question is whether anyone has got scripts or tools or what not for testing and getting accurate numbers for the following tuni

Re: [HACKERS] PostgreSQL and SOAP, suggestions?

2003-04-03 Thread Jason M. Felice
On Thu, Apr 03, 2003 at 07:54:13AM -0500, [EMAIL PROTECTED] wrote: > > I have been planning to "test" the whole thing with a few .NET > > applications. I am currently using expat to parse the output to ensure > > that it all works correcty. > > That, unfortunately, probably implies that your imp