Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
Thread:
Lists: pgsql-adminpgsql-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

pgsql-admin by date

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

pgsql-general by date

Next:From: Bruno Wolff IIIDate: 2003-03-27 20:05:09
Subject: Re: Data conversion in query
Previous:From: Doug McNaughtDate: 2003-03-27 19:56:14
Subject: Re: Data conversion in query

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group