| From: | Adrian von Bidder <avbidder(at)fortytwo(dot)ch> |
|---|---|
| To: | pgsql-general(at)postgresql(dot)org |
| Subject: | Re: What type of index should I use? |
| Date: | 2010-06-22 14:35:01 |
| Message-ID: | 201006221635.12151@fortytwo.ch |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
On Tuesday 22 June 2010 10.49:00 Dimitri Fontaine wrote:
> > I estimate the table will hold around 5,000 rows, never any more.
>
> It could be that you're better off without any index, depending on the
> size of rows you put in there, and the overall memory usage patterns you
> have.
I agree: don't overstimate the effect an index can have and don't
underestimate the cost of index updates.
Have you tested performance as it is? Spending time to tune that doesn't
need tuning is an interesting hobby, but probably nothing more :-)
cheers
-- vbi
--
Today is Pungenday, the 27th day of Confusion in the YOLD 3176
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Thom Brown | 2010-06-22 14:38:27 | Re: How to Insert and retrieve multilingual (Hindi "an Indian language") into PostgreSQL |
| Previous Message | Greg Sabino Mullane | 2010-06-22 13:51:35 | Re: No PL/PHP ? Any reason? |