[PERFORM] row-specific conditions possible?

2009-01-15 Thread Jörg Kiegeland
Hi, I want to store a boolean SQL condition in a column "condition_column" of my table "myTable". This condition refers to other columns of the same table and shall use one parameter, e.g. "column1=4 AND colume2+column3=param". Every row has a different condition in general.. So my query on t

Re: [PERFORM] row-specific conditions possible?

2009-01-15 Thread A. Kretschmer
In response to Jörg Kiegeland : > Hi, This list, [Perform], is obviously the wrong list for such... > > I want to store a boolean SQL condition in a column "condition_column" > of my table "myTable". > This condition refers to other columns of the same table and shall use > one parameter, e.g.

[PERFORM] Cost of INSERT rules

2009-01-15 Thread Enrico Weigelt
Hi folks, I really like the idea of exclusively using views as interfaces to the applications (each app has its own view, tuned for the app's access patterns). So, in my model, of course inserts and updates also happen through views, also more complex operations could be triggered through view

Re: [PERFORM] understanding postgres issues/bottlenecks

2009-01-15 Thread Jean-David Beyer
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 M. Edward (Ed) Borasky wrote: | Luke Lonergan wrote: |> Not to mention the #1 cause of server faults in my experience: OS |> kernel bug causes a crash. Battery backup doesn't help you much there. |> | | Well now ... that very much depends on where yo

Re: [PERFORM] Slow insert performace, 8.3 Wal related?

2009-01-15 Thread Bill Preston
Nothing special about that table. One index. It really seems that the system would grind to a stand-still when a lot of non-transaction inserts were run combined with the creation of some large temp tables. Since we added transactions and started using truncate, things have cleared up nicely

Re: [PERFORM] Slow insert performace, 8.3 Wal related?

2009-01-15 Thread Scott Marlowe
On Thu, Jan 15, 2009 at 2:55 PM, Bill Preston wrote: > Nothing special about that table. One index. > > It really seems that the system would grind to a stand-still when a lot of > non-transaction inserts were run combined with the creation of some large > temp tables. > > Since we added transacti

Re: [PERFORM] Slow insert performace, 8.3 Wal related?

2009-01-15 Thread Bill Preston
Thanks Scott. We are in Southern California. What I need someone for when the SHTF again, and if I can't handle it, I have some resource to get on the job right away. And it would help if they were a company that does this kind of thing so that I can get some buy in from those above. Rusty

Re: [PERFORM] understanding postgres issues/bottlenecks

2009-01-15 Thread M. Edward (Ed) Borasky
Jean-David Beyer wrote: > M. Edward (Ed) Borasky wrote: > | Luke Lonergan wrote: > |> Not to mention the #1 cause of server faults in my experience: OS > |> kernel bug causes a crash. Battery backup doesn't help you much there. > |> > | > | Well now ... that very much depends on where you *got* th

Re: [PERFORM] understanding postgres issues/bottlenecks

2009-01-15 Thread david
On Thu, 15 Jan 2009, Jean-David Beyer wrote: -BEGIN PGP SIGNED MESSAGE- Hash: SHA1 M. Edward (Ed) Borasky wrote: | Luke Lonergan wrote: |> Not to mention the #1 cause of server faults in my experience: OS |> kernel bug causes a crash. Battery backup doesn't help you much there. |> | |