Re: postgre performance question - Mailing list pgsql-general

From Joerg Hessdoerfer
Subject Re: postgre performance question
Date
Msg-id 200203071554.QAA00528@localhost.localdomain
Whole thread Raw
In response to Re: postgre performance question  (Ioannis <Ioannis.Kappas@dante.org.uk>)
List pgsql-general
On Monday 04 March 2002 15:07, you wrote:
> ....and I really do run vacuum when I clean the table.
>

Yes, but did you run 'vacuum analyze' on the filled DB? Else, your indices
will not be used...

If so, could you provide us with table structure, query and query plan?

> Is this the expected performance (a question to those who manage so big
> tables), or there might be something wrong with the configuration?
>
> Thanks again,
> Ioannis
>
> At 08:46 04/03/02 -0500, Doug McNaught wrote:
> >Ioannis <Ioannis@dante.org.uk> writes:
> > > Hello,
> > >
> > >     I am using a PostgreSQL database and I recently ran to some
> > > problems.
> > >     I have a table of around two hunded thousand entries (each entry is
> > >     78 bytes) and a simple (selct * from table) query takes a lot of
> > > time to
> > >     complete). Moreover a (select * from table where column = (select
> > > oid from another_table)) takes several tens of minutes. An index is
> > > already used for `column'.
> > >     The `another_table' has something like 200 entries, while column
> > > takes its values from the OIDs of `another_table'.
> >
> >Sounds as if you're not running VACUUM.
> >
> >-Doug
> >--
> >Let us cross over the river, and rest under the shade of the trees.
> >    --T. J. Jackson, 1863
>
> ---------------------------(end of broadcast)---------------------------
> TIP 6: Have you searched our list archives?
>
> http://archives.postgresql.org

Greetings,
    Joerg
--
Leading SW developer  - S.E.A GmbH
Mail: joerg.hessdoerfer@sea-gmbh.com
WWW:  http://www.sea-gmbh.com

pgsql-general by date:

Previous
From: Stephan Szabo
Date:
Subject: Re: Migration problem - serial fields
Next
From: Joerg Hessdoerfer
Date:
Subject: Re: error