| From: | "Scott Marlowe" <scott(dot)marlowe(at)gmail(dot)com> |
|---|---|
| To: | "Martin Gainty" <mgainty(at)hotmail(dot)com> |
| Cc: | "Steve Atkins" <steve(at)blighty(dot)com>, "pgsql-general General" <pgsql-general(at)postgresql(dot)org> |
| Subject: | Re: ideal server |
| Date: | 2008-10-17 22:53:51 |
| Message-ID: | dcc563d10810171553n5f921587mdb6bf061655fa166@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
On Fri, Oct 17, 2008 at 4:31 PM, Martin Gainty <mgainty(at)hotmail(dot)com> wrote:
> non-existent and/or improper DB design can impede your progress
>
> You'll need to get stats pack configured, run explain plain on your selects
> to
> determine which columns you will to need to index..
I think you're confusing oracle and pgsql a bit there. But yeah, he
needs to get all the stats collection stuff running and he should
consider a migration to 8.3 if he's not already there. At least 8.2
where current_query in the pg_stats_activity table is very cheap and
can be turned on without slowing down an already slow server.
-- When fascism comes to America, it will be draped in a flag and
carrying a cross - Sinclair Lewis
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Richard Broersma | 2008-10-18 00:47:20 | Re: auto insert data every one minute |
| Previous Message | John Skillings | 2008-10-17 22:36:01 | Re: Copying Blobs between two tables using Insert stmt - [SOLUTION] |