Re: The database is very slow !

From: Jason Godden <jasongodden(at)optushome(dot)com(dot)au>
To: proghome(at)silesky(dot)com (krystoffff), pgsql-general(at)postgresql(dot)org
Subject: Re: The database is very slow !
Date: 2003-08-13 20:02:23
Message-ID: 200308140602.23274.jasongodden@optushome.com.au
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hi Kystof,

I haven't read the other suggestions but I'm running a db where some tables
and views have over a million records without any issues on similiar
hardware.

Out of curiosity - have you actually performance tuned your OS and the
postmaster (trhough postgres.conf)? If you haven't done any of these then I
wouldn't be surprised if the db was slow - i think the default install of
most linux distros leaves you with 32mb shared memory which makes your 700mb
of RAM useless. As far as 60 fields are concerned I doubt that would be a
problem although I've never used a table with more than 20 - anybody out
there know if number of fields on a table can create performance issues?

Lastly - how complicated are your indexes? If you have indexed every field on
that table then that could be an obvious issue. How many fields from the
table have foreign key constraints?

Let me know how you go,

Jason

On Wed, 13 Aug 2003 11:22 pm, krystoffff wrote:
> Thanks for your answers
>
> I just vacuumed the database just before a test, and it didn't change
> anything ... Sorry not to have mentionned it
>
> Any other suggestions ?
>
> ---------------------------(end of broadcast)---------------------------
> TIP 1: subscribe and unsubscribe commands go to majordomo(at)postgresql(dot)org

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2003-08-13 20:14:15 Re: more timeofday() and "set time zone" weirdness
Previous Message Rod Taylor 2003-08-13 19:54:19 Re: Why table has drop, but the foreign key still there?