Re: [PERFORM] problem with pg_statistics

2003-06-27 Thread Andre Schubert
On Thu, 26 Jun 2003 12:03:52 -0400 Tom Lane [EMAIL PROTECTED] wrote: Manfred Koizar [EMAIL PROTECTED] writes: On Thu, 26 Jun 2003 10:08:05 -0400, Tom Lane [EMAIL PROTECTED] wrote: Try reducing random_page_cost With index scan cost being more than 25 * seq scan cost, I guess that -

Re: [PERFORM] problem with pg_statistics

2003-06-27 Thread Manfred Koizar
On Fri, 27 Jun 2003 08:07:35 +0200, Andre Schubert [EMAIL PROTECTED] wrote: Traffic data are inserted every 5 minutes with the actual datetime of the transaction, thatswhy the table should be physically order by time_stamp. So I'd expect a correlation of nearly 1. Why do your statistics show a

Re: [PERFORM] problem with pg_statistics

2003-06-27 Thread Andre Schubert
On Fri, 27 Jun 2003 10:43:01 +0200 Manfred Koizar [EMAIL PROTECTED] wrote: On Fri, 27 Jun 2003 08:07:35 +0200, Andre Schubert [EMAIL PROTECTED] wrote: Traffic data are inserted every 5 minutes with the actual datetime of the transaction, thatswhy the table should be physically order by

Re: [PERFORM] Memory question

2003-06-27 Thread Josh Berkus
Patrick, Sorry for posting an obvious Linux question, but have any of you encountered this and how have you fixed it. I have 6gig Ram box. I've set my shmmax to 307200. The database starts up fine without any issues. As soon as a query is ran or a FTP process to the server is done,

Re: [PERFORM] Memory question

2003-06-27 Thread Jord Tanner
On Fri, 2003-06-27 at 12:09, Patrick Hatcher wrote: I have 6gig Ram box. I've set my shmmax to 307200. The database starts up fine without any issues. As soon as a query is ran or a FTP process to the server is done, the used memory shoots up and appears to never be released. In

Re: [PERFORM] Memory question

2003-06-27 Thread Arjen van der Meijden
I've heard that too, but it doesn't seem to make much sense to me. If you get to the point where your machine is _needing_ 2GB of swap then something has gone horribly wrong (or you just need more RAM in the machine) and it will just crawl until the kernel kills off whatever process