Skip site navigation (1) Skip section navigation (2)

Re: 7.2 is slow?

From: "Zeugswetter Andreas SB SD" <ZeugswetterA(at)spardat(dot)at>
To: "Tom Lane" <tgl(at)sss(dot)pgh(dot)pa(dot)us>, "Hannu Krosing" <hannu(at)tm(dot)ee>
Cc: "Tatsuo Ishii" <t-ishii(at)sra(dot)co(dot)jp>, <pgsql-hackers(at)postgresql(dot)org>, <inxc(at)itmeedia(dot)ee>
Subject: Re: 7.2 is slow?
Date: 2001-12-19 10:38:28
Message-ID: 46C15C39FEB2C44BA555E356FBCD6FA4212873@m0114.s-mxs.net (view raw or flat)
Thread:
Lists: pgsql-hackers
> I think you are right that the difference between 7.1 and 7.2 may have
> more to do with the change in VACUUM strategy than anything else.  Could
> you retry the test after changing all the "vacuum" commands in pgbench.c
> to "vacuum full"?

Might there also be a difference in chosen query plans ?
Wasn't 7.1 more willing to choose an index over seq scan,
even though the scan would be faster in the single user case ?
Or was that change after 7.0 ?

The seq scan would be slower that the index in the case of 
many concurrent accesses.

Andreas

Responses

pgsql-hackers by date

Next:From: Daniel KalchevDate: 2001-12-19 10:53:54
Subject: Re: Thoughts on the location of configuration files, how
Previous:From: Thomas SwanDate: 2001-12-19 10:29:05
Subject: Re: Thoughts on the location of configuration files

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group