Hi again
It seems now that I am one step away from the end. So far I have succeeded
in returing row by row from the backend to the frontend, knew this from
debugging.
Now comes the point of displaying them directly not to wait till the end of
the query. These are the steps I took:
1) redef
But then what about the null values? Perhaps unique + notnull is better?
Otto
2007/4/20, Nicolas Barbier <[EMAIL PROTECTED]>:
2007/4/16, Ottó Havasvölgyi <[EMAIL PROTECTED]>:
> Eliminate the table T from the query/subquery if the following
requirements
> are satisfied:
> 1. T is left joined
Hello
For a particular query, are there any functions which can give me the
start-up cost, total run-cost, number of rows and width?
Thanks,
Sharat.
I've been seeing this failure intermittently on Narwhal HEAD, and once
on 8.1. Other branches have been OK, as have other animals running on
the same physical box. Narwhal-HEAD is run more often than any other
builds however.
Anyone have any idea what might be wrong? It seems unlikely to be a
hard
On Apr 21, 2007, at 4:46 , sharath kumar wrote:
For a particular query, are there any functions which can give me
the start-up cost, total run-cost, number of rows and width?
-hackers is a list for discussion of development of PostgreSQL
itself. Your question would probably be more appropr
Peter Eisentraut wrote:
Andrew Dunstan wrote:
Log Message:
---
Add --with-libxslt configure option
It should be added to the installation documentation as well.
done
cheers
andrew
---(end of broadcast)---
TIP 3: Have you
"Tom Lane" <[EMAIL PROTECTED]> writes:
> Applied along with some other hacking to reduce the costs of the
> lower-level functions that this example shows to be inefficient.
> They'd still be slow in large queries, whether CE applies or not.
BIG difference. The case that caused swapping and took
"Gregory Stark" <[EMAIL PROTECTED]> writes:
> "Tom Lane" <[EMAIL PROTECTED]> writes:
>
>> Applied along with some other hacking to reduce the costs of the
>> lower-level functions that this example shows to be inefficient.
>> They'd still be slow in large queries, whether CE applies or not.
>
> BI
Gregory Stark <[EMAIL PROTECTED]> writes:
> "Tom Lane" <[EMAIL PROTECTED]> writes:
>> Applied along with some other hacking to reduce the costs of the
>> lower-level functions that this example shows to be inefficient.
>> They'd still be slow in large queries, whether CE applies or not.
> BIG diff
Magnus Hagander wrote:
Tom Lane wrote:
Magnus Hagander <[EMAIL PROTECTED]> writes:
No, it's definitly the right primitive. But we're creating it with a max
count of 1.
That's definitely wrong. There are at least three reasons for a PG
process's semaphore to be signaled (heavywe
Well, I'm thinking in define (maybe via SQL) a set of servers as a
cluster and make the fragmentation rules based on "select clauses",
storing this "configuration" in a specific catalog in global schema.
For example: when a record is inserted in a server which not store
this fragment (no rule matc
On Sat, 2007-04-21 at 02:38 -0400, Tom Lane wrote:
> Maybe so, but you're going to be writing quite a lot of duplicative
> code, because the existing routines you might have been thinking of
> using (lsyscache.c etc) don't behave that way.
Right, I'm envisioning doing a conditional LockAcquire and
On Sat, 2007-04-21 at 17:56 -0400, Neil Conway wrote:
> Right, I'm envisioning doing a conditional LockAcquire and then
> heap_open() / heap_getnext() by hand. That will be relatively slow, but
> code that emits a deadlock error message is almost by definition not
> performance critical.
... altho
Hello,
I translated some things and I corrected many others in the
translation of pgadmin3 for Portuguese of Brazil. It incorrectly had
much translated thing, and much thing with translation of one another
one. It would like to know you as I can disponibilizar this my small
contribution.
--
Nabu
Nabucodonosor Coutinho wrote:
> I translated some things and I corrected many others in the
> translation of pgadmin3 for Portuguese of Brazil. It incorrectly had
> much translated thing, and much thing with translation of one another
> one. It would like to know you as I can disponibilizar this m
Dave Page <[EMAIL PROTECTED]> writes:
> I've been seeing this failure intermittently on Narwhal HEAD, and once
> on 8.1. Other branches have been OK, as have other animals running on
> the same physical box. Narwhal-HEAD is run more often than any other
> builds however.
> Anyone have any idea wha
ops, error when typing the name of the list. excuses
2007/4/21, Euler Taveira de Oliveira <[EMAIL PROTECTED]>:
Nabucodonosor Coutinho wrote:
> I translated some things and I corrected many others in the
> translation of pgadmin3 for Portuguese of Brazil. It incorrectly had
> much translated thi
I wrote:
> I'm still feeling a bit annoyed with the behavior of the stats machinery
> (pgstat_initstats and related macros).
> ... That means more UDP traffic and more work for
> the stats collector. gprof won't show the resulting overhead since
> it doesn't know anything about kernel-level overhe
18 matches
Mail list logo