Re: performance problem aftrer update from 7.1 to 7.4.2

Hello,

You are probably missing a step some where... I know you got your data
imported but you might try
using the pg_dump from 7.4.2 to grab the 7.1 database and import from
there. It sounds to me like you
are missing an index or something.

Also it would help if we new your data structure, if you could post an
explain from 7.1 and from 7.4 and
possibly the queries that you are running your tests against.

Sincerely,

Joshua D. Drake

Development - multi.art.studio wrote:

> Hello everyone,
>
> i just upgraded my old postgres-database from version 7.1 to 7.4.2.
> i dumped out my 7.1 database (with pg_dump from 7.1) as an sql-file
> with copy-commands and to one file using insert-statements.
>
> after initalizing and starting postgres 7.4 on a different port and
> datadirectory, i tried to import the sql-dump with the copy statements.
> this import fails, but importing the dump-file with inserts took a
> long time but was successfully.
> ok, at first i do a vacuum and analyze and fire up the database again.
> now i changed my php-scripts to use the new database as datasource.
>
> ok, things look good, but as i was testing some php-sciripts, i
> recognized that the querys took about 2 or 5 times longer :(
> a test a script which reads a lot of stuff from database, normaly with
> pgsql 7.1 it tooks about 4 seconds to display the data, but with
> postgres 7.4 it tooks about 25 seconds.
> i start the 7.4 pgsql the same way as 7.1 with postmaster -D
> /xxx/xxx/... -N512 -S -F -B2048 -i
> i also tried to kill some indexes and recreate them, but this doesnt
> matter and the query took the same long time to execute. i also tested
> some simple select querys, the will take longer time.
>
> if somebody could help me, and hints on how i can speed up my 'new'
> databse would be very nice :)
>
> thanks in advance
>
> yours
> volker
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 3: if posting/reading through Usenet, please send an appropriate
> subscribe-nomail command to majordomo(at)postgresql(dot)org so that your
> message can get through to the mailing list cleanly

--
Command Prompt, Inc., home of Mammoth PostgreSQL - S/ODBC and S/JDBC
Postgresql support, programming shared hosting and dedicated hosting.
+1-503-667-4564 - jd(at)commandprompt(dot)com - http://www.commandprompt.com
PostgreSQL Replicator -- production quality replication for PostgreSQL