Hi,I have done a tabledump from one of my tables on a fast server with PhpPgAdmin. It creates a list of INSERT queries. I had 11 000 of those queries.A couple of questions remain : * is there a limit on the number of records one can store in a PG-db, if you still want it to be fast? Anybody has a self-experienced maximum ?* When I tried to execute 100 insert's, it took 8 seconds. 200 inserts took 23 seconds (roughly). It is still busy importing the 11 000 inserts. What I want to know is: is this fast ? Is this good? Or am I running a too slow db ? Would it depend whether those queries are all the same or if they changed (let's say some update queries mixed with the inserts and ... ) ? The db is used to track page visits (like described in the article on this site). Won't it grow too big this way ?
Postgres : Benchmark ?
- Thread starter wxdqz
- Start date