[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

[ale] Postgresql capabilities question


-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1


> However, the combined table would be around 95000 rows in size.
> 
> Having never really used Postgresql in the past, and unable to find a
> datapoint on the web, I would really like to get input from current users.

I would not worry about 95,000 - it's really not that big as far as 
databases go. As you stated, proper indexing and SQL tuning is far 
more important. Also remember to change the defaults in your postgresql.conf 
file: they are set to allow Postgres to run on a wide range of platforms, 
and thus are pretty crappy performance-wise.

- --
Greg Sabino Mullane  greg at turnstep.com
PGP Key: 0x14964AC8 200304021145

-----BEGIN PGP SIGNATURE-----
Comment: http://www.turnstep.com/pgp.html

iD8DBQE+icOZvJuQZxSWSsgRAtPtAKCVPYjKZw1dX5m4gYKKFUGlHU7wWACePjwV
GCmWdDzMZoxpeap9dSdefhA=
=zDNO
-----END PGP SIGNATURE-----


_______________________________________________
Ale mailing list
Ale at ale.org
http://www.ale.org/mailman/listinfo/ale