[PERFORM] What is the fastest way to get a resultset

2003-08-25 Thread Bupp Phillips
I'm very new to Postgresql, so don't beat me up to bad if you see a problem, just inform me what I've done wrong. I'm use Postgresql 7.2 (PeerDirect's Windows port) on Win2000 384MB RAM 10GB of Free space 800 Mhz, using the ODBC driver 7.03.01.00. I have a table that has 103,000 records in it (re

Re: [PERFORM] Query too slow

2003-08-25 Thread Shridhar Daithankar
On 25 Aug 2003 at 8:44, Stephan Szabo wrote: > On Mon, 25 Aug 2003, Rhaoni Chiu Pereira wrote: > > > Hi List, > > > > As I said before, I'm not a DBA " yet" , but I'm learning ... and I > > already have a PostgreSQL running, so I have to ask some help... > > I got a SQL as folows : >

Re: [PERFORM] Query too slow

2003-08-25 Thread Stephan Szabo
On Mon, 25 Aug 2003, Rhaoni Chiu Pereira wrote: > Hi List, > > As I said before, I'm not a DBA " yet" , but I'm learning ... and I > already have a PostgreSQL running, so I have to ask some help... > I got a SQL as folows : ... Looking at the explain: It's choosing lots of nested loo

Re: [PERFORM] Tests

2003-08-25 Thread Tomka Gergely
2003-08-25 ragyogó napján scott.marlowe ezt üzente: > On Fri, 22 Aug 2003, Josh Berkus wrote: > > > Also another test I'd really like to see is hardware raid (Adaptec, LSI) > > against Linux software raid, and 5-disk RAID 5 against 4-disk RAID 1+0. > > It would be nice to cross those, so you have

Re: [PERFORM] Tests

2003-08-25 Thread Bill Moran
scott.marlowe wrote: On Fri, 22 Aug 2003, Josh Berkus wrote: Also another test I'd really like to see is hardware raid (Adaptec, LSI) against Linux software raid, and 5-disk RAID 5 against 4-disk RAID 1+0. It would be nice to cross those, so you have RAID5 sw vs RAID5 hw, vs RAID1+0 sw vs RAID1+

Re: [PERFORM] Tests

2003-08-25 Thread scott.marlowe
On Fri, 22 Aug 2003, Josh Berkus wrote: > Also another test I'd really like to see is hardware raid (Adaptec, LSI) > against Linux software raid, and 5-disk RAID 5 against 4-disk RAID 1+0. It would be nice to cross those, so you have RAID5 sw vs RAID5 hw, vs RAID1+0 sw vs RAID1+0 hw. Now if on

[PERFORM] Query too slow

2003-08-25 Thread Rhaoni Chiu Pereira
Hi List, I have posted a subjetc on the admin list but I thought that it might fit better on this list as follow: Hi List, As I said before, I'm not a DBA " yet" , but I'm learning ... and I already have a PostgreSQL running, so I have to ask some help... I got a SQL as folows