ql-general@postgresql.org
Date: 01/25/2010 09:57 PM
Subject: [GENERAL] general questions postgresql performance config
Sent by:pgsql-general-ow...@postgresql.org
Dear postgresql people,
Introduction
Today I've been given the task to proceed with my plan to use postgresql
Andy Colson wrote:
I recall seeing someplace that you can avoid WAL if you start a
transaction, then truncate the table, then start a COPY.
Is that correct? Still hold true? Would it make a lot of difference?
That is correct, still true, and can make a moderate amount of
difference if the
On 1/25/2010 8:12 PM, Craig Ringer wrote:
On 26/01/2010 12:15 AM, Dino Vliet wrote:
5) Other considerations?
Even better is to use COPY to load large chunks of data. libpq provides
access to the COPY interface if you feel like some C coding. The JDBC
driver (dev version only so far) now prov
On Mon, Jan 25, 2010 at 9:15 AM, Dino Vliet wrote:
>
> Introduction
> Today I've been given the task to proceed with my plan to use postgresql and
> other open source techniques to demonstrate to the management of my
> department the usefullness and the "cost savings" potential that lies ahead.
On 26/01/2010 12:15 AM, Dino Vliet wrote:
5) Other considerations?
To get optimal performance for bulk loading you'll want to do concurrent
data loading over several connections - up to as many as you have disk
spindles. Each connection will individually be slower, but the overall
throughp
Dear postgresql people,
Introduction
Today I've been given the task to proceed with my plan to use postgresql and
other open source techniques to demonstrate to the management of my department
the usefullness and the "cost savings" potential that lies ahead. You can guess
how excited I am r
