Talk About Network

Google


Register and Login
Nick
Password
Register create new account Sign up is FREE and you can post replies, new topics, bookmark posts and more!
Recover lost password


Data Bases > Pgsql General > Re: auto-vacuum...
Latest [ Topics | Posts ] Archive Post A New Topic Post a Reply
<< Topic < Post Post 4 of 6 Topic 15490 of 16987
Post > Topic >>

Re: auto-vacuum questions

by ahodgson@[EMAIL PROTECTED] (Alan Hodgson) May 8, 2008 at 10:58 AM

--nextPart4705209.i1Ozgy7g0c
Content-Type: text/plain;
  charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
Content-Disposition: inline

On Thursday 08 May 2008, John Gateley <gateley@[EMAIL PROTECTED]
> wrote:
> But the new database, mydbtest, always has slow queries.
> I run an analyze and they speed up.=20

Do the query plans actually change, or are you just seeing caching
effects=
=20
from running the analyze?

=2D-=20
Alan

--nextPart4705209.i1Ozgy7g0c
Content-Type: application/pgp-signature; name=signature.asc 
Content-Description: This is a digitally signed message part.

-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.6 (GNU/Linux)

iD8DBQBIIz9aJmf5OzX07HQRApJRAKCbnQBzspPZEOhLGHzigy/+3aBKqACffEOE
N9ndr0NpFFQOLOF1CAmZ3ds=
=ChDy
-----END PGP SIGNATURE-----

--nextPart4705209.i1Ozgy7g0c--
 




 6 Posts in Topic:
auto-vacuum questions
gateley@[EMAIL PROTECTED]  2008-05-08 09:43:02 
Re: auto-vacuum questions
alvherre@[EMAIL PROTECTED  2008-05-08 10:54:32 
Re: auto-vacuum questions
gateley@[EMAIL PROTECTED]  2008-05-08 10:04:20 
Re: auto-vacuum questions
ahodgson@[EMAIL PROTECTED  2008-05-08 10:58:47 
Re: auto-vacuum questions
gateley@[EMAIL PROTECTED]  2008-05-08 13:10:12 
Re: auto-vacuum questions
scott.marlowe@[EMAIL PROT  2008-05-09 01:17:23 

Post A Reply:
  Go here to Signup

AddThis Feed Button


About - Advertising - Contact - Frequently Asked Questions - Privacy Policy - Terms of Use - Signup

Contact
tan12V112 Tue Oct 14 10:31:18 CDT 2008.