[PERFORM] poor VACUUM performance on large tables

2005-09-03 Thread Jan Peterson
Hello, We have been experiencing poor performance of VACUUM in our production database. Relevant details of our implementation are as follows: 1. We have a database that grows to about 100GB. 2. The database is a mixture of large and small tables. 3. Bulk data (stored primarily in pg_largeobj

Re: [PERFORM] Improving performance of a query

2005-09-03 Thread Michael Fuhr
On Sat, Sep 03, 2005 at 09:02:27PM +, Carlos Benkendorf wrote: > Is there a way to improve the performance of the following query? > > SELECT * FROM SSIRRA where > (YEAR = 2004 and CUSTOMER = 04 and CODE = 00 and PART >= 00) or > (YEAR = 2004 and CUSTOMER = 04 and CODE > 00

[PERFORM] Improving performance of a query

2005-09-03 Thread Carlos Benkendorf
Hi,   Is there a way to improve the performance of the following query?   SELECT * FROM SSIRRA where (YEAR = 2004 and CUSTOMER = 04 and CODE = 00 and PART >= 00) or (YEAR = 2004 and CUSTOMER = 04 and CODE > 00) or (YEAR = 2004 and CUSTOMER > 04) or (YEAR > 2004)   Thanks in