SHIVESH WANGRUNGVICHAISRI wrote:
> The main question is: how do I configure Postgresql such that
> it's most efficient for storing large BLOB at a high-rate?
Refering to what you wrote on the web site you quoted,
I would guess that neither tuning WAL nor tuning logging
will have much effect.
My
> It really has very little impact. It only affects index scans, and
> even then only if effective_cache_size is less than the size of the
> table.
>
> Essentially, when this kicks in, it models the effect that if you are
> index scanning a table much larger than the size of your cache, you
> migh
On Thu, Jul 16, 2009 at 6:30 PM, Kevin
Grittner wrote:
> Marc Cousin wrote:
>
>> As mentionned in another mail from the thread (from Richard Huxton),
>> I felt this message in the documentation a bit misleading :
>>
>> effective_cache_size (integer)
>> Sets the planner's assumption about the effe
Hi,
I posted this question at stackoverflow. Please follow there to see the
question in a nice format as I also posted the code that I used for
benchmarking.
http://stackoverflow.com/questions/1174848/postgresql-inserting-blob-at-
a-high-rate
The main question is: how do I configure Pos
On Wed, Jul 8, 2009 at 2:50 AM, Gnanam wrote:
> I'm using both IN and ANY() operators extensively my application. Can
> anybody answer me on the following questions:
> 1) Which operator is advantage over the another, interms of
> performance?
> 2) If I've indexed these columns, will
Hello!
I posted you a message about slowness of creation users more than 500 000
(#4919). It seems there is no workaround of this problem because of using
pg_auth flat file.
To override this problem is it possible to use LDAP authentification metod
to identify each user and speed up system?
