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

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_query() sounds like a very

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] [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

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't

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

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

[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

[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 addCell. Once

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