[GENERAL] How to time several queries?

Hello I know it is possible to time isolated queries through the settting of the \timing option in psql. This makes PgSQL report the time it took to perform one operation. I would like to know how one can get a time summary of many operations, if it is at all possible. Thank you. Tim

[GENERAL] Information about storge engine in PostgreSQL

Hello MySQL has information about several storage engines. MEMORY to handle temporary tables, InnoDB to handle transactions and which also can split its table data over several files/partitions. Splitting of storage is something which according to the following article, PostgreSQL does not support

Re: [GENERAL] Information about storge engine in PostgreSQL

I really appreciate these type of high-quality anwsers, thank you. Tim > On 10/21/2004 10:27 AM, [EMAIL PROTECTED] wrote: > >> Hello >> >> MySQL has information about several storage engines. MEMORY to handle >> temporary tables, InnoDB to handle transactions and which also can split >> its table

[GENERAL] PgSQL MVCC vs MySQL InnoDB

Hello Harrison Fisk from MySQL claims in this thread: http://forums.mysql.com/read.php?35,3981,4245#msg-4245 That there are no major differences between InnoDB and MVCC concurrency. Is this true? Thank you. Tim ---(end of broadcast)--- TIP 3:

[GENERAL] The reasoning behind having several features outside of source?

Hello Why is it that PostgreSQL chooses to have features like replication, fulltext indexing and GIS maintained by others outside of the sourcetree? I appreciate any answers. Thank you. Tim ---(end of broadcast)--- TIP 6: Have you searched o

[GENERAL] Reasoning behind process instead of thread based arch?

Hello! I have a couple of final ( I hope, for your sake ) questions regarding PostgreSQL. I understand PostgreSQL uses processes rather than threads. I found this statement in the archives: "The developers agree that multiple processes provide more benefits (mostly in stability and robustness) t

Re: [GENERAL] Reasoning behind process instead of thread based

>Two: If a > single process in a multi-process application crashes, that process > alone dies. The buffer is flushed, and all the other child processes > continue happily along. In a multi-threaded environment, when one > thread dies, they all die. So this means that if a single connection thr

Re: [GENERAL] The reasoning behind having several features outside

Jeff Davis wrote: > Other people have answered, but I'd like to add: > > It makes it much faster to fix bugs and improve features in the projects > outside of the source tree. If replication has a bug, you don't want to > wait for the next point release, you want a fix *now*. PostgreSQL is a > big

[GENERAL] Level of replication support?

Hello I am going to do a comparison betweem PgSQL and MySQL replication system. I hear there are some replication projects available for PgSQL. Which are still active and serious, because I hear that some are not active or incomplete? Will any of these projects be merged with PgSQL soon? I app

[GENERAL] Does PostgreSQL provide anything comparable with MySQL Cluster?

Hello Does PostgreSQL provide anything comparable with the functionality of MySQL Cluster? I appreciate all information. Thank you. Tim ---(end of broadcast)--- TIP 3: if posting/reading through Usenet, please send an appropriate subscribe