PgSql

: CRC32 is limiting at COPY/CTAS/INSERT ... SELECT + speeding it up
This sounds familiar. If you search back in the archives around 2004 or so I think you'll find a similar discussion when we replaced the crc32 implementation with what we have now. We put a fair amount of effort into searching for faster implementations so if you've found one 3x faster I'm pretty startled. Are you ... 7 Jun 2010 10:45

PG 9.0 release timetable
On Sat, May 29, 2010 at 4:19 PM, Bruce Momjian <bruce(a)momjian.us> wrote: Assuming we want a release Postgres 9.0 by mid-August, here is how the timetable would look:        Need RC release to be stable for 1-2 weeks before final                RC must be released by August 1        Beta must be stable... 31 May 2010 14:10

[HACKERS] PG 9.0 release timetable
Assuming we want a release Postgres 9.0 by mid-August, here is how the timetable would look: Need RC release to be stable for 1-2 weeks before final RC must be released by August 1 Beta must be stable for 2-3 weeks before RC Stable beta must be released by early July So, we have 5-6 weeks to get a stabl... 29 May 2010 16:51

[HACKERS] Statistics for tsvector "wildcards". term*
Hi. There seems to be an "unimplemented" area around getting statistics for wildcard searches done. Wildcards anchored to the left can be matched up by the gin-index and the ts_match_vq operator: testdb=# select to_tsvector('project') @@ to_tsquery('proj:*'); ?column? ---------- t (1 row) Searching... 29 May 2010 10:16

Failback with log shipping
Heikki Linnakangas <heikki.linnakangas(a)enterprisedb.com> writes: Not shipped before the first failover you mean? No, if any WAL records were created in the old master that were not shipped to the standby before failover, the corresponding changes to the data files might've been flushed to disk already, and ... 29 May 2010 02:49

VPATH docs
Patch applied. Thanks. --------------------------------------------------------------------------- David Fetter wrote: Folks, Andrew Dunstan posted some instructions on his blog, and I'm thinking they clarify things a great deal for people who want to learn how to do VPATH builds. Atta... 28 May 2010 14:52

[BUGS] dividing money by money
I'm not quite sure how to go about changing it from an add-on function to a built-in one. So if you want to do that, go ahead. If you'd rather I did, just tell me how it's done. Andy Balholm (509) 276-2065 andy(a)balholm.com On May 26, 2010, at 11:18 AM, Kevin Grittner wrote: Hi Andy, Do you want to p... 28 May 2010 14:52

How to pass around collation information
Excerpts from Peter Eisentraut's message of vie may 28 12:27:52 -0400 2010: Option 2, invent some new mechanism that accompanies a datum or a type whereever it goes. Kind of like typmod, but not really. Then the collation information would presumably be made available to functions through the fmgr inter... 3 Jun 2010 12:17

[HACKERS] How to pass around collation information
I have been thinking about this collation support business a bit. Ignoring for the moment where we would get the actual collation routines from, I wonder how we are going to pass this information around in the system. Someone declares a collation on a column in a table, and somehow this information needs to arrive... 28 May 2010 12:39

pgsql: Mark PG_MODULE_MAGIC and PG_FUNCTION_INFO_V1with PGDLLEXPORT
On 27/05/10 10:59, Takahiro Itagaki wrote: Log Message: ----------- Mark PG_MODULE_MAGIC and PG_FUNCTION_INFO_V1 with PGDLLEXPORT independently from BUILDING_DLL. It is always __declspec(dllexport). It looks like the Windows buildfarm members are not happy about this change... -- Heikki Linnaka... 28 May 2010 11:33