Re: [HACKERS] Commitfest patches

2008-03-29 Thread Greg Smith
On Fri, 28 Mar 2008, Gregory Stark wrote: I described which interfaces worked on Linux and Solaris based on empirical tests. I posted source code for synthetic benchmarks so we could test it on a wide range of hardware. I posted graphs based on empirical results. Is it possible to post whateve

[HACKERS] printTable API (was: Show INHERIT in \du)

2008-03-29 Thread Brendan Jurd
On 25/03/2008, Tom Lane <[EMAIL PROTECTED]> wrote: > "Brendan Jurd" <[EMAIL PROTECTED]> writes: > > This makes me wonder whether print.c could offer something a bit more > > helpful to callers wishing to DIY a table; we could have a > > table-building struct with methods like addHeader and addCe

[HACKERS] buildfarm member jaguar doesn't like truncate-triggers code

2008-03-29 Thread Tom Lane
jaguar has failed twice in the same spot since the truncate-triggers patch was committed: TRUNCATE trunc_trigger_test; ! server closed the connection unexpectedly ! This probably means the server terminated abnormally ! before or while processing the request. ! connection to server w

Re: [HACKERS] Third thoughts about the DISTINCT MAX() problem

2008-03-29 Thread Tom Lane
I wrote: > Plan B was to try to revert to the way sort clause matching was > done pre-8.3, that is have make_sort_from_pathkeys check first > for a matching ressortgroupref tag before it goes looking for equal() > expressions. So I tried that, and after a whole bunch of regression test failures I

Re: [HACKERS] [PATCHES] Auto-explain patch

2008-03-29 Thread Dean Rasheed
This was originally because I wanted a convenient way to see the execution plan of SQL queries run from stored procedures - http://archives.postgresql.org/pgsql-performance/2008-01/msg00245.php My original patch is fairly basic - it adds a new parameter debug_explain_plan which is similar to debu

Re: [HACKERS] [PATCHES] Implemented current_query

2008-03-29 Thread Tom Lane
Bruce Momjian <[EMAIL PROTECTED]> writes: > Uh, I think based on other usage it should be called client_statement(). That is *exactly* the wrong thing, because "statement" specifically means one SQL statement. "client_query" seems about the best compromise I've heard so far. It's too bad we didn

Re: [HACKERS] [DOCS] pg_total_relation_size() and CHECKPOINT

2008-03-29 Thread Andrew Dunstan
Zubkovsky, Sergey wrote: In the prepared custom build of PG 8.3.1 the native MSVC's stat() was rewrote by adding GetFileAttributesEx() to correct stat's st_size value. I had seen that a result of MSVC's stat() and a result of GetFileAttributesEx() may be differ by the file size values at le

Re: [HACKERS] [PATCHES] Avahi support for Postgresql

2008-03-29 Thread tomas
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 On Sat, Feb 23, 2008 at 01:13:38PM +0100, Mathias Hasselmann wrote: [...] > Avahi/Bonjour/DNS-SD support[1] is very important, for integrating > Postgresql with modern desktop environments like OSX, GNOME, KDE: It's > very convenient to choose active

Re: [HACKERS] [PATCHES] Implemented current_query

2008-03-29 Thread Bruce Momjian
Bruce Momjian wrote: > Alvaro Herrera wrote: > > Tomas Doran wrote: > > > > > On 28 Mar 2008, at 17:23, Bruce Momjian wrote: > > > > >> Perhaps we could name it received_query() to indicate it is what the > > >> backend received and it not necessarily the _current_ query. > > > > > > reveived_que

Re: [HACKERS] Third thoughts about the DISTINCT MAX() problem

2008-03-29 Thread Simon Riggs
On Sat, 2008-03-29 at 07:07 +0530, Gurjeet Singh wrote: > On Sat, Mar 29, 2008 at 3:21 AM, Tom Lane <[EMAIL PROTECTED]> wrote: > regression=# select max(unique1), generate_series(1,3) as g > from tenk1 order by g desc; > max | g > --+--- > | 1 >