| From: | Mathieu De Zutter <mathieu(at)dezutter(dot)org> |
|---|---|
| To: | Kevin Grittner <Kevin(dot)Grittner(at)wicourts(dot)gov> |
| Cc: | pgsql-performance(at)postgresql(dot)org |
| Subject: | Re: Choice of bitmap scan over index scan |
| Date: | 2010-01-10 15:43:40 |
| Message-ID: | d4468d971001100743m383e66fes126502a973984178@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-performance |
On Sun, Jan 10, 2010 at 4:18 PM, Kevin Grittner <Kevin(dot)Grittner(at)wicourts(dot)gov
> wrote:
> Mathieu De Zutter wrote:
>
> You didn't include any information on your hardware and OS, which can
> be very important. Also, what version of PostgreSQL is this?
> SELECT version(); output would be good.
>
Intel(R) Core(TM)2 Duo CPU E7200 @ 2.53GHz
2GB RAM
2x500GB RAID-1
Running Debian/Etch AMD64
PG version: PostgreSQL 8.3.8 on x86_64-pc-linux-gnu, compiled by GCC
gcc-4.3.real (Debian 4.3.2-1.1) 4.3.2
Server also runs DNS/Mail/Web/VCS/... for budget reasons.
Database size is 1-2 GB. Also running copies of it for testing/dev.
Kind regards,
Mathieu
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Kevin Grittner | 2010-01-10 15:53:51 | Re: Choice of bitmap scan over index scan |
| Previous Message | Kevin Grittner | 2010-01-10 15:18:10 | Re: Choice of bitmap scan over index scan |