Re: Are 50 million rows a problem for postgres ? - Mailing list pgsql-admin

From Bruno Wolff III
Subject Re: Are 50 million rows a problem for postgres ?
Date
Msg-id 20030908131550.GC14906@wolff.to
Whole thread Raw
In response to Are 50 million rows a problem for postgres ?  (Vasilis Ventirozos <vendi@cosmoline.com>)
List pgsql-admin
On Mon, Sep 08, 2003 at 10:32:51 +0300,
  Vasilis Ventirozos <vendi@cosmoline.com> wrote:
> Hi all, i work in a telco and i have huge ammount of data, (50 million)
> but i see a lack of performance at huge tables with postgres,
> are 50 million rows the "limit" of postgres ? (with a good performance)
> i am waiting for 2004 2 billion records so i have to do something.
> Does anyone have a huge database to ask him some issues ?
>
> my hardware is good ,my indexes are good plz dont answer me something like use
> vacuum  :)

Well if you want specific answers, you need to give us some specific data.
For example, explain anaylze output for the slow queries and relevant
table definitions.

pgsql-admin by date:

Previous
From: Bruno Wolff III
Date:
Subject: Re: Performance Issues
Next
From: Bruno Wolff III
Date:
Subject: Re: Are 50 million rows a problem for postgres ?