pg.ddx.io  pgsql-performance@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Robert Haas <robertmhaas@gmail.com>
To: Kevin Grittner <Kevin.Grittner@wicourts.gov>
Cc: Aaron Guyon <battlemage@gmail.com>
Cc: pgsql-performance@postgresql.org
Subject: Re: Postgres 8.3, four times slower queries?
Date: Thu, 5 Mar 2009 14:15:27 -0500
Message-ID: <603c8f070903051115h58643593rb5f6301f3d5cf988@mail.gmail.com> (raw)
In-Reply-To: <49AFCC30.EE98.0025.0@wicourts.gov>
References: <f0afbb9b0903021618w616f1158t84dbf119f0b72c70@mail.gmail.com>
	<2870.1236050632@sss.pgh.pa.us>
	<f0afbb9b0903030931g7b219137n2954cf058d523e52@mail.gmail.com>
	<17797.1236119652@sss.pgh.pa.us>
	<f0afbb9b0903041520u25aae965y6abc15d39644eb5b@mail.gmail.com>
	<f0afbb9b0903041542q55e714c9g154461517f958de6@mail.gmail.com>
	<f0afbb9b0903050806s2def04b7q95c8f05667623377@mail.gmail.com>
	<49AFCC30.EE98.0025.0@wicourts.gov>

On Thu, Mar 5, 2009 at 1:57 PM, Kevin Grittner
<Kevin.Grittner@wicourts.gov> wrote:
>>>> Aaron Guyon <battlemage@gmail.com> wrote:
>> 8.3.3: 1195 ms
>> 8.2.12: 611 ms
>
> Could you send the non-commented lines from the postgresql.conf files
> from both installations?
>
> If feasible, update to the latest bug-fix version of 8.3.
>
> Also, if you haven't already done so, try setting effective_cache_size
> = '3GB' and random_page_cost = 2 for the 8.3 database and restart to
> see what kind of plan you get.

I still there's a problem with that index, now it's called
idx_payment_amount_payment_id.  What do you get from this?

select * from pg_index where indexrelid =
'idx_payment_amount_payment_id'::regclass;

Have you tried:

reindex table payment_amount

...Robert



view thread (16+ messages)  latest in thread

Message-ID: <603c8f070903051115h58643593rb5f6301f3d5cf988@mail.gmail.com>
Permalink:  ../603c8f070903051115h58643593rb5f6301f3d5cf988@mail.gmail.com/
Also on:    postgresql.org/message-id/603c8f070903051115h58643593rb5f6301f3d5cf988@mail.gmail.com

 · 

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients from your mail client; the link fills in
  the headers below: reply via email
  Some clients, webmail especially, drop In-Reply-To and References from
  a link, and the reply then starts a new thread: use the mbox below.

  To: pgsql-performance@postgresql.org
  Cc: robertmhaas@gmail.com, Kevin.Grittner@wicourts.gov, battlemage@gmail.com
  Subject: Re: Postgres 8.3, four times slower queries?
  In-Reply-To: <603c8f070903051115h58643593rb5f6301f3d5cf988@mail.gmail.com>
  References: <f0afbb9b0903021618w616f1158t84dbf119f0b72c70@mail.gmail.com> <2870.1236050632@sss.pgh.pa.us> <f0afbb9b0903030931g7b219137n2954cf058d523e52@mail.gmail.com> <17797.1236119652@sss.pgh.pa.us> <f0afbb9b0903041520u25aae965y6abc15d39644eb5b@mail.gmail.com> <f0afbb9b0903041542q55e714c9g154461517f958de6@mail.gmail.com> <f0afbb9b0903050806s2def04b7q95c8f05667623377@mail.gmail.com> <49AFCC30.EE98.0025.0@wicourts.gov> <603c8f070903051115h58643593rb5f6301f3d5cf988@mail.gmail.com>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox