I was just trying the home page...some selects are run on every page but as far as I know that's it. The machine's got plenty of memory and this is a very basic application with probably less than 1MB data total.
On Oct 29, 7:59 am, Johann Spies <johann.sp...@gmail.com> wrote: > On 29 October 2010 08:53, Chris <partyonais...@gmail.com> wrote: > > > Hey, > > > I've noticed some serious slowdowns ever since I switched from SQLite > > to Postgres. Pages will take MINUTES to load - it's kind of > > fascinating. > > I have been using both SQLITE and Postgresql (sometimes with the same > content) and did not notice a slowdown. Some of my datasets are quite > large (a dump of a present project's database is about 3G) and I don't > experience any problem on Postgresql. > > What exactly were you doing when you noticed this? Inserts? Queries? > CSV-downloads? How much data? How much ram available? > > Regards > Johann > > -- > May grace and peace be yours in abundance through the full knowledge > of God and of Jesus our Lord! His divine power has given us > everything we need for life and godliness through the full knowledge > of the one who called us by his own glory and excellence. > 2 Pet. 1:2b,3a
