Re: [PERFORM] Slow performance

2011-09-05 Thread Kai Otto
am going to test another database to check the performance of the hardware. -Kai > -Original Message- > From: Kevin Grittner [mailto:kevin.gritt...@wicourts.gov] > Sent: Wednesday, August 31, 2011 8:59 PM > To: Kai Otto; pgsql-performance@postgresql.org > Subject: Re:

[PERFORM] Slow performance

2011-08-31 Thread Kai Otto
Hi all, I am running a simple query: SELECT * FROM public."Frame" Time taken: 35.833 ms (i.e. roughly 35 seconds) Number of rows: 121830 Number of columns: 38 This is extremely slow for a database server. Can anyone help me in finding the problem? Thanks, KOtto Client