| From: | Stephan Szabo <sszabo(at)megazone23(dot)bigpanda(dot)com> |
|---|---|
| To: | KoPra Workshop <kopraworkshop(at)telkom(dot)net> |
| Cc: | pgsql-admin(at)postgresql(dot)org |
| Subject: | Re: Optimizing Advice...Now please |
| Date: | 2001-03-10 01:25:28 |
| Message-ID: | Pine.BSF.4.21.0103091723070.82618-100000@megazone23.bigpanda.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-admin |
On Sat, 10 Mar 2001, KoPra Workshop wrote:
>
>
> From: Stephan Szabo <sszabo(at)megazone23(dot)bigpanda(dot)com>
> Cc: <pgsql-admin(at)postgresql(dot)org>
> >
> > Generally, we'll need schema and query in question.
>
> I'm newbie ...
> your meaning with schema is the table structure....?
Yeah, basically table structure , rules, triggers and indexes (probably
just tables and indexes in most cases.
The query and the output from EXPLAIN query is useful (for example if it's
select * from foo; do an EXPLAIN select * from foo;) because it gives info
on what the optimizer thinks is the best plan.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Sherwin Daganato | 2001-03-10 09:55:21 | Re(3): Postgres/Postmaster logging and log rotation |
| Previous Message | KoPra Workshop | 2001-03-10 00:19:58 | Re: Optimizing Advice...Now please |