Re: [HACKERS] Tablespaces

2005-06-02 Thread Hans-Jürgen Schönig
Christopher Kings-Lynne wrote: I'm interested if anyone is using tablespaces? Do we have any actual reports of people actually using them, to advantage, in the field?? Maybe the next postgresql.org survey could be on tablespace usage? Chris I have seen that tablespaces are widely used and

[HACKERS] Tablespaces

2005-06-02 Thread Christopher Kings-Lynne
I'm interested if anyone is using tablespaces? Do we have any actual reports of people actually using them, to advantage, in the field?? Maybe the next postgresql.org survey could be on tablespace usage? Chris ---(end of broadcast)--- TIP 9:

[HACKERS] Google's Summer of Code: Too Late

2005-06-02 Thread Marc G. Fournier
Just got word back that they have reached their 'limit' on # of projects they are working with this summer ... considering they only 'opened up' the floor on the 31st, and its closed already ... damn, that was a small window of opportunity. But, I've been told to contact the co-ordinator in

[HACKERS] PostgreSQL Developer Network

2005-06-02 Thread Gevik babakhani
Dear People,   After a long time of various timeouts, I managed to get back on track developing the long promised PQDN website. As some of you might know. I was working on a project called the PostgreSQL Developer Network.   The websites (which is a la MSDN) is meant to provide a knowl

Re: [HACKERS] Google's Summer of Code ...

2005-06-02 Thread Vikram Kalsi
I am a MSEE student at Penn State (University Park), for the past few months I have been working on modifying parts of PostgreSQL for my research work. I doubt if my current work would serve any purpose for pgsql since it is experimental and research oriented, but all the same, I have gained famili

Re: [HACKERS] Google's Summer of Code ...

2005-06-02 Thread Marc G. Fournier
It is already being worked on ... more once we know more ... On Thu, 2 Jun 2005, Vishal Kashyap @ [SaiHertz] wrote: Dear all , Incidentally I havent seen any objections, if there are none should we go ahead and whip up an email to google? Do we want to run this through the We must go st

Re: [HACKERS] NOLOGGING option, or ?

2005-06-02 Thread Greg Stark
"Luke Lonergan" <[EMAIL PROTECTED]> writes: > In the data warehousing industry, data conversion and manipulation is > normally kept distinct from data loading. It's a bit strange to call this conversion or manipulation. One way or another you have to escape whatever your delimiters are. How wo

Re: [HACKERS] NOLOGGING option, or ?

2005-06-02 Thread Alon Goldshuv
>> 2) A modified command syntax for introducing a direct single row error >> handling. By direct I mean - a row that if rejected from within the COPY >> command context does not throw an error and rollsback the whole transaction. >> Instead the error is caught and recorded elsewhere, maybe in some

Re: [HACKERS] Google's Summer of Code ...

2005-06-02 Thread Dave Page
> -Original Message- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] On Behalf Of > Vishal Kashyap @ [SaiHertz] > Sent: 02 June 2005 16:19 > To: Robert Treat > Cc: Jonah H. Harris; Marc G. Fournier; > pgsql-hackers@postgresql.org; [EMAIL PROTECTED] > Subject: Re: [HACKERS] Googl

Re: [HACKERS] NOLOGGING option, or ?

2005-06-02 Thread Luke Lonergan
Steve, > I can only think of one where it's common. Windows filenames. Nearly all weblog data then. > But if > you're going to support arbitrary data in a load then whatever escape > character you choose will appear sometimes. If we allow an 8-bit character set in the "text" file, then yes, any

Re: [HACKERS] Google's Summer of Code ...

2005-06-02 Thread Vishal Kashyap @ [SaiHertz]
Dear all , > > Incidentally I havent seen any objections, if there are none should we go > ahead and whip up an email to google? Do we want to run this through the We must go straight away for it. I wonder why bigies like Bruce , Tom , Josh have not responded to this yet. To my opinion the b

Re: [HACKERS] NOLOGGING option, or ?

2005-06-02 Thread Steve Atkins
On Thu, Jun 02, 2005 at 07:33:13AM -0700, Luke Lonergan wrote: > Oliver, > > > Haven't you just replaced one preprocessing step with another, then? > > Generally not. The most common problem with the current choice of escape > character is that there are *lots* of data load scenarios with backsl

Re: [HACKERS] Google's Summer of Code ...

2005-06-02 Thread Jonah H. Harris
Cool. Thanks Marc. Marc G. Fournier wrote: Yes, been working on this since last night ... On Thu, 2 Jun 2005, Jonah H. Harris wrote: So, has anyone gone ahead and contacted Google yet? ---(end of broadcast)--- TIP 2: you can get off all li

Re: [HACKERS] NOLOGGING option, or ?

2005-06-02 Thread Luke Lonergan
Oliver, > Haven't you just replaced one preprocessing step with another, then? Generally not. The most common problem with the current choice of escape character is that there are *lots* of data load scenarios with backslash in the text strings. The extra preprocessing to escape them is unneces

Re: [HACKERS] NOLOGGING option, or ?

2005-06-02 Thread Luke Lonergan
Andreas, >> Escape processing would proceed as before, but the semantics would change to >> allow the use of different characters as the escape character, in addition >> to the special characters for delimiter and newline. > > If you mean syntax to specify escape and delimiter (and newline ?), >

Re: [HACKERS] Google's Summer of Code ...

2005-06-02 Thread Marc G. Fournier
Yes, been working on this since last night ... On Thu, 2 Jun 2005, Jonah H. Harris wrote: So, has anyone gone ahead and contacted Google yet? ---(end of broadcast)--- TIP 2: you can get off all lists at once with the unregister command (send

Re: [HACKERS] Google's Summer of Code ...

2005-06-02 Thread Jonah H. Harris
So, has anyone gone ahead and contacted Google yet? ---(end of broadcast)--- TIP 2: you can get off all lists at once with the unregister command (send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])

Re: [HACKERS] NOLOGGING option, or ?

2005-06-02 Thread Zeugswetter Andreas DAZ SD
> Escape processing would proceed as before, but the semantics would change to > allow the use of different characters as the escape character, in addition > to the special characters for delimiter and newline. If you mean syntax to specify escape and delimiter (and newline ?), that is a great a

Re: [HACKERS] NOLOGGING option, or ?

2005-06-02 Thread Hannu Krosing
On K, 2005-06-01 at 11:31 -0400, Tom Lane wrote: > Hannu Krosing <[EMAIL PROTECTED]> writes: > > I think this should be a decision done when creating a table, just like > > TEMP tables. So you always know if a certain table is or is not > > safe/replicated/recoverable. > > This has also the advanta

Re: [HACKERS] NOLOGGING option, or ?

2005-06-02 Thread Hannu Krosing
On K, 2005-06-01 at 18:05 -0400, Bruce Momjian wrote: > What we could do is to do no-WAL automatically for empty tables (like > when a database is first loaded), You forget that some databases use WAL for PITR / replication and doing it automatically there would surely mess up their replica. How