Re: [PERFORM] Caching of Queries

2004-09-25 Thread Gaetano Mendola
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Joshua D. Drake wrote: | |>>Sorry, I meant 30,000 with 300 connections - not 3,000. The 300 |>>connections |>>/ second is realistic, if not underestimated. As is the nature of |>>our site |>>(realtime information about online gaming), there's a huge f

Re: [PERFORM] Caching of Queries (now with pgpool)

2004-09-25 Thread Gaetano Mendola
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Michael Adler wrote: | On Thu, Sep 23, 2004 at 09:23:51PM -0400, Jason Coene wrote: | |>I ran some previous queries to get pgpool to pre-establish all the |>connections, and ab ran for a few minutes (with one query per page, eek!). |>It was still exhibi

Re: [PERFORM] Cleaning up indexes

2004-09-25 Thread Bruce Momjian
Martin Foster wrote: > My database was converted from MySQL a while back and has maintained all > of the indexes which were previously used. Tt the time however, there > were limitations on the way PostgreSQL handled the indexes compared to > MySQL. > > Meaning that under MySQL, it would make