Re: [HACKERS] New CRC algorithm: Slicing by 8

On 10/21/06, Tom Lane <[EMAIL PROTECTED]> wrote: [snip] It hasn't even been tested. One thing I'd want to know about is the performance effect on non-Intel machines. On Opteron 265 his test code shows SB8 (the intel alg) is 2.48x faster for checksum and 1.95x faster for verify for the 800 * 10

Re: [HACKERS] New CRC algorithm: Slicing by 8

Bruce Momjian <[EMAIL PROTECTED]> writes: > However, I am not sure getting a clarification from the author even > helps us legally. Also, why are we more critical of an Intel-provided > idea than any other idea we get from the community? Bitter experience with other companies. > So unless we hea

Re: [HACKERS] [COMMITTERS] pgsql: Fix up some problems in handling of zic-style time zone names in

Bruce Momjian <[EMAIL PROTECTED]> writes: > And this closes all the recent open issues with timezones, right? Until we find some more ;-) regards, tom lane ---(end of broadcast)--- TIP 9: In versions below 8.0, the planner w

Re: [HACKERS] xlogdump fixups and WAL log question.

"Simon Riggs" <[EMAIL PROTECTED]> writes: > But they can be re-created anew with the same name each time? Or I guess > not, but you redefine a view every 30 minutes to point to the latest > one? > If so, then I have a patch that will speed up COPY when in the same > transaction as the table that c

Re: [HACKERS] estimated_count() implementation

On Sat, Oct 21, 2006 at 11:44:19PM +0300, Volkan YAZICI wrote: > I'm trying to implement estimated_count() function that's mentioned in > the TODO list. First of all, I wanted to learn if this TODO item is > still valid? I looked at the related -hackers discussions, does anybody > want to say more

FW: [pgadmin-hackers] FW: [HACKERS] adminpack and pg_catalog

> -Original Message- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] On Behalf Of Dave Page > Sent: 21 October 2006 21:20 > To: PgAdmin Hackers > Subject: [pgadmin-hackers] FW: [HACKERS] adminpack and pg_catalog > > > [Ooops, forgot to CC the list] And then got the wrong one. D

Re: [HACKERS] Want to use my own query-plan

dakotali kasap wrote: > Therefore, I want to say the join-method that > will be used or which relation will be outer which one will be inner. > (I cannot do this just using SELECT * FROM a JOIN b). You can't force the system to use a particular join method, but you can select which one is inner

Re: [HACKERS] [PATCHES] Updates for vcbuild

"Magnus Hagander" <[EMAIL PROTECTED]> writes: > [ various fixes ] I'm confused: which of the files in src/tools/msvc need to have Windows-style newlines, if any? GNU patch wants to strip the newlines from your patches, so it'd be easiest from here if the answer is "none".

[HACKERS] Call for translations

With the upcoming release of PostgreSQL 8.2, it is once again time to update the message translations. If you want to help, see for instructions and other information. If there are already active translation teams, please communicate with them f

Re: [HACKERS] xlogdump fixups and WAL log question.

On Oct 21, 2006, at 4:40 PM, Simon Riggs wrote: On Sat, 2006-10-21 at 15:17 -0400, Theo Schlossnagle wrote: On Oct 21, 2006, at 3:12 PM, Simon Riggs wrote: On Sat, 2006-10-21 at 09:00 -0400, Theo Schlossnagle wrote: On Oct 21, 2006, at 6:08 AM, Martijn van Oosterhout wrote: On Sat, Oct 21

[HACKERS] estimated_count() implementation

Hi, I'm trying to implement estimated_count() function that's mentioned in the TODO list. First of all, I wanted to learn if this TODO item is still valid? I looked at the related -hackers discussions, does anybody want to say more sth related with the implementation? Also I've some questions. I'

Re: [HACKERS] xlogdump fixups and WAL log question.

On Sat, 2006-10-21 at 15:17 -0400, Theo Schlossnagle wrote: > On Oct 21, 2006, at 3:12 PM, Simon Riggs wrote: > > > On Sat, 2006-10-21 at 09:00 -0400, Theo Schlossnagle wrote: > >> On Oct 21, 2006, at 6:08 AM, Martijn van Oosterhout wrote: > >> > >>> On Sat, Oct 21, 2006 at 10:37:51AM +0100, Simon

Re: [HACKERS] New CRC algorithm: Slicing by 8

Gurjeet Singh wrote: > On 10/20/06, Alvaro Herrera <[EMAIL PROTECTED]> wrote: > > > > It doesn't say anything about > > being free of patents though. > > > > The Sourceforge project referred to in the article (but for which no > > link is given) seems to be this one: > > > > http://sourceforge.net/

Re: [HACKERS] Bitmap index status

Gavin Sherry wrote: > On Wed, 18 Oct 2006, Heikki Linnakangas wrote: > > > Hi, > > > > I don't want to harass you :), but what's the status with the bitmap > > index code? Is there something I can do to help? > > > > Hi Heikki, > > The streaming is implemented, as are range queries. I need to br

