Re: [PERFORM] On the performance of views

2004-01-28 Thread Shridhar Daithankar
Josh Berkus wrote: Bill, Some functions they prototyped in MSSQL even return different types, based on certian parameters, I'm not sure how I'll do this in Postgres, but I'll have to figure something out. We support that as of 7.4.1 to an extent; check out Polymorphic Functions. To my

Re: [PERFORM] On the performance of views

2004-01-28 Thread Bill Moran
Shridhar Daithankar wrote: Josh Berkus wrote: Bill, Some functions they prototyped in MSSQL even return different types, based on certian parameters, I'm not sure how I'll do this in Postgres, but I'll have to figure something out. We support that as of 7.4.1 to an extent; check out

Re: [PERFORM] High Performance/High Reliability File system on

2004-01-28 Thread markw
On 23 Jan, Dave Thompson wrote: Hello All Just wanted to gather opinions on what file system has the best balance between performance and reliability when used on a quad processor machine running SuSE64. Thanks DAve Hi Dave, I have some data for performance using our DBT-2 workload

[PERFORM] Optimization questions

2004-01-28 Thread Greg Spiegelberg
Couple quick questions. 1. Turning autocommit=FALSE is most useful when using COPY to load data to a table and could impact the performance of INSERT of similiar data on the same table. 2. What comparison operator is the most efficient when comparing text or varchar? Today the SELECT I

[PERFORM] Linux / Clariion

2004-01-28 Thread Cott Lang
Anybody used Linux with EMC Clariions for PG databases? Any good war stories, pros, cons, performance results ? I'm wearing thin on my 6 disk 0+1 configuration and looking for something beefy, possibly for clustering, and I'm wondering what the net wisdom is. :) thanks!

Re: [PERFORM] Linux / Clariion

2004-01-28 Thread Nick Barr
Cott Lang wrote: Anybody used Linux with EMC Clariions for PG databases? Any good war stories, pros, cons, performance results ? I'm wearing thin on my 6 disk 0+1 configuration and looking for something beefy, possibly for clustering, and I'm wondering what the net wisdom is. :) thanks!

[PERFORM] query optimization question

2004-01-28 Thread Jack Coates
Hi all, I've got a query that needs some help, please. Is there a way to avoid all the looping? I've got freedom to work with the double-indented sections below ) AND (, but the initial select distinct wrapper is much more difficult to change. This is auto-generated code. explain analyze SELECT

[PERFORM] postgres timeout.

2004-01-28 Thread Stef
Hi all , I'm trying to find out if there is a specific setting to make transactions time out faster in a scenario where there's an update on a table in a transaction block, and another update process tries to update the same column. It looks like the second process will wait until you end the

Re: [PERFORM] [SQL] postgres timeout.

2004-01-28 Thread Tom Lane
Stef [EMAIL PROTECTED] writes: I'm trying to find out if there is a specific setting to make transactions time out faster in a scenario where there's an update on a table in a transaction block, and another update process tries to update the same column. It looks like the second process

Re: [PERFORM] postgres timeout.

2004-01-28 Thread Stef
Forgot to mention that I use postgres 7.3.4 Stef mentioned : = Hi all , = = I'm trying to find out if there is a specific setting = to make transactions time out faster in a scenario = where there's an update on a table in a transaction = block, and another update process tries to update = the