hello again,
i did some mistakes, site-id was wrong in my simple select querys.
(interesting that no matches would take double time on 7.4)
here are the 'right' results, showing to me postgres 7.4 is slightly
slower with simple querys (but 1000-times faster with more complex
querys ;-)
wit
hello,
>Richard Huxton wrote:
>What I suggest:
>1. Compare the two postgresql.conf files and any other config settings and
>make sure you know what differences there are and why.
>2. Identify what queries seem to be the cause of the problem, and pick one you
>think is a good example.
>3. VA
On Saturday 17 April 2004 13:23, Development - multi.art.studio wrote:
> hello everyone,
>
> Richard Huxton wrote:
> >It's not using the date index because it's using the id index - there's
> > only 10 matches, so that looks like a good choice to me. It takes less
> > than 1ms, so I'm not sure this
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
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,
