I noticed a bit of a performance regression in embedded sql queries when
moving from the client libraries in verison 8.2.4 to 8.3.7. My
application does a whole lot of queries, many of which don't return any
data. When we moved to the new libraries the time of running a query
(from the applicati
>-Original Message-
>From: Albe Laurenz [mailto:laurenz.a...@wien.gv.at]
>>
>> const char *SQL_text = "select * from foo"; (not always
>the same query)
>> exec sql prepare s_1ab from :SQL_text; < [*1]
>> exec sql declare c_1ab cursor for s_1ab;
>> exec sql open c_1
>-Original Message-
>From: Albe Laurenz [mailto:laurenz.a...@wien.gv.at]
>Eric Haszlakiewicz wrote:
>> const char *SQL_text = "select * from foo"; (not always
>the same query)
>> exec sql prepare s_1ab from :SQL_text; < [*1]
>> exec sql declare c_1ab cursor for s_1ab;
>
>-Original Message-
>From: pgsql-performance-ow...@postgresql.org
>
>When users count in Postgres database reaches up to 500 000 - database
>command of creating users 'CREATE USER' slows down to 5-10
>seconds per user.
>
>What could be a reason of this problem and is there any solution ho
>-Original Message-
>From: pgsql-performance-ow...@postgresql.org
>
>We use a typical counter within a transaction to generate
>order sequence number and update the next sequence number.
>This is a simple next counter - nothing fancy about it. When
>multiple clients are concurrently a
>-Original Message-
>From: pgsql-performance-ow...@postgresql.org [mailto:pgsql-performance-
>
>> Hi everyone,
>> What is the best Linux flavor for server which runs postgres alone.
>> The postgres must handle greater number of database around 200+.
>Performance
>> on speed is the vit
