Re: [PERFORM] Feature Request --- was: PostgreSQL Performance Tuning

2007-05-01 Thread david
On Tue, 1 May 2007, Greg Smith wrote: On Tue, 1 May 2007, Josh Berkus wrote: there is no standard way even within Linux to describe CPUs, for example. Collecting available disk space information is even worse. So I'd like some help on this portion. what type of description of the CPU's a

Re: [PERFORM] Feature Request --- was: PostgreSQL Performance Tuning

2007-05-01 Thread Greg Smith
On Tue, 1 May 2007, Josh Berkus wrote: there is no standard way even within Linux to describe CPUs, for example. Collecting available disk space information is even worse. So I'd like some help on this portion. I'm not fooled--secretly you and your co-workers laugh at how easy this is on So

Re: [PERFORM] Feature Request --- was: PostgreSQL Performance Tuning

2007-05-01 Thread Greg Smith
On Mon, 30 Apr 2007, Kevin Hunter wrote: I recognize that PostgreSQL and MySQL try to address different problem-areas, but is this one reason why a lot of people with whom I talk prefer MySQL? Because PostgreSQL is so "slooow" out of the box? It doesn't help, but there are many other differen

Re: [PERFORM] Feature Request --- was: PostgreSQL Performance Tuning

2007-05-01 Thread david
On Tue, 1 May 2007, Carlos Moreno wrote: large problem from a slog perspective; there is no standard way even within Linux to describe CPUs, for example. Collecting available disk space information is even worse. So I'd like some help on this portion. Quite likely, naiveness follows...

Re: [PERFORM] Feature Request --- was: PostgreSQL Performance Tuning

2007-05-01 Thread Carlos Moreno
large problem from a slog perspective; there is no standard way even within Linux to describe CPUs, for example. Collecting available disk space information is even worse. So I'd like some help on this portion. Quite likely, naiveness follows... But, aren't things like /proc/cpuinfo , /

Re: [PERFORM] index structure for 114-dimension vector

2007-05-01 Thread Alexander Staubo
On 5/1/07, Andrew Lazarus <[EMAIL PROTECTED]> wrote: Let me just thank the list, especially for the references. (I found similar papers myself with Google: and to think I have a university library alumni card and barely need it any more!) I'll write again on the sorts of results I get. Looking

Re: [PERFORM] index structure for 114-dimension vector

2007-05-01 Thread Andrew Lazarus
Let me just thank the list, especially for the references. (I found similar papers myself with Google: and to think I have a university library alumni card and barely need it any more!) I'll write again on the sorts of results I get. BEGIN:VCARD VERSION:2.1 N:Lazarus;Andrew;;;Ph.D. FN:Andrew Lazar

Re: [PERFORM] sytem log audit/reporting and psql

2007-05-01 Thread Andreas Haumer
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Hi! Fei Liu schrieb: [...] > > Now here are my questions: These are a lot of questions, and some of them are not related to pgsql-performance or even PostgreSQL. I'll try to answer some of them, because I'm currently experimenting with partitioned

Re: [PERFORM] Feature Request --- was: PostgreSQL Performance Tuning

2007-05-01 Thread Josh Berkus
Greg, > 1) Collect up data about their system (memory, disk layout), find out a > bit about their apps/workload, and generate a config file based on that. We could start with this. Where I bogged down is that collecting system information about several different operating systems ... and in som