On Sat, 10 Mar 2001, KoPra Workshop wrote:
>
>
> From: Stephan Szabo <sszabo@megazone23.bigpanda.com>
> Cc: <pgsql-admin@postgresql.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.