Re: [PERFORM] Windows XP selects are very slow

2007-11-28 Thread Usama Munir Dar
PG generally comes with very basic default settings, one *start* maybe this page for you http://www.webservices.uiuc.edu/postgresql/ Then obviously you will need to work though your query plans and iterate. Shadkam Islam wrote: Hi All, We are having a table whose data we need to bucketize an

Re: [PERFORM] Windows XP selects are very slow

2007-11-28 Thread Richard Huxton
Shadkam Islam wrote: Hi All, We are having a table whose data we need to bucketize and show. This is a continuously growing table (archival is a way to trim it to size). We are facing 2 issues here: 1. When the records in the table are in the range of 10K, it works fine for some time after star

[PERFORM] Windows XP selects are very slow

2007-11-28 Thread Shadkam Islam
Hi All, We are having a table whose data we need to bucketize and show. This is a continuously growing table (archival is a way to trim it to size). We are facing 2 issues here: 1. When the records in the table are in the range of 10K, it works fine for some time after starting postgres server. B