于 2012/6/9 22:39, Kevin Grittner 写道:
Rural Hunter wrote:
于 2012/6/9 0:39, Kevin Grittner 写道:
name | current_setting
full_page_writes | off
There may be exceptions on some file systems, but generally turning
this off leaves you vulnerable to possible database corruption if you
OS or
On Wed, May 30, 2012 at 2:06 AM, Tatsuo Ishii wrote:
>> Yeah, Jeff's experiments indicated that the remaining bottleneck is lock
>> management in the server. What I fixed so far on the pg_dump side
>> should be enough to let partial dumps run at reasonable speed even if
>> the whole database cont
On Sat, Jun 9, 2012 at 7:58 PM, Kevin Kempter
wrote:
> Hi All;
>
> We have a client that has a table where large blobs (bytea) are stored. the
> table has a key column that is numbers (like 112362) but unfortunately it's
> a varchar column so the blobs are accessed via queries like:
>
> select * f
What is the expected performance of cluster and what tuning parameters
have most effect?
I have a set of 5 tables with identical structure (all inherit a common
table). The sizes given are total relation size. The clustering index is
a gist index on a (non null) geographic(linestring) column
