Re: [PERFORM] Poor SQL performance

Place 'and date(r.site_timestamp) = h.first_order_date' after WHERE Best regards, Alexander Kirpa ---(end of broadcast)--- TIP 6: explain analyze is your friend

Re: [PERFORM] Data Warehousing Tuning

pt/pg_xlog on this drives. Best regards, Alexander Kirpa ---(end of broadcast)--- TIP 4: Have you searched our list archives? http://archives.postgresql.org

Re: [PERFORM] How to improve db performance with $7K?

00. 3. SCSI 320 Cable set. 4. Old drives (2) use for OS (optional DB log) files in RAID1 mode, possible over one channel of MegaRAID. 5. New drives (4+) in RAID10 mode for DB 6. Start tuning Postres + OS: more shared RAM etc. Best regards, Alexander Kirpa ---(end of broa

Re: [PERFORM] Postgres on RAID5

SQL 3. If possible migrate from RAID5 to RAID10. 4. Add (if need) 2 new drive for OS and use ALL 20x9GB drive for DB storage. 5. Remove CDROM from work configuration and start use this scsi channel. Best regards, Alexander Kirpa ---(end of broadcast

Re: [PERFORM] Processor optimization compile options?

'CFLAGS= -O3 -pipe -mfpmath=sse -msse2 -msse -mmmx -march=pentium4 -mcpu=pentium4' - w/o any problem. As I remember improvement as always task depended and have 30-100%. Best regards, Alexander Kirpa