Re: [PERFORM] slow select

2003-10-26 Thread Shridhar Daithankar
Vivek Khera wrote: "JB" == Josh Berkus <[EMAIL PROTECTED]> writes: JB> Actually, what OS's can't use all idle ram for kernel cache? I JB> should note that in my performance docs FreeBSD. Limited by the value of "sysctl vfs.hibufspace" from what I understand. This value is set at boot based

Re: [PERFORM] Various performance questions

2003-10-26 Thread Christopher Browne
[EMAIL PROTECTED] (Dror Matalon) wrote: > On Sun, Oct 26, 2003 at 10:49:29PM -0500, Greg Stark wrote: >> Dror Matalon <[EMAIL PROTECTED]> writes: >> >> > explain analyze select count(*) from items where channel < 5000; >> > QUERY PLAN >> > --

Re: [PERFORM] Various performance questions

2003-10-26 Thread Dror Matalon
On Sun, Oct 26, 2003 at 10:49:29PM -0500, Greg Stark wrote: > Dror Matalon <[EMAIL PROTECTED]> writes: > > > explain analyze select count(*) from items where channel < 5000; > > QUERY PLAN > > -

[PERFORM] Duplicate in pg_user table

2003-10-26 Thread CHEWTC
Hi Currently we are running Postgresql v7.3.2 on Redhat Linux OS v9.0. We have Windows2000 client machines inserting records into the Postgresql tables via the Postgres ODBC v7.3.0100. After a few weeks of usage, when we do a \d at the sql prompt, there was a duplicate object name in the same sch

Re: [PERFORM] Various performance questions

2003-10-26 Thread Greg Stark
Dror Matalon <[EMAIL PROTECTED]> writes: > explain analyze select count(*) from items where channel < 5000; > QUERY PLAN > ---

Re: [PERFORM] Slow performance with no apparent reason

2003-10-26 Thread Hannu Krosing
Yonatan Goraly kirjutas P, 26.10.2003 kell 00:25: > I am in the process of adding PostgreSQL support for an application, > in addition to Oracle and MS SQL. > I am using PostgreSQL version 7.3.2, Red Hat 9.0 on Intel Pentium III > board. > > I have a query that generally looks like this: > > SEL

[PERFORM] Various performance questions

2003-10-26 Thread Dror Matalon
Hi, We're in the process of setting up a new database server. The application is an online rss aggregator which you can see at www.fastbuzz.com (still running with the old hardware). The new machine is a dual Xeon with 2 Gigs of ram The OS is freebsd 4.9. shared_buffers = 1 sort_mem = 327

Re: [PERFORM] Slow performance with no apparent reason

2003-10-26 Thread Yonatan Goraly
I run ANALYZE and the problem resolved Thanks Yonatan Goraly kirjutas P, 26.10.2003 kell 00:25: I am in the process of adding PostgreSQL support for an application, in addition to Oracle and MS SQL. I am using PostgreSQL version 7.3.2, Red Hat 9.0 on Intel Pentium III board. I have a query th

[PERFORM] explicit casting required for index use

2003-10-26 Thread Reece Hart
Here's the basic issue: PostgreSQL doesn't use indexes unless a query criterion is of exactly the same type as the index type. This occurs even when a cast would enable the use of an index and greatly improve performance. I understand that casting is needed to use an index and will therefore af

[PERFORM] Slow performance with no apparent reason

2003-10-26 Thread Yonatan Goraly
I am in the process of  adding PostgreSQL support for an application, in addition to Oracle and MS SQL. I am using PostgreSQL version 7.3.2, Red Hat 9.0 on Intel Pentium III board. I have a query that generally looks like this: SELECT t1.col1, t2.col1 FROM t1, t2 WHERE t1.x=t2.y AND t2.p='str