Re: [HACKERS] PostgreSQL 8.2beta1 w/ VALUES

2006-09-23 Thread Stephen Frost
Luke, et al, * Luke Lonergan ([EMAIL PROTECTED]) wrote: > > Except that one warning would not be accurate, because the > > warning is per tuple. How is postgresql going to know that > > the warning applies to the same set of data but just a > > different tuple? I didn't say it'd be easy. :) >

Re: [HACKERS] ReadBuffer(P_NEW) versus valid buffers

2006-09-23 Thread Alvaro Herrera
Joshua D. Drake wrote: > Tom Lane wrote: > >I asked around inside Red Hat but haven't gotten any responses yet ... > >seeing that it's a rather old Suse kernel, I can understand that RH's > >kernel hackers might not be too excited about investigating. (Alan Cox, > >for one, has got other things t

Re: [HACKERS] PostgreSQL 8.2beta1 w/ VALUES

2006-09-23 Thread Luke Lonergan
Josh, > > Anyhow, don't know if there's really a good solution but > it'd be nice > > to only get one warning, or one of a given type, or > something, and > > to > > Except that one warning would not be accurate, because the > warning is per tuple. How is postgresql going to know that >

Re: [HACKERS] PostgreSQL 8.2beta1 Now Available

2006-09-23 Thread Joshua D. Drake
Marc G. Fournier wrote: On Sat, 23 Sep 2006, Walter Cruz wrote: There's a date to postgreSQL 8.2 final? Figure 45-60 days, but not a firm date ... See Tom Lane's post. Joshua D. Drake ---(end of broadcast)--- TIP 1: if posting/reading thro

Re: [HACKERS] PostgreSQL 8.2beta1 w/ VALUES

2006-09-23 Thread Joshua D. Drake
Anyhow, don't know if there's really a good solution but it'd be nice to only get one warning, or one of a given type, or something, and to Except that one warning would not be accurate, because the warning is per tuple. How is postgresql going to know that the warning applies to the sam

Re: [HACKERS] Bitmap index status

2006-09-23 Thread Jie Zhang
Gavin & Heikki, >> >> The handling of stream and hash bitmaps looks pretty complicated to me. >> All the bitmap-related nodes have logic to handle both types slightly >> differently. It all seems to come down to that if a subnode (or >> amgetbitmap in a bitmap index scan node) returns a StreamBit

Re: [HACKERS] ReadBuffer(P_NEW) versus valid buffers

2006-09-23 Thread Joshua D. Drake
Tom Lane wrote: Mark Kirkwood <[EMAIL PROTECTED]> writes: The check looks good - are we chasing up the Linux kernel (or Suse) guys to get the bug investigated? I asked around inside Red Hat but haven't gotten any responses yet ... seeing that it's a rather old Suse kernel, I can understand tha

Re: [HACKERS] Buildfarm alarms

2006-09-23 Thread Tom Lane
"Andrew Dunstan" <[EMAIL PROTECTED]> writes: > It could certainly be done. In general, I have generally taken the view > that owners have the responsibility for monitoring their own machines. Sure, but providing them tools to do that seems within buildfarm's purview. For some types of failure, th

Re: [HACKERS] PostgreSQL 8.2beta1 Now Available

2006-09-23 Thread Marc G. Fournier
On Sat, 23 Sep 2006, Walter Cruz wrote: There's a date to postgreSQL 8.2 final? Figure 45-60 days, but not a firm date ... []'s - Walter On 9/23/06, Marc G. Fournier <[EMAIL PROTECTED]> wrote: Just a short note that the first Beta is now available on ftp.postgresql.org, and, shortly, o

Re: [HACKERS] Buildfarm alarms

2006-09-23 Thread Andrew Dunstan
Dave Page wrote: > > I'm just investigating a problem with beta 1 running on Windows 2K and > XP, and noticed that neither Snake or Bandicoot have built -HEAD for > nearly 3 weeks. I'm investigating why and will fix the problem, but it > strikes me that what would be useful is an alarm email from t

Re: [HACKERS] PostgreSQL 8.2beta1 Now Available

2006-09-23 Thread Tom Lane
"Walter Cruz" <[EMAIL PROTECTED]> writes: > There's a date to postgreSQL 8.2 final? [ ... all together now ... ] When it's ready. regards, tom lane ---(end of broadcast)--- TIP 2: Don't 'kill -9' the postmaster

Re: [HACKERS] ReadBuffer(P_NEW) versus valid buffers

2006-09-23 Thread Tom Lane
Mark Kirkwood <[EMAIL PROTECTED]> writes: > The check looks good - are we chasing up the Linux kernel (or Suse) guys > to get the bug investigated? I asked around inside Red Hat but haven't gotten any responses yet ... seeing that it's a rather old Suse kernel, I can understand that RH's kernel h

