RE: [ADMIN] Data out of alignment?

First let me start out by saying I have not looked at the Postgres source, thus this is pure speculation until confirmed by someone who knows for sure. If you store data in a btree type of format (which I believe is how Postgres stores data, or at least indexes) and then you perform a full query

RE: [ADMIN] Drastic reduction in speed

My guess would be the startup scripts in this case. Possibly you are starting postgres without the -o -F options, which would cause it to be considerably slower... Gregory S. Youngblood ext 2164     -Original Message- From: Darren Greer [mailto:[EMAIL PROTECTED]] Sent: Tuesday, August

[ADMIN] Please help with performance tuning on Postgres

I have a database running fine, however, it is purely stock configuration. I would like to fine tune it for better performance and to control memory usage. I have seen people refer to restricting the number of back end processes, and fine tuning maximum memory consumption as well as other items.

RE: [ADMIN] COPY slows down; is it normal?

I dont know if this will help, but you could try a vacuum command. Just be patient, it can run for quite a while... Gregory S. Youngblood ext 2164     -Original Message- From: Gene Selkov Jr. [mailto:[EMAIL PROTECTED]] Sent: Thursday, October 01, 1998 1:49 PM To: [EMAIL PROTECTED] Subje