Re: [HACKERS] modifying the table function

2007-04-21 Thread Islam Hegazy
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

Re: [HACKERS] Eliminating unnecessary left joins

2007-04-21 Thread Ottó Havasvölgyi
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

[HACKERS] functions to obtain query plan

2007-04-21 Thread sharath kumar
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.

[HACKERS] [Fwd: PGBuildfarm member narwhal Branch HEAD Status changed from OK to InstallCheck failure]

2007-04-21 Thread Dave Page
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

Re: [HACKERS] functions to obtain query plan

2007-04-21 Thread Michael Glaesemann
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

Re: [HACKERS] [COMMITTERS] pgsql: Add --with-libxslt configure option

2007-04-21 Thread Andrew Dunstan
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

Re: [HACKERS] 27 second plan times

2007-04-21 Thread Gregory Stark
"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

Re: [HACKERS] 27 second plan times

2007-04-21 Thread Gregory Stark
"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

Re: [HACKERS] 27 second plan times

2007-04-21 Thread Tom Lane
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

[HACKERS] Re: [BUGS] BUG #3242: FATAL: could not unlock semaphore: error code 298

2007-04-21 Thread Marcin Waldowski
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

Re: [HACKERS] Fragmentation project

2007-04-21 Thread Gustavo Tonini
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

Re: [HACKERS] Improving deadlock error messages

2007-04-21 Thread Neil Conway
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

Re: [HACKERS] Improving deadlock error messages

2007-04-21 Thread Neil Conway
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

[HACKERS] PgAdmin pt_BR traduction

2007-04-21 Thread Nabucodonosor Coutinho
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

Re: [HACKERS] PgAdmin pt_BR traduction

2007-04-21 Thread Euler Taveira de Oliveira
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

Re: [HACKERS] [Fwd: PGBuildfarm member narwhal Branch HEAD Status changed from OK to InstallCheck failure]

2007-04-21 Thread Tom Lane
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

Re: [HACKERS] PgAdmin pt_BR traduction

2007-04-21 Thread Nabucodonosor Coutinho
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

Re: [HACKERS] 27 second plan times

2007-04-21 Thread Tom Lane
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