PgSql
in [SQL]
|
Hash index build patch has *worse* performanceat small table sizes Did we ever do anything about this? --------------------------------------------------------------------------- Tom Lane wrote: I've been reviewing the hash index build patch submitted here: http://archives.postgresql.org/pgsql-patches/2007-10/msg00154.php Although it definitely helps on large inde... 21 Jun 2008 18:54
-head build error report Linux jd-laptop 2.6.24-19-generic #1 SMP Wed Jun 4 16:35:01 UTC 2008 i686 GNU/Linux Using built-in specs. Target: i486-linux-gnu Configured with: ../src/configure -v --enable-languages=c,c ++,fortran,objc,obj-c++,treelang --prefix=/usr --enable-shared --with-system-zlib --libexecdir=/usr/lib --without-included-... 21 Jun 2008 10:43
Need "Round Robin Reviewer" volunteers Hackers, At the developer meeting, we determined that one thing needed to speed up the commitfests is a list of people who were available to review assigned patches, and someone to do the assigning. Well, for July I'm the assignor, and I'm looking for some assignees. Here's how it will work: July 1: commi... 24 Jun 2008 14:23
...Roll Back issue in PGSQL.. On Fri, 2008-06-20 at 13:10 +0530, Deepak wrote: Hi I am trying to create a TRIGGER function,that populates values to another table upon inserting a value into a table. The issue is,if there is a exception(in Table 2) everything gets rolled back including Table1.I dont want this to happen... 22 Jun 2008 21:24
Not valid dump [8.2.9, 8.3.1] Hi all, we have faced lately dumps not valid, the bug can be replicated using a 8.2.9 or a 8.3.1 server. These are the steps to create the database that will generate a not valid dump: ------------------------------------------------------- CREATE TABLE t_public ( a integer ); CREATE OR REPLACE FUNCTI... 21 Jun 2008 12:46
Plan targetlists in EXPLAIN output I have been working on a project (for GSOC) to retrieve planner/optimizer details. As part of the project, I need machine parsable output. So, I thought I would dust off a patch I found from last year that Germ�n Caama�o submitted. I didn't see any further activity there so I integrated it into 8.4 and added... 19 Jun 2008 18:52
tsearch is non-multibyte-aware in a few places I've identified the cause of bug #4253: /* Trim trailing space */ while (*pbuf && !t_isspace(pbuf)) pbuf++; *pbuf = '\0'; At least on Macs, t_isspace is capable of returning "true" when pointed at the second byte of a 2-byte UTF8 character. This explains th... 19 Jun 2008 13:42
Backend Stats Enhancement Request I would like to request a change to the PGBE_ACTIVITY_SIZE #define in the pgstat.h file. This value determines the max length of the SQL query contained in the PgBackendStatus structure. By increasing the value of this #define to 32768 we are able to capture queries larger than the 1024 default using just pgAdmin o... 22 Jun 2008 15:16
ANY/SOME/ALL with noncommutable operators I can do 'abc' LIKE ANY (ARRAY['a%','b%']) but not ANY (ARRAY['abc', 'def']) LIKE '%a' This seems to be a failing in the SQL standard. You can work around this by creating your own operators, but maybe there should be a general solution, as there are a lot of noncommutable operators and this example doe... 19 Jun 2008 10:36
ecpg generated files ignorable? Hi, I keep seeing these files show up in the source tree in a VPATH build: ? src/interfaces/ecpg/compatlib/libecpg_compatddll.def ? src/interfaces/ecpg/ecpglib/libecpgddll.def ? src/interfaces/ecpg/pgtypeslib/libpgtypesddll.def I am not sure if these should stay on the source dir (i.e. are they needed in th... 17 Jul 2008 17:53 |