Re: PostgreSQL + IDS load/latency help

From: philo vivero <phiviv(at)hacklab(dot)net>
To: Loki <loki(at)fatelabs(dot)com>
Cc: pgsql-admin(at)postgresql(dot)org
Subject: Re: PostgreSQL + IDS load/latency help
Date: 2003-03-27 20:05:08
Message-ID: 1048795508.2046.218.camel@timetop
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin pgsql-general

> We have a PostgreSQL database full of over 500,000 events.
> When the database has a small number of events, to
> retrieve a specific event stored in that db takes a mere
> few seconds.
>
> However, as the database grew in size to where it is now,
> it takes over 15-20 seconds to get information back from a
> query to that database. We have tried everything,
> including vacuum, which someone else recommended to me.

Sometimes it's the simple things. Did you do an explain on the query to
see its access plan? I see nothing in your post about indexes.

> Am I correct in saying that 500,000 events shouldn't be a
> problem? Is there anyone out there with more than 500,000
> events in their DB than what we currently have?

With proper indexes, 500,000,000 "events" shouldn't be a problem.

--
pv
If this helped you, http://svcs.affero.net/rm.php?r=philovivero

In response to

Browse pgsql-admin by date

  From Date Subject
Next Message Robert Treat 2003-03-27 20:07:23 Re: Database not restarting
Previous Message Hacksaw 2003-03-27 19:31:28 Re: Upgrading: So now you tell me!!?!?

Browse pgsql-general by date

  From Date Subject
Next Message Bruno Wolff III 2003-03-27 20:05:09 Re: Data conversion in query
Previous Message Doug McNaught 2003-03-27 19:56:14 Re: Data conversion in query