On 1/23/09 3:35 AM, "da...@lang.hm" wrote:
http://techreport.com/articles.x/15931/1
one thing that both of these reviews show is that if you are doing a
significant amount of writing the X-25M is no better than a normal hard
drive (and much of the time in the middle to bottom of the pack compa
It may not be that possible with your schema, but when I had to restore a 2.5TB
database (with plenty fast I/O, it was never I/O bound) I used 3 or 4 copies of
pg_restore operating on different tables.
With the -Fc option, like a plain dump you can have it restore just certain
schemas or tables
>da...@lang.hm writes:
>> the poster who started this thread had a query where the parsing phase
>> took significantly longer than the planning stage.
> That was an anecdote utterly unsupported by evidence.
regards, tom lane
The issue of prepared statements having atrociou