Re: [HACKERS] xlogdump fixups and WAL log question.

On Oct 21, 2006, at 3:12 PM, Simon Riggs wrote: On Sat, 2006-10-21 at 09:00 -0400, Theo Schlossnagle wrote: On Oct 21, 2006, at 6:08 AM, Martijn van Oosterhout wrote: On Sat, Oct 21, 2006 at 10:37:51AM +0100, Simon Riggs wrote: Turning off WAL is a difficult topic. Without it you have no cr

Re: [HACKERS] xlogdump fixups and WAL log question.

On Sat, 2006-10-21 at 09:00 -0400, Theo Schlossnagle wrote: > On Oct 21, 2006, at 6:08 AM, Martijn van Oosterhout wrote: > > > On Sat, Oct 21, 2006 at 10:37:51AM +0100, Simon Riggs wrote: > >> Turning off WAL is a difficult topic. Without it you have no crash > >> recovery, which IMHO everybody sa

Re: [HACKERS] [COMMITTERS] pgsql: Fix up some problems in handling of

And this closes all the recent open issues with timezones, right? --- Tom Lane wrote: > Log Message: > --- > Fix up some problems in handling of zic-style time zone names in datetime > input routines. Remove the for

Re: [SPAM?] Re: [HACKERS] Asynchronous I/O Support

Martijn van Oosterhout wrote: -- Start of PGP signed section. > On Fri, Oct 20, 2006 at 03:04:55PM -0400, Merlin Moncure wrote: > > On 10/20/06, Tom Lane <[EMAIL PROTECTED]> wrote: > > >So far I've seen no evidence that async I/O would help us, only a lot > > >of wishful thinking. > > > > is this

Re: [HACKERS] Granting all tables in schema by one SQL command

Dnia 19-10-2006 o 23:14:07 Merlin Moncure <[EMAIL PROTECTED]> napisał: What does "NEW TABLES" mean in this context? the point is to allow tables to inherit permissions from the parent schema. this is actually imo much more important than multiple table grant [...] There was considerable debate

Re: [HACKERS] adminpack and pg_catalog

On Friday 20 October 2006 21:03, Neil Conway wrote: > On Fri, 2006-10-20 at 22:59 +0200, Peter Eisentraut wrote: > > Nothing except initdb should add objects in pg_catalog. AFAICS, > > adminpack doesn't have any special requirements, so it should behave > > like all other contrib modules. > > Okay

Re: [HACKERS] xlogdump fixups and WAL log question.

On Oct 21, 2006, at 6:08 AM, Martijn van Oosterhout wrote: On Sat, Oct 21, 2006 at 10:37:51AM +0100, Simon Riggs wrote: Turning off WAL is a difficult topic. Without it you have no crash recovery, which IMHO everybody says they don't care about until they crash, then they realise. It's hard to

Re: [HACKERS] adminpack and pg_catalog

Dave Page wrote: > If you change it you will make it useless as pgAdmin won't > necessarily find the functions it expects. You might as well just > remove it (which will almost certainly cause delays to pgAdmin - and > pgInstallers - release as I'll need to find time to put it all back > how it was

Re: [HACKERS] xlogdump fixups and WAL log question.

On Sat, Oct 21, 2006 at 10:37:51AM +0100, Simon Riggs wrote: > Turning off WAL is a difficult topic. Without it you have no crash > recovery, which IMHO everybody says they don't care about until they > crash, then they realise. It's hard to be selective about writing WAL > for specific operations

Re: [HACKERS] Want to use my own query-plan

Actually, the system that we want to build up will keep incomplete information with a decomposition based approach. So a normal relation R will be represented on 3 different relations (T:template, C: components, W:worlds). According to this representation a normal selection with constant on R will

Re: [HACKERS] xlogdump fixups and WAL log question.

On Fri, 2006-10-20 at 17:04 -0400, Theo Schlossnagle wrote: > On Oct 20, 2006, at 4:24 PM, Simon Riggs wrote: > >> Is it possible to create tables in fashion that will not write info > >> to the WAL log -- knowingly and intentionally making them > >> unrecoverable? This is very desirable for us.

Re: [HACKERS] adminpack and pg_catalog

-Original Message- From: "Neil Conway" <[EMAIL PROTECTED]> To: "Dave Page" Cc: "PostgreSQL-development" Sent: 20/10/06 21:19 Subject: Re: adminpack and pg_catalog > It breaks in the sense of "completely not working" :) No, it does not 'break pg_dump'. What you have shown is that pg_d

Re: [HACKERS] adminpack and pg_catalog

-Original Message- From: "Neil Conway" <[EMAIL PROTECTED]> To: "Peter Eisentraut" <[EMAIL PROTECTED]> Cc: "pgsql-hackers@postgresql.org" ; "Dave Page" Sent: 21/10/06 02:03 Subject: Re: [HACKERS] adminpack and pg_catalog On Fri, 2006-10-20 at 22:59 +0200, Peter Eisentraut wrote: > Nothi