[HACKERS] PostgreSQL 8.2beta1 w/ VALUES

2006-09-23 Thread Stephen Frost
Greetings, Was just playing with 8.2beta1 and importing some data from MySQL and found something rather annoying. Not *100%* sure the best way to deal with this, if there even is a way, but... When loading a rather large data set I started getting errors along these lines: psql:/home/

Re: [HACKERS] PostgreSQL 8.2beta1 Now Available

2006-09-23 Thread Bruce Momjian
Walter Cruz wrote: > There's a date to postgreSQL 8.2 final? > > []'s No. --- > - Walter > > On 9/23/06, Marc G. Fournier <[EMAIL PROTECTED]> wrote: > > > > > > Just a short note that the first Beta is now available on >

Re: [HACKERS] PostgreSQL 8.2beta1 Now Available

2006-09-23 Thread Walter Cruz
There's a date to postgreSQL 8.2 final?[]'s- WalterOn 9/23/06, Marc G. Fournier <[EMAIL PROTECTED] > wrote:Just a short note that the first Beta is now available on ftp.postgresql.org, and, shortly, on the mirrors ...This isn't a full announce, which will be on Monday ... but please run afew tests,

Re: [HACKERS] Increase default effective_cache_size?

2006-09-23 Thread Stephen Frost
* Tom Lane ([EMAIL PROTECTED]) wrote: > Russ Brown <[EMAIL PROTECTED]> writes on pgsql-general: > > Thank you: the problem was the effective_cache_size (which I hadn't > > changed from the default of 1000). This machine doesn't have loads of > > RAM, but I knocked it up to 65536 and now the query u

Re: [HACKERS] Increase default effective_cache_size?

2006-09-23 Thread Gevik Babakhani
On Sat, 2006-09-23 at 17:14 -0700, Joshua D. Drake wrote: > >> Thank you: the problem was the effective_cache_size (which I hadn't > >> changed from the default of 1000). This machine doesn't have loads of > >> RAM, but I knocked it up to 65536 and now the query uses the index, > >> without having

Re: [HACKERS] ReadBuffer(P_NEW) versus valid buffers

2006-09-23 Thread Mark Kirkwood
Tom Lane wrote: So ReadBuffer without hesitation zeroes out the page of data we just filled, and returns it for re-filling. There went some tuples :-( Although this is clearly Not Our Bug, it's annoying that ReadBuffer falls into the trap so easily instead of complaining. I'm still disincline

Re: [HACKERS] Increase default effective_cache_size?

2006-09-23 Thread Joshua D. Drake
Thank you: the problem was the effective_cache_size (which I hadn't changed from the default of 1000). This machine doesn't have loads of RAM, but I knocked it up to 65536 and now the query uses the index, without having to change the statistics. Considering recent discussion about how 8.2 is

[HACKERS] Increase default effective_cache_size?

2006-09-23 Thread Tom Lane
Russ Brown <[EMAIL PROTECTED]> writes on pgsql-general: > On Thu, 2006-09-21 at 23:39 -0400, Jim Nasby wrote: >> Also make sure that you've set effective_cache_size >> correctly (I generally set it to total memory - 1G, assuming the >> server has at least 4G in it). > Thank you: the problem wa

Re: [HACKERS] pgsql: We're going to have to spell dotless i

2006-09-23 Thread Tom Lane
Alvaro Herrera <[EMAIL PROTECTED]> writes: > So maybe your Openjade is not exactly the same > Martijn was using, because what I understood was that Openjade replaced > the ı with ı, which should work. I think it's more likely that he was running with a non-DocBook stylesheet (his openjade command

Re: [HACKERS] pgsql: We're going to have to spell dotless i

2006-09-23 Thread Alvaro Herrera
Tom Lane wrote: > Martijn van Oosterhout writes: > > I created a simple docbook document on my computer with ı and > > ran openjade over and in the output file it is converted to ı. > > I experimented with that, and openjade didn't complain about it, but > it renders in my browser (Safari) as >

Re: [HACKERS] pgsql: We're going to have to spell dotless i

2006-09-23 Thread Tom Lane
Martijn van Oosterhout writes: > I created a simple docbook document on my computer with ı and > ran openjade over and in the output file it is converted to ı. I experimented with that, and openjade didn't complain about it, but it renders in my browser (Safari) as Have the COPY command return a

[HACKERS] Buildfarm alarms

2006-09-23 Thread Dave Page
Hi Andrew, I'm just investigating a problem with beta 1 running on Windows 2K and XP, and noticed that neither Snake or Bandicoot have built -HEAD for nearly 3 weeks. I'm investigating why and will fix the problem, but it strikes me that what would be useful is an alarm email from the server to no

Re: [HACKERS] Fwd: Is the fsync() fake on FreeBSD6.1?

2006-09-23 Thread Andrew - Supernews
On 2006-09-23, Tom Lane <[EMAIL PROTECTED]> wrote: > Andrew - Supernews <[EMAIL PROTECTED]> writes: >> Whether the underlying device lies about the write completion is another >> matter. All current SCSI disks have WCE enabled by default, which means >> that they will lie about write completion if

Re: [HACKERS] pgsql: We're going to have to spell dotless i

2006-09-23 Thread Martijn van Oosterhout
On Sat, Sep 23, 2006 at 12:27:51PM -0400, Tom Lane wrote: > To my mind the real problem is that one of the principal output formats > we are interested in is HTML, and there is no dotless-i entity in any > version of the HTML standard. I trust I need not point out again the > difference between "m

Re: [HACKERS] Fwd: Is the fsync() fake on FreeBSD6.1?

2006-09-23 Thread Tom Lane
Andrew - Supernews <[EMAIL PROTECTED]> writes: > Whether the underlying device lies about the write completion is another > matter. All current SCSI disks have WCE enabled by default, which means > that they will lie about write completion if FUA was not set in the > request, which FreeBSD never se

[HACKERS] ReadBuffer(P_NEW) versus valid buffers

2006-09-23 Thread Tom Lane
Some off-list investigation of Dan Kavan's data loss problem, http://archives.postgresql.org/pgsql-admin/2006-09/msg00092.php has led to the conclusion that it seems to be a kernel bug. The smoking gun is this strace excerpt: > lseek(10, 0, SEEK_END) = 913072128 > write(10, "\0\0\

Re: [HACKERS] pgsql: We're going to have to spell dotless i as plain i, because

2006-09-23 Thread Peter Eisentraut
Martijn van Oosterhout wrote: > Oh sorry, it wasn't clear from the commit entry. It's not that > DocBook doesn't support the character or that it can't be > represented. It's just not supported in the document encoding we're > using. No, no, and no. The reason that it doesn't work is that the doc

Re: [HACKERS] pgsql: We're going to have to spell dotless i

2006-09-23 Thread Tom Lane
Martijn van Oosterhout writes: > So to me (a more docbook novice) it seems like it's the stylesheet > that's limiting you to latin1, not the docbook parser. But the "stylesheet" in question is part of the basic docbook infrastructure, so the above distinction is academic. (Or at least that's wha

Re: [HACKERS] pgsql: We're going to have to spell dotless i

2006-09-23 Thread Martijn van Oosterhout
On Sat, Sep 23, 2006 at 08:49:02AM -0400, Bruce Momjian wrote: > That's not how I understand it. The document encoding is only related > to how high-bit characters are interpreted, I am told by Peter, but for > some reason the toolchain just doesn't support UTF8, even though if you > use ı in SGML

Re: [HACKERS] pgsql: We're going to have to spell dotless i

2006-09-23 Thread Bruce Momjian
Martijn van Oosterhout wrote: -- Start of PGP signed section. > On Sat, Sep 23, 2006 at 11:54:47AM +0200, Peter Eisentraut wrote: > > Martijn van Oosterhout wrote: > > > Well you could always use te HTML4 ı which most tools should > > > understand. At least browsers have good support for this kind

Re: [HACKERS] pgsql: We're going to have to spell dotless i as plain i, because

2006-09-23 Thread Martijn van Oosterhout
On Sat, Sep 23, 2006 at 11:54:47AM +0200, Peter Eisentraut wrote: > Martijn van Oosterhout wrote: > > Well you could always use te HTML4 ı which most tools should > > understand. At least browsers have good support for this kind of > > entity. > > Please review the recent thread on pgsql-docs befo

Re: [HACKERS] pgsql: We're going to have to spell dotless i as plain i, because

2006-09-23 Thread Peter Eisentraut
Martijn van Oosterhout wrote: > Well you could always use te HTML4 ı which most tools should > understand. At least browsers have good support for this kind of > entity. Please review the recent thread on pgsql-docs before reiterating all the suggestions. -- Peter Eisentraut http://developer.po

Re: [HACKERS] pgsql: We're going to have to spell dotless i as plain i, because

2006-09-23 Thread Martijn van Oosterhout
On Fri, Sep 22, 2006 at 12:29:05PM -0300, Tom Lane wrote: > Log Message: > --- > We're going to have to spell dotless i as plain i, because dotless i is > not in the character set supported by DocBook nor standard HTML. (Sorry > Volkan.) Also replace random character-set references by a p