| From: | Stephan Szabo <sszabo(at)megazone23(dot)bigpanda(dot)com> |
|---|---|
| To: | Daniel Lundqvist <daniel(dot)lundqvist(at)bredband(dot)com> |
| Cc: | "pgsql-general (E-mail)" <pgsql-general(at)postgresql(dot)org> |
| Subject: | Re: tuning |
| Date: | 2001-08-30 16:01:09 |
| Message-ID: | Pine.BSF.4.21.0108300900161.53243-100000@megazone23.bigpanda.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
On Thu, 30 Aug 2001, Daniel Lundqvist wrote:
> I have a pgsql database containing DHCP lease informtation,one table for
> each month.
> As we get more and more customers there will be more rows in the tables. The
> table for august
> now contains about 2.7 million rows. There is about 5 inserts per second.
>
> Table definition:
>
> start | boolean
> ts | timestamp
> mac | macaddr
> port | character varying(50)
> ip | inet
>
> There are indexes on ts,mac,port and ip.
> Database is running under Linux 2.2 on a Compaq with a P3 800 and 256MB
> memory.
>
> Now for the problem :) I get what I think is very poor response times,about
> 90-140s to get a result when searching on ip.
>
> The only options I have set in postgresql.conf is:
> wal_files = 8
> wal_sync_method = fdatasync
>
> What can I do to tune this database besides memory upgrade and adding a
> additional CPU?
Have you been running vacuum analyze? What are the queries you're running
and what does explain show for them?
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Stephan Szabo | 2001-08-30 16:02:04 | Re: Re: Fw: [JDBC] Regarding vacuumdb |
| Previous Message | Jeff Eckermann | 2001-08-30 15:51:36 | Re: Solution found! was Re: Finding the number of rows affected by UPDATE or INSERT? |