Re: [GENERAL] Very slow queries on 8.1

2005-11-17 Thread David Rysdam
Michael Fuhr wrote: On Thu, Nov 17, 2005 at 10:38:50AM -0500, David Rysdam wrote: I'm porting an application from Sybase and I've noticed that similar application functions take 2 to 3 times longer on postgres than they used to on the same machine running under Sybase. I've tried changing

Re: [GENERAL] Very slow queries on 8.1

2005-11-17 Thread Michael Fuhr
On Thu, Nov 17, 2005 at 10:38:50AM -0500, David Rysdam wrote: > I'm porting an application from Sybase and I've noticed that similar > application functions take 2 to 3 times longer on postgres than they > used to on the same machine running under Sybase. I've tried changing > various "performa

Re: [GENERAL] Very slow queries on 8.1

2005-11-17 Thread David Rysdam
Martijn van Oosterhout wrote: On Thu, Nov 17, 2005 at 11:31:27AM -0500, David Rysdam wrote: Right, it's about 100k rows and it is through libpq (pgadmin in this case, but my app uses libpq from pgtcl). Is there a way to tell libpq to not do what it "likes" and do what I need instead? I di

Re: [GENERAL] Very slow queries on 8.1

2005-11-17 Thread David Rysdam
Bruno Wolff III wrote: On Thu, Nov 17, 2005 at 11:31:27 -0500, David Rysdam <[EMAIL PROTECTED]> wrote: Right, it's about 100k rows and it is through libpq (pgadmin in this case, but my app uses libpq from pgtcl). Is there a way to tell libpq to not do what it "likes" and do what I need in

Re: [GENERAL] Very slow queries on 8.1

2005-11-17 Thread Martijn van Oosterhout
On Thu, Nov 17, 2005 at 11:31:27AM -0500, David Rysdam wrote: > Right, it's about 100k rows and it is through libpq (pgadmin in this > case, but my app uses libpq from pgtcl). Is there a way to tell libpq > to not do what it "likes" and do what I need instead? I didn't see > anything in the do

Re: [GENERAL] Very slow queries on 8.1

2005-11-17 Thread Bruno Wolff III
On Thu, Nov 17, 2005 at 11:31:27 -0500, David Rysdam <[EMAIL PROTECTED]> wrote: > Right, it's about 100k rows and it is through libpq (pgadmin in this > case, but my app uses libpq from pgtcl). Is there a way to tell libpq > to not do what it "likes" and do what I need instead? I didn't see

Re: [GENERAL] Very slow queries on 8.1

2005-11-17 Thread Tom Lane
David Rysdam <[EMAIL PROTECTED]> writes: > Right, it's about 100k rows and it is through libpq (pgadmin in this > case, but my app uses libpq from pgtcl). Is there a way to tell libpq > to not do what it "likes" and do what I need instead? The only way ATM is to declare a cursor on the query an

Re: [GENERAL] Very slow queries on 8.1

2005-11-17 Thread David Rysdam
Tom Lane wrote: David Rysdam <[EMAIL PROTECTED]> writes: Right now, I'm working on a test case that involves a table with ~360k rows called "nb.sigs". My sample query is: select * from nb.sigs where signum > 25 With no index, explain says this query costs 11341. After CREATE INDEX on

Re: [GENERAL] Very slow queries on 8.1

2005-11-17 Thread David Rysdam
int4, not null and the index is unique. I even tried clustering on it to no avail. codeWarrior wrote: What is the data type for "signum" ??? "David Rysdam" <[EMAIL PROTECTED]> wrote in message news:[EMAIL PROTECTED] I'm porting an application from Sybase and I've noticed that similar

Re: [GENERAL] Very slow queries on 8.1

2005-11-17 Thread Tom Lane
David Rysdam <[EMAIL PROTECTED]> writes: > Right now, I'm working on a test case that involves a table with ~360k > rows called "nb.sigs". My sample query is: > select * from nb.sigs where signum > 25 > With no index, explain says this query costs 11341. After CREATE INDEX > on the signum f

Re: [GENERAL] Very slow queries on 8.1

2005-11-17 Thread codeWarrior
What is the data type for "signum" ??? "David Rysdam" <[EMAIL PROTECTED]> wrote in message news:[EMAIL PROTECTED] > I'm porting an application from Sybase and I've noticed that similar > application functions take 2 to 3 times longer on postgres than they used > to on the same machine